User Schema separation SQL Server 2005
As we know Schemas are very important in SQL Server. They play an important part in names of objects, Schemas work like container and contain DB Objects and they are securable. …
Read MoreGhost Records in SQL Server… Now whats that ????
I always wondered what happens when a row is deleted from a table.Does SQL server directly overwrites the record or makes it invalid or it does something which is undocumented.Little bit …
Read MoreTransparent Data Encryption in SQL Server 2008
Hi Friends, Many of you have seen some sample codes from Books online tht shows u how u can implement TDE. wht books online does not show u is (at least …
Read MoreSQL Server Engine Edition
(Note: Posting this again for a test) Hi Friends, Many of already know about different techniques to find out the edition of SQL Server that you are running. The simplest of …
Read MoreSQL Server Index Range query
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 …
Read MoreSQL 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: 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 More