2011-04-01 (first published: 2008-02-23)
3,113 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,584 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,916 reads
Blogs
2020 Advent of Code–Day 3
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Welcome to the Azure Data Community, empowered by Microsoft
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
Daily Coping 24 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
trigger email alerts in case file is delivered or failed for the job
Hi all, I have two SQL jobs. These jobs execute SSIS packages and then...
SQL Server maximum Server Memory
I am using SQL Server 2008 R2 Express edition. I have already set Maximum...
Developer vs Enterprise
Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...
Ask SSC