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 MoreSQL Server Education (by the geeks, for the geeks)
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 MoreAccording 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 MorePrior 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 MoreHi, 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 MoreI 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 MoreThere 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 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 …
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 …
Read More