Even though storage as a subsystem is cheap these days. We have seen DBA’s struggle to find Log files run out of space and stop transactions. Understanding size is a critical aspect, now tables data, index data, log data and mor...

From SQL Server 200 the use of XML has been more and more by applications. With SQL Server 2005 XML became a first class datatype and applications are likely to use more natively this datatype. What are the Basic 5 methods provi...

In any performance testing discussion for large development one of the common requirements has been to send a multiple values to SQL Server in one shot. So to help this requirement, SQL Server introduced the MERGE statement. Wha...

As an effective DBA it is critical to keep tap on the various server side databases. Recently was encountered with a Developer saying the “sys” schema objects were no longer in the MASTER database. Interestingly, what is the use...

Auditing is always fun when we do code reviews. And in a product backend check we found a lot of junk names for the Default constraints inside the database. What are the different ways you can create a CONSTRAINT inside SQL Serv...

Recently got a DBA who said the Log files was growing bigger than the data file size. On discussion he mentioned using CHECKPOINT to solve this problem. So what does CHECKPOINT do inside SQL Server? Does the behavior change base...

It is saying that where you should use nail, you should not use sword. Every little tool has its own usage and its own purpose. What are the differences of CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) datatypes?...

Compile and Recompile has very interesting meaning when learning Machine learning. However, the same thing has similar but very interesting effect in SQL Server. Many related compilation of the code with performance at some degr...

Some questions are good for debates. There are so many myths associated with few subjects that when the discussion starts it is hard to convince stubborn friend who is not read to accept the truth. Let me see you attempt both th...

Developer and DBA both sometime have their own priority and preferences when it is about database designs. If you are DBA or Developer you must learn cross domain expertise features. One of the similar features is DACPAC. What i...