2011-04-01 (first published: 2008-02-23)
3,764 reads
Adam Haines
Default trace - A Beginner's Guide
This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.
2010-06-11 (first published: 2008-11-11)
52,927 reads
Custom Pagination in SQL Server 2005
Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function.
2009-01-06
10,403 reads
Blogs
T-SQL Tuesday 188 - Growing the Younger Data Community and Speakers
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Azure Cloud Chronicles with Microsoft MVPs YouTube Channel
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
T-SQL Tuesday #188: Growing the Community
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
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