PASS 2015 – Seattle WA – Day 3

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

T-SQL Querying and Query Processing Order

The order in which we write T-SQL queries happen in this order:

however, the order the Query Processor on SQL Server processes…

How to identify IDENTITY columns tables in a database

Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:

Views –…

How to take a database offline

Here is one way to take a database offline. This will prevent any reads, writes or even a connection to it (including any…