Running a server side trace is the best thing you do for yourself. Capture the queries as they're made and see which ones run slow and when. Read Gails articles...

Combining views is not dissimiler to joining views or nesting views. It all leads to poor choices by the optimizer due to the complexity of the plan when the optimizer...

Just presented on this yesterday during 24 Hours of PASS.

Perfmormance Monitor: free, built into to Windows, useful for monitoring server and SQL Server at a strategic level

Trace Events: free, built...

Matt Miller (9/3/2009)

---

Grant Fritchey (9/3/2009)

---

Elliott W (9/3/2009)

---

As an aside, while I think its a good idea I'm a little fuzzy on the legality. Mass. is interfering in interstate commerce...

Torquemada wishes he had Jeff's skill with the pork chop.

Elliott W (9/3/2009)

---

What,...

Elliott W (9/3/2009)

---

As an aside, while I think its a good idea I'm a little fuzzy on the legality. Mass. is interfering in interstate commerce and unless you have...

I've heard that Adam Machanic may have a few CLR procedures that speed up the process of submitting multiple values. He mentioned it yesterday during his 24 Hours of PASS...

You've got two foreign keys that are going to try to cascade an update or delete on the same table... It's a circular reference.

Since you're on 2008, why don't you...

I don't know that you'd have to learn TSQL to be a DBA, but your job is going to be infiinitely more difficult if you don't.

Three books I'd suggest, especially...

Sourav (9/1/2009)

---

1) Can you let me know the process: how SQL Server internally manage the Deadlock?

2) Is it required to free the deadlock manually?

3) What is the way, SQL...

Do you have the instance where it occurred?

If it's a syntax error, I doubt you'll see it in the trace events because it won't execute, it'll fail to get...

I'm pretty certain there are several scripts that could do that for you in the Scripts section over on the left. Do a couple of searches there and I think...

Each table referenced by the query will be addressed by the optimizer and the best index that the optimzer can find will be used. As noted above, this depends on...

Thanks for posting that. I hadn't heard.