Excellent, succinct example to prove it.

I played around with your example script by adding a third column on the "test" table, an IDENTITY, and searching on that column for...

Thanks for all of your responses.

So, the Optimizer will ignore all existing query plans in the cache and possibly implement a new one because it will be aware that a new index has been created?

Question:

If I create a new index to more effectively support a query in a stored procedure, what is the most appropriate action to take (if any action is required) to...

It depends.

On just about every interview I've ever been on.

This page from Paul Randal's blog may assist you:

http://www.sqlskills.com/blogs/paul/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

From Paul Randal's blog:

"275: ASYNC_NETWORK_IO - This is commonly where SQL Server is waiting for a client to finish consuming data. It could be that the client has asked for...

Jeff Moden (10/29/2012)For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions...

Don.,

Are you using a Touchstar system database?

Everything looks pretty good except for one thing that red flags that job description:

"Must have ability to work under pressure to meet tight delivery timelines."

It reminds me of other job...

Here's an excerpt from a job posting I'm looking at:

___________

BS/MS in Information Systems or related field

3+ years of Database Management.

Expert in MS SQL Server 2005 and 2008, with knowledge of...

I forgot to mention the job description I recently saw for a full-time DBA that said the applicant would have to provide their own laptop.

If this trend continues, employees will...

This observation may or may not be helpful.

I couldn't help but notice your WHERE clause:

"WHERE

a.P_STATUS <> 'R'

and b.TICKET_NUM is not null

and b.TXN_DT is not null"

All NOT comparisons cause scans...

I've seen worse. In addition to most of that job description, I've seen additional requirements for concurrent experience and responsibilities for:

1. Cisco router and switch admin

2. VMWare admin

3. Windows Server...