Sql Server : Why is a query with literals performs faster than a query with variables (parameter sniffing)

Posted by Sqltimes
On August 29, 2015
0 Comments

Quick one today: Let’s look at an Interesting, albeit, seemingly anomalous behavior with in Sql Server. Question When does a query with literals perform faster than query with variables? Even with a simple query. Let’s look at some examples: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 […]

Posted by Sqltimes
On August 22, 2015
0 Comments

Quick one today: As a Sql DBA, we need to continuously monitor different performance metrics to make sure the system is performing as expected and within acceptable limits. When we have VLDB’s, disk is always a critical one to monitor. In one such discussion, a few weeks ago, this point came up: What is the […]

Posted by Sqltimes
On August 12, 2015
0 Comments

Interesting topic today: Ran into a situation, for which, I could not find a better explanation. If anyone has a better idea or proof, please share with me. If it matters, the following tests are run on Sql Server 2008 R2. Question: Are these two Rollbacks different? Scenario 1: Run an ALTER table statement […]

Posted by Sqltimes
On August 8, 2015
0 Comments

Quick one today: Very often, we get this question about how to check the progress of certain long running activities. There are several ways to check different processes, but there is no single answer. The best answer is as always ‘it depends’ – because different processes takes different techniques. Today, we’ll look at one such […]

Sql Server : Why is a query with literals performs faster than a query with variables (parameter sniffing)

Sql Server Performance Metrics (perfmon) : What is the difference between PhysicalDisk and LogicalDisk

Sql Server : How are these two rollbacks different?

Sql Server : How to query progress or percent complete ?