SQL

I was working on a database since last couple of month. Suddenly it was slowing down day by day. I had not changes anything in the database...

You can change the database compatibility level through Management Studio. (Go to Database Properties - Option). Here is the script to ch...

A transaction must be: Atomic - It is one unit of work and does not dependent on previous and following transactions. Consistent - Dat...

User below query to find Database Size : SELECT  d.name AS [Database Name],         ROUND(SUM(mf.size) * 8 / 1024, 0) [Size (MB)] ...

Today, I want to optimize some some queries. I searched the net and found that we can use Database Engine Tuning Adviser for this. But I co...