If you truly expect high traffic volumes then you had best test for that BEFORE you go live!!! I can't tell you the number of times I have seen...

Here is a go-to blog post on 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.

Get and learn to use the AMAZING, FREE maintenance scripts from ola.hallengren.com. Nice documentation with it too.

Russ, please don't post to 5 year old threads. Thanks!

SQL Kiwi (1/24/2012)

---

TheSQLGuru (1/24/2012)

---

2) cursors are still the fastest supported way to do running totals in sql server. Jeff Moden and others have come up with the "quirky update" to...

ceasor (1/24/2012)

---

Nice try (I know how time-costly to create an article).

I dislike your approach. OLAP service (SSAS) is designed to solve such task. Use calculated Dimension or Time intelligence for...

mtassin (1/24/2012)

---

TheSQLGuru (1/24/2012)

---

1) as others have stated that triangular join (xx <= yy) is gonna kill you performance wise as number of rows increases.

2) cursors are still the fastest supported...

SQLJOBVIS!!! It's not a script, but it is FREE and it is awesome at allowing you to see job statuses and MUCH more importantly job run overlaps so you...

1) as others have stated that triangular join (xx <= yy) is gonna kill you performance wise as number of rows increases.

2) cursors are still the fastest supported way to...

After you remove the UDF (which is MANDATORY!!!!), you may still have a classic performance tuning problem.

a) are all necessary indexes in place

b) the problem with increasing numbers...

Stop trying to force a square peg into a round hole. Just initialize from backup and move on to the next item in your to do list.

By far the best way to learn performance analysis and tuning is to have a mentor that can work with you to examine/improve your existing applications while teaching you what...

suresh0534 (1/18/2012)

---

Hi,

If we create Temporay Tables in a Stored Procedure will degrade the performance of the query?

Ex:

CREATE TABLE #TempTable

(id int,name varchar(50))

INSERT INTO #TempTable

SELECT id,name FROM Employee

How to...

Partitioning is an ADVANCED and COMPLEX feature that was never built in the first place for performance - it was primarily for improving ETL and maintenance. I HIGHLY recommend...

Anamika (1/15/2012)

---

hi,

Does Table Value function caches execution plan?

one of my query is performing slow for the first time. i can't put this query in stored proc as it is...