tendayit (2/8/2010)

---

... Its code that i inherited and did not write myself and i was not too happy with its speed and fuctionality. I was just looking for a faster...

sanketahir1985 (2/8/2010)

---

...

hiii RBarryYoung,

on my server its going beyond 21 loops

so finally i have to kill this SP

tell me exactly whether this SP goes in infinite loop or will finish after...

Hmm, I apologize, now I am not sure that I have mentioned it to you before. Sorry ...

Screw: Is there some reason that you are not using the code tags? I am pretty sure that I have mentioned this to you before.

The link above is specifically for performance problems, for performance questions (i.e., less specific) or SQL questions in general, you may also want to follow the advice in this article[/url]...

First, just to be clear, it is important to distinguish between a VIEW and an INDEXED VIEW. Despite their great similarity in name, appearance and syntactical use in T-SQL,...

Ramesh Saive (2/6/2010)

---

The Dixie Flatline (2/5/2010)

---

Ramesh, I don't believe he has to worry about that. If he first does a crosstab or pivot as Jack suggests, he...

I would be interested to know what someones concept of a "Security Diagram" would look like. If I knew that, then I could surely tell which tool might be...

tendayit (2/5/2010)

---

I have a stored proc that uses a fast forward cursor to process data(Warehouse_UpdateAllTables). I need it to run faster than it does as the data that it processes...

FYI, it goes ballistic around Loop 18 or 19 for me, which takes about 5-10 seconds to reach.

Well, I am no fan of loops, but since the goal IS to slow things down, this ought to do it:

CREATE PROC EXERCISE_TEMPDB_SILLY AS

SET STATISTICS TIME ON

SET STATISTICS IO ON

CREATE...

I tend to put the commas in front, but that's a habit I get from writing SQL autogenerators, where it's slightly easier to special case the first line of a...

Paul White (2/4/2010)

---

...Now that a UDA can accept multiple parameters, I can write: SELECT dbo.UDA(@value, @row_number) and handle ordering issues inside the Accumulate method. The ranking function will tend...

CirquedeSQLeil (2/5/2010)

---

Lynn Pettis (2/5/2010)

---

< .... Running screaming to my tent in the desert ......>

Why is it that when you ask someone to SHOW you want they are trying to...

What he said.