SQL 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 …
SQL Multiply all values in a column Read MoreSQL Server
SQL Server: Finding the Source database name/id against which Database Snapshot was created
Hi Friends, Interesting question – suppose a DBA has created a snapshot on a user database. You do not have access to the source/user database. You only have access to the …
SQL Server: Finding the Source database name/id against which Database Snapshot was created Read MoreUser 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. …
User Schema separation SQL Server 2005 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 …
Ghost Records in SQL Server… Now whats that ???? 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 …
Transparent Data Encryption in SQL Server 2008 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 …
SQL Server Engine Edition 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 …
SQL Server Index Range query 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 …
SQL Server: Sum of values for Time Slots 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 …
SQL Server: Restrict the use of NO_LOG and Truncate_Only 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 …
SQL Server: How does SQL Server treats NULL values ? Read More