Columnstore Indexs

Columnstore Indexes for Fast DW

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

Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012

Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security.  This...

Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...

#Meme15: On Facebook

This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...

ColoradoSQL for March 2012

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those...

Cached blocking history with sys.dm_db_index_operational_stats

Transactions generate IO, latching  and  locking on tables and indexes  , while attempting to access data. The sys.dm_db_index_operational_stats  DMV returns aggregated data...

SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts

SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...