I don't know. There probably is, but you haven't given us enough information to help you.

Please post table definitions, sample data and desired output. Read...

IOs are one area that cause major problems for virtual servers.

How many virtuals are hosted on that physical server? How do those virtual server's drives map to the physical server's...

Not really. Can you please read the links in Jack's sig.

Why do you want a loop?

I'm sorry you find this site a waste. Please feel free to ask Steve for a refund.

Ouch. 😀

It's possible to read that straight, or dripping with sarcasm. I wonder which he will do.

If you are, I'm missing it too.

Although, on SQL 2000, if those sub-procedures had no stable plan...

nitinpatel31 (1/13/2009)

---

If proper transaction are not mantained then it may cause the deadlock. For example if some table has s-lock in parent sp and x-lock in child sp and there...

http://letmegooglethatforyou.com/?q=Kerbtray

Thought it's not usually a good idea...

RBarryYoung (1/13/2009)

---

And the SQL parser, optimizer and data engine rely heavily on the assumption that functions cannot cause changes in the database while they are being invoked. Almost all...

Don't use profiler, at least not the gui. Use the server-side trace procedures (sp_trace_*) and write the output to a file on a fast disk. That's the lowest impact way...

Nah. I know what it runs and vaguely what that does, but not the details. I mean, DBCC Autopilot????

Besides, that's...

Steve Jones - Editor (1/13/2009)

---

OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.

Hmmmmm, I think I...

DTA's got two undocumented features that it uses to do evaluations of cost improvement. One is the hypothetical index (an index that has all the metadata and stats of a...

Can you ask the domain administrator (whoever runs the AD there) to see if the two SQL Servers are enabled for Kerberos delegation? It's a setting at the AD level,...