Index definitions?

rbarryyoung (12/9/2008)

---

GilaMonster (12/9/2008)

---

I still think my favourite has to be this piece of code that I found when one of the devs complained that the dev server was very slow....

What do you...

Just about every time I've done a presentation or informal training and mentioned the problems of...

Mike Feuti (12/9/2008)

---

Not sure if this answers your question or not but I want the email addresses and ID for anyone on any committtee. the ID's are the link...

Matt Miller (12/9/2008)

---

while (@i<50000)

BEGIN

SELECT *

Into #tempTable

from MyHumongousTable --1,750,000 rows

update MyNewTable

set...

Mike Feuti (12/9/2008)

---

O

--===== Insert the test data into the test table

INSERT INTO #test

(ID, email)

SELECT '10002','Walton@email.chop.edu' UNION ALL

SELECT '10004','craig.engstrom@wfhc.org' UNION ALL

SELECT...

I still think my favourite has to be this piece of code that I found when one of the devs complained that the dev server was very slow. The same...

Almost. Just need the create statement for the two temp tables please.

That's fine.

I've edited the data you posted so that it looks the way we generally want it. Do you...

pino_daddy (12/9/2008)

---

The function is used to convert whatever time is being retrieved from whatever table it is being retrieved from. I was just wondering if there was a better way...

Estimated. The optimiser works with estimated row counts and that's what it uses for its costings and plan....

Grant did say it was untested. There's a misplaced bracket in the dateadd function.

SELECT s.ROW_ID, DATEADD(MINUTE,ISNULL(x.UTC_OFFSET,0),s.Created)

FROM S_SRV_REQ S

LEFT JOIN (SELECT TOP 1 tt.UTC_OFFSET, TT.START_DT

FROM S_TIMEZONE T

JOIN S_TIMEZONE_TEMP TT

ON T.ROW_ID =...

Remove it?

The way that SQL runs UDFs means that the...

Grant them view definition on the procedures, or on the entire dbo schema (but that will give them rights to see the definitions of tables, views, functions, etc as well)

GRANT...