2012-06-07
2,013 reads
2012-06-07
2,013 reads
2012-03-26
2,192 reads
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,721 reads
Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.
2010-03-01
7,359 reads
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
2009-11-30
13,590 reads
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Has the PK been used...
Comments posted to this topic are about the item Has the PK been used...
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers