As a follow up to my series on complex test databases , this article will cover one of the more interesting test databases that I recently created. Goal : Create a database that includes one table for each supported collation. Each table contains a single column with the various column level collations...

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question asked recently in the T-SQL MSDN forums where the solution, at first, seems extremely obvious. However, as solutions were proposed and flaws were discovered with the proposals, the interesting nature...

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a common programming interview question where we are asked to find the longest repeated substring in a given string, followed by different solutions and explanations from three of the more helpful and creative...

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question asked in the Transact-SQL MSDN Forums here , followed by three different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jens Suessmeyer, Naomi Nosonovsky...

Introduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question recently asked in the Transact-SQL MSDN Forums here , followed by four different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jingyang Li, Steven Wang...

The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released. Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features...