SQL Server Education (by the geeks, for the geeks)
There is a myth going around that for columns which are used as predicates always should have a clustered index which is backed up and recommended by Micorsoft http://technet.microsoft.com/en-us/library/ms190639. aspx Let us …
SQL Server Index Range query Read MoreI had a bit of an unusual task where I needed to find the sum of values in between specific time interval slot for dates.Below is a small sample of the …
SQL Server: Sum of values for Time Slots Read MoreRestrict the use of NO_LOG and Truncate_Only We use these commands to claim back the disk space when the size of transaction log goes beyond what was expected and takes all …
SQL Server: Restrict the use of NO_LOG and Truncate_Only Read MoreDefinition of NULL values.Extract from BOL A value of NULL indicates that the value is unknown. A value of NULL is different from an empty or zero value. No two null …
SQL Server: How does SQL Server treats NULL values ? Read MoreAuto-Truncate Log in Full Recovery Model FULL Recovery model: This means that all database changes are fully logged and ideally the log records should stay in the log file until the …
SQL Server: Auto-Truncate Log in Full Recovery Model Read MoreResource Database In this Post I am going to take you through the 5th system database which is available right from SQL Server 2005. As we know till SQL Server 2000 …
SQL Server Resource Database Read MoreIndex Fill Factor FILLFACTOR, The FILLFACTOR option allows you to allocate a percentage (0 to 100) of free space on the leaf-level index pages to reduce page splitting. This option is …
SQL Server Index Fill Factor Read More