Here are my two goto resouces for deadlock troubleshooting:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

http://blogs.msdn.com/b/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

BTW, anything out there by bart duncan is worth studying!

Don't have time to dig into this, but I wonder if dynamic sql might not help here. date-range queries often benefit from having hard-coded values because the optimal query...

There are a metric butt ton of things that can affect database application performance! Hire a tuning professional for a few days. You get mentored on what/how to...

Based on statements and questions asked I STRONGLY encourage you to hire a professional to review your systems and help you get a maintenance configuration set up that is correct...

1 tempdb file per CPU is DEFINITELY not appropriate for just about every server in existence. Even 1/4 files per CPU count is inappropriate for many systems. If...

CONGRATS!! Awesome milestone.

You say 3 can't answer everything, which is obviously true. But you still have a top-weighted dedicated few who provide LOT of the help here. ...

1) you should not use UNION for the population - there are no duplicates so use UNION ALL to avoid DISTINCT operator under the covers.

2) you should CAST the phone...

1) Our own (SSC.com) Grant Fritchey has a wonderful and FREE ebook on query execution plans here: http://www.sqlservercentral.com/articles/books/65831/

2) review actual execution plan from execution, and SET STATISTICS IO ON...

1) reorg might work, but you would need to do it from the point of having minimal size files (with a bit of free space) and indexes in place. ...

philcart (10/5/2010)

---

TheSQLGuru (10/4/2010)

---

2) I have a client with pushing 40TB on virtualized SQL Servers. And yes, I did mean TERA there and not GIGA. It can be done,...

1) you can use CPU affinity to throttle SQL Server's CPU utilization, at least in rough terms. BEWARE: advance stuff here!

2) I have a client with pushing 40TB on...

I highly recommend the entire (FREE) maintenance suite from ola.hallengren.com, especially the indexing stuff.

1) ALWAYS set max memory on a sql server. I would try 26GB to start on this box.

2) Have you tried to connect using the DAC??

3) Did you try...

Classic "it depends" question. If you are loading 1M rows into a BILLION ROW table, then yes, 1M might be a lot of rows but you probably REALLY don't...

For large amounts of rows nested loops are usually HORRIBLE performers. if you are hitting lots of data HASHING (or MERGING) is best. If you have lots of...