SQL 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 …
SQL Server: Is Replication Recovery Model dependent ? 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 …
SQL Server Phantom Reads In Repeatable read ??? I dont think so…. 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 …
Sparse Columns in SQL Server 2008 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 …
SQL Multiply all values in a column 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 …
Ghost Records in SQL Server… Now whats that ???? 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 …
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 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 More