2011-04-01 (first published: 2008-02-23)
3,075 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)
46,184 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
9,895 reads
Blogs
Daily Coping 27 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
Forums
SQL permissions based on multiple AD Groups
Hi I'd like some input on the best way to handle setting permissions in...
The TUF File
Comments posted to this topic are about the item The TUF File
Delivering Patches Quickly
Comments posted to this topic are about the item Delivering Patches Quickly
Ask SSC