Category Archives: SQL Server

SQL Server

Meme Monday – 9 Non-Disk Problems

Thomas LaRock has launched the second Meme Monday with “I got 99 problems but a disk ain’t one.” Continue reading

Posted in SQL Server | Tagged | Comments Off on Meme Monday – 9 Non-Disk Problems

WHERE NOT EXISTS in the Twelve Days of SQL

Would any of the participants in the Twelve Days of SQL chose the same favorite 2010 blog post as me? Continue reading

Posted in SQL Server | Tagged , | 3 Comments

T-SQL Tuesday #011 – Filtered Index and an Alternative

You need SQL Server 2008 to create a filtered index, but for earlier versions you might be able to use an alternative. Continue reading

Posted in SQL Server, T-SQL Tuesday | Tagged | 8 Comments

T-SQL Tuesday #010 – Constraints & Unused Indexes

An unused index might be a constraint that shouldn’t be dropped. Continue reading

Posted in SQL Server, T-SQL Tuesday | Tagged , | 6 Comments

Bulk Insert into View

A quick way to use T-SQL for inserting a text file into a table and getting line numbers. Continue reading

Posted in SQL Server | Tagged | 1 Comment