The Journey to Katmai
I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming...
2007-07-04
658 reads
Blog Posts
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
597 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
605 reads
Working Remotely
Most people I know tend to work in one of two places consistently: work or home. So they've built a...
2007-07-03
569 reads
Earthquake
This is pretty cool, a, earthquake test for Project Black Box from Sun. They take one of their systems to...
2007-07-01
627 reads
SQL Server Error Logs
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,592 reads
The War Begins :: Reporting for duty
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,335 reads
Walking the Line
I have the best job here at SQLServerCentral.com. I work from home, I get to be creative, writing about what...
2007-06-28
1,364 reads
Debugging Stored Procedures in VS 2005
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,362 reads
Back to Work (Some days it flows)
My job here at SQLServerCentral.com is mainly as editor. This means that for the most part I edit articles, schedule...
2007-06-20
1,411 reads
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
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