2011-04-01 (first published: 2008-02-23)
2,916 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)
43,837 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,804 reads
Blogs
Azure Data Studeo- Nov 2019 Release
By Vinay Thakur
SQL Server Management studio is now can be installed separately not part of SQL...
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
Forums
SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor
Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...
Basic Avaialbility setup but replicas went to resolving mode
Hi, I configured the Basic Alwayson setup in two of the test SQL standard...
I am looking to optimize this T-SQL Statement (it generates very High Reads..)
In the below SQL statement (also attached as DOC file) it has been...
Ask SSC