2011-04-01 (first published: 2008-02-23)
2,966 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,600 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,828 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Txn log file is full. Error 9002
Hi All, Here is the scenario on of the test servers. The transaction log...
How to define data types
What are the things you consider when you create a new table and define...
What is the default data-type for columns made from an expression
In Microsoft SQL Server Management Studio 2014, when you execute the following statement: SELECT...
Ask SSC