If you're using 2005, you can retrieve the xml plans from the plan cache. Use the sys.dm_exec_query_stats and the sys.dm_exec_query_plans DMVs. Or you can get profiler to capture the plans...

Phil Factor (7/3/2008)

---

Gail,

I'm so pleased you got the recognition. I'm a great fan of your forum entries. I was trying to find my favourite one of all, in which you...

Sorry.

For anyone else reading. QFT = "Quote For Truth"

Grant Fritchey (7/3/2008)

---

The absolute most important part of the Summit is getting together with your peers from across the country. Building a network of individuals that you can help and...

<grin> :w00t: 😀

Despite the huge number of questions that she responds to, I don't think that I have ever seen her give...

Thanks all. It's kinda unexpected.

inus.dupreez (7/3/2008)

---

Well done – you really deserve this… Hope to still work with you for some time as time is all I need to gain...

No worries. We've all done similar or worse.

I appropriated your test code to show...

Jeffrey Irish (7/3/2008)

---

I had this all sorted out in my head before reading the whole chain thing in the article. I understand the concept of chaining, but it was the...

Jeffrey Irish (7/3/2008)

---

In theory you could recover to a point in time by restoring Sunday nights full backup and then running all the Transaction Logs through Thursday morning then, regardless...

You are correct, it does. Only a...

No. Tran log backups chain from another. Full backups do not truncate the transaction log, only...

Ok. There's no real gain from passing the db name into the sp_executesql, as it can't be used directly as a variable (as you've seen) This simplifies things a bit

set...

Thanks guys.

This site and everyone here is what made it possible.

Careful, it seems to...

Create the index on the registrationno column. It should be useful, depends on the queries...

That's going to table scan. It has to. You've asked for all the columns and all the rows, no filter. The only way that query can run...