SQL Server: Is Replication Recovery Model dependent ?
There is a myth that for replication to work properly the databases always have to be in Full recovery mode. Well that is not at all true. First let me give …
Read MoreAuthor: Sachin Nandanwar
SQL Server Phantom Reads In Repeatable read ??? I dont think so….
According to BOL Repeatable transaction isolation level will give a repeated (consistent) view of the data for that particular resultset in a transaction.Here is the exact definition “Specifies that statements cannot …
Read MoreSparse Columns in SQL Server 2008
Prior to SQL Server 2008 there was a lot of space wastage due to the storage of the NULL bitmaps for tracking NULL values in columns defined as NULL.SQL reserves the …
Read MoreSQL Multiply all values in a column
Hi, Most of you reading this blog must be aware that SQL Server has an aggregate function called SUM to add all the values in a column.But what if you want …
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 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: 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 More