Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...

Columnstore Indexs

Columnstore Indexes for Fast DW

The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...

Looking to Windows 9

I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...

Powershell - Working with Cluster Resources - Byte Arrays

Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...

RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...

Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes

As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can
find here the slides
& samples for download....

SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...

TDE and Compression

I knew that enabling TDE would cause the information stored within to, effectively, be randomized, which means it would seriously...

Troubleshooting Event ID 9 - The device, xxxxx, did not respond within the timeout period.

The System logs returned :
 The device, xxxxxxxxxxxxxx, did not respond within the timeout period.
 Some common causes
1)      SCSI controller  firmware
2)      Incorrect...

Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA

Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...