Maintenance Plan Owner

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit...

Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned...

Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...

Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...

SQL Server : Parameter Sniffing

Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....

Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!

 
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...

Using SQL Server 2012 FileTables

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...

Generating Surrogate Keys With SSIS

A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...

Excellent SSIS 2012 Upgrade Video

This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC...