SQL Server: Sum of values for Time Slots
I 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 …
Read MoreSQL Server
SQL Server: Restrict the use of NO_LOG and Truncate_Only
Restrict 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 …
Read MoreSQL Server: How does SQL Server treats NULL values ?
Definition 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 …
Read MoreSQL Server: Auto-Truncate Log in Full Recovery Model
Auto-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 …
Read MoreSQL Server Resource Database
Resource 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 …
Read MoreSQL Server Index Fill Factor
Index 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 …
Read More