tommyh (9/23/2011)

---

I get a bunch of

Server: Msg 16915, Level 16, State 1, Line 1

A cursor with the name 'hCForEach' already exists.

messages when i run that code. Maybe its a...

Fire up profiler and see the REAL statement sent to the server. There are a few gotchas in there ;-).

You script doesn't work on my server (weird db & table names + case sensitive).

This is overly complex for 2K5+ but since this is sql 2K...

SET STATISTICS IO, TIME OFF

SET...

LAW1143 (9/22/2011)

---

another (probably useless) tidbit...

sys.sysdatabases and sys.databases are not the same! I just spent 5 minutes trying to figure out why I couldnt validate snapshot isolation levels in sys.sysdatabases......

Rokh (9/22/2011)

---

No I didn't.

Like stated before, the inner join is not be removed. It represents a real life situation. I've only skinned it down for this forum. Call it respect...

LAW1143 (9/22/2011)

---

great thought, and I should have included that in the 'what I know' portion of my first post...

none of the indexes on this table have been rebuilt or reorganized...

Fill factor change?

Any small change that could have affected the row size could be compounded but lots more pages being required to hold the data.

But I'm short on useful actionable...

So log size à 512 GB and db size @ 1.2 TB?

This seems a little overkill.

What you can do is check the log backup history size and see the max...

Rokh (9/22/2011)

---

Ok, keeping the thread alive :).

It's not as easy it looks I think. My theory for now is that I need to accept the performance. I hope you'll come...

jcrawf02 (9/22/2011)

---

Anybody ever go looking for an answer in the Forums, find the perfectly phrased question for your problem, only to find out it was you who posted it in...

DBANewbie (9/22/2011)

---

I'm having a similar problem; except that i am using standard edition.

For some reason i don't seem to have the option to install ssrs. Does anyone have any suggestions...

#1 I wouldn't send the email from the trigger.

#2 I would schedule a job to find the rows to process and schedule that every x minutes

#3 If you're willing to...

DECLARE @DBString VARCHAR(100)

SET @DBString = 'svr.dbname.dbo.'

insert into #MyReasonCodes (please list the columns)

exec(@DBString + 'reasoncodes_getdetailsfortype ''CA''')

Stefan Krzywicki (9/22/2011)

---

Roy Ernest (9/22/2011)

---

ALZDBA (9/22/2011)

---

Roy Ernest (9/21/2011)

---

Apologies in advance for the change in topic... 😀

I want to do a presentation for the SQL saturday that will be conducted in...

Gianluca Sartori (9/22/2011)

---

montyismobile (9/22/2011)

---

Silly question. Is there an easy way for me to copy this code as it is formatted? When I copy and paste from the windo...