I can't read minds, but I can see the future...

I see... I see... a dba-wanna-be on the street, looking for work... I...

Bare, bare, bare minimum, run sp_who2 to see if you have blocked processes. From there, you need to delve into all the skills of troubleshooting and investigation. Without at least...

I started out using various nicknames, but when I published my first article with Steve, he asked me to change my nickname to my real name... and so it has...

Actually, though... thinking about it. I'm not sure you could make a plan guide work. Hmmm... that might be tough.

You can using a hint, but since this is ad hoc (right?) you'll need to use a plan guide.

Excellent.

So you are using forced parameterization then?

The different plans from the web is probably, but not definately, because of differences in the type of connection or settings within the connection. If you drill down on all...

GSquared (6/9/2009)

Okay, Steve. Normally I back you up when you have typos in articles and someone...

Well, again, any plan will be cached and could be reused. As to whether or not simple is doing what you want, when you look at the query text in...

You might want to pick up a book on the topic. It's as old as the hills in computer terms, but Flemming & von Halle's Handbook of Relational Design is...

Here's the What's New listing on 2008

http://msdn.microsoft.com/en-us/library/bb500435.aspx

I haven't been too crazy about it, but Books24x7 has a very good service.

It sounds like something in your code is trying to create the index, probably over & over again. You should check the code. I don't think you're dropping it is...

I support quite a few development teams. I usually take charge of creating their databases, setting up backups & restores and then, depending on the team, their level of expertise,...

Without the things that Gail asked for... No. No one can tell you what's wrong because we're not there and don't have a clue what's the problem on your end....