The SQL Server 2008 Datetimeoffset Data Type
The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.
2014-03-28 (first published: 2011-04-18)
13,946 reads
James Skipwith
Custom Sequence Numbering
This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function
2013-06-14 (first published: 2011-02-07)
18,766 reads
Automatically Generate Stored Procedures
This article will show you how to automatically generate insert, update, and delete procedures for tables in your database
2013-01-01 (first published: 2011-02-10)
23,277 reads
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
does WITH (NOLOCK) hint in Select statement really make a difference?
In any regular Select query joining a few tables like below, does using this...
Ask SSC