Tags » SQL Server 2008 R2

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

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?
  • 340 more words
DBA

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

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. 238 more words

DBA

T-SQL Script to check Powershell Version

You can write $host command on powershell prompt to check powershell version or you can execute the below T-SQL script to check the powershell version. 104 more words

SQL Server

Sql Server : How are these two rollbacks different?

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. 561 more words

DBA

Sql Server : How to query progress or percent complete ?

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. 181 more words

DBA

Sql Server : Difference between FREESYSTEMCACHE, FREEPROCCACHE, DROPCLEANBUFFERS, etc

Quick one today:

In a previous post, we discussed the different ways to clean Sql Server cache. Now we look at another one. DBCC FREESYSTEMCACHE. 123 more words

DBA

Sql Server Error Messages : Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

Quick one today:

A few weeks ago, we ran into an interesting error. This nebulous error has caused some confusion in the team, as it occurred during a high pressure situation. 226 more words

DBA