Tag Archives: T-SQL

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