tosscrosby (3/28/2008)

---

Last posting of the week for me. Trying to get this to work and it's giving a syntax error. I'm sure it's missing a quote (or has one too...

Don't even bother with updated_columns or updated()

I've seen both of those say a column was updated even when it isn't.

Join inserted to deleted and compare the values

i.e.

select

count(*)

from

inserted a join...

Jeff Moden (4/2/2008)

---

That's a big one for me... the use of "Trusted Accounts" means that I don't have to hard-code user names or passwords in any code. Very big...

I don't think it actually matters. Similar to arguing the benefits of do.... while vs while...wend statemtns in VB.

Either works, each also requires slightly different syntax and...

Ain't that the truth...

Of course

SQL Server 2005 RTM or later, Only SQL Server 2000 SP 3 or later,...

Mine too... My mother-in-law is convinced if she gets the internet at home, her identity will be automatically stolen.

That's a good tip. I'm keeping the log at 10%... so 3 GB.

I had a maintenance plan and auto-shrink enabled.

The maintenance plan I left in place. So on...

I think I've tracked this one down...

When I looked at the server after a lockup and reboot... there wasn't anything to see.

But it appears we're shrinking the Log file down...

Well Brainbench makes me feel better...

Not a god like some of you folks around here... but I will take this... and feel good. And thank all of you for...

Lynn Pettis (3/3/2008)

---

Actually, I haven't even thrown in SSIS, SSRS, or SSAS. If I added those in, my score would drop. On SSIS (2 or 3 of 10),...

Jason Lennan (3/13/2008)

---

Not sure if this applies to your specific PowerEdge/PERC model, but on the 2850's there's a firmware upgrade:

RAID_FRMW_LX_R169531

Fixes and Enhancements:

1. Fixed an issue of system lock ups and...

Jason Lennan (3/13/2008)

---

That's alright 🙂

Run a sp_who2 now and again in an hour, see if the number of connections stays relatively the same. Try this every now and then...

Yes, it is on SQL 2000 EE SP4... sorry for not mentioning that above.

33 GB

About 120 or so

SQL 2000 Enterprise, Windows...

george sibbald (3/13/2008)

---

Are you sure there are no 'UMS Scheduler Hung' messages in the SQL errorlog?

This is the only thing I am aware of which will completely freeze a SQL...