2011-04-01 (first published: 2008-02-23)
2,981 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)
44,954 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,841 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Understanding and Improving Query Plans
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip 7 Apr 2020
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC