Posts Tagged: SQL Server 2008 R2

IndexSearch

Can You Dig It? – Determining Index Plan Usage

Posted by & filed under , , , , , , , , .

A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes.  The answer is, of course, yes, you can.  And it’s important that people, especially DBAs, understand how to do this.  Usually during index analysis, we concern ourselves with whether an index is being used. […]

1280077893_3db5ccd0e9_m.jpg

SSWUG SSIS Expo Event This Friday

Posted by & filed under , , , , , , .

If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave the comforts of your cubicle – this is your week.  This Friday (11/19/2011), SSWUG will be hosting an expo titled “Building and Developing with SQL Server Integration Services”. The event will consist of four sessions that will […]

Pain of the Week: Understanding Your Indexes

Posted by & filed under , , , , , .

Want to take a few minutes out of your day on to learn a bit more about indexes?  On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast.  The session will be Understanding Your Indexes: Operational Stats. There’s a lot that goes on under the covers of SQL Server with your indexes. But […]