You cannot...

Split your string into a temporary table (NOT table variable) and then join to that for your output query. Problem solved.

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...