2011-04-01 (first published: 2008-02-23)
2,865 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,005 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,790 reads
Blogs
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Investigating Azure Databricks
By Steve Jones
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...
Understanding Columnstore Indexes in SQL Server Part 3
My last two blogs were on understanding columnstore and creating columnstore indexes. In this...
Forums
The AI Manager
Comments posted to this topic are about the item The AI Manager
Convert smallint to Date
Hello! I have column in SQL 2012 DB of datatype smallint. Could you please...
Managed Instance Error Creating Recurring Schedule - BUG???
When we try to create a SQL Server Agent job schedule that has a...
Ask SSC