suhas.wadadekar (6/19/2009)

---

Thanks. I'll try it out.

Dropping a database and creating a new one is an option. But, I was trying to avoid dropping the procedures and functions written for the...

dan (6/19/2009)

---

Right,

Sorry for my previous brief posts with bad spelling and grammer. Here is what I have found:

The optimiser deals better with a sub query look up rather than a...

Except for third party databases, all our databases are built from source, so we can drop the database and recreate it pretty much by pushing a button.

However, you could look...

Once you've established blocking, you need to understand why there is blocking. It could be poor performance requiring index or query tuning or it might be transaction management or contention...

An index that has all three columns, which makes it covering. It can also be covering if one or more (or all three) of the indexes is in the clustered...

hi_abhay78 (6/18/2009)

---

SELECT TOP 1* FROM TicketActivity

SELECT MIN(TicketId) FROM TicketActivity

The above 2 queries are different.

But you can also run the min query as below :

select top 1 ticketid from TicketActivity order...

What you've got are an ordering query, TOP, and an aggregate query, MIN. The ordering query must have an ORDER BY statement to work. You can't know what order things...

I'm...

Excellent article. Thanks for putting it up. I just wish you had posted it a few years ago. I'm going to print it out now & keep it handy as...

jason brimhall (6/18/2009)

---

Two bits

I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I...

Matt Miller (6/18/2009)

---

I like your questions Grant. I usually just add in one more, it's actually usually my first (fail is and it's time to call it quits).

"What is...

Have you tried querying the dynamic management view sys.dm_exec_query_text yet? Any inline queries will be visible there, for the time that they're in cache.

That is a weird one isn't it? It doesn't look like Phil helped matters much.

I have to say, some of our discussions...

Sure, errors will cause gaps, deletions, anything that causes an incomplete transaction, implicit or explicit, can lead to gaps. If you need a perfectly flawless incrementally increasing number, with no...

Nope. Never mind. I was wrong (again). Showplan XML Statistics Profile does include the actual execution plan. Whew. I feel a little better now.