2011-04-01 (first published: 2008-02-23)
3,047 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)
45,897 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,876 reads
Blogs
Azure SQL Database Compatibility with SQL Server
By gorandalf
A long time ago, in early days of the Azure SQL Database in 2015,...
Custom deployment parameters in Azure Data Factory - Forget Me Not
By Rayis Imayev
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
Tempdb version store related question
Hi All, Recently, we observed the tempdb has grown out of proportion and filled...
about the option (fast n) and acutal execution plan
what kind of situation can I use "option (fast 1)" when I execute a...
Problem during the setup of SQL Server 2019
During the installation I come to the step of configuring the database engine. It...
Ask SSC