Viewing 15 posts - 13,396 through 13,410 (of 39,919 total)
Just a guess, but has the instance been restarted? It sounds like you've done things right, but perhaps something is stuck?
August 3, 2012 at 12:01 pm
Definitely use the upgrade advisor. Watch out for older scripts that check system tables as many of them have changed.
I assume you are doing a test upgrade, but please make...
August 3, 2012 at 10:25 am
Added my note to the SQLSat thread.
I'd like to do more, but with 6 SQL in the City dates + Connections, rather booked up for a few months.
August 3, 2012 at 10:04 am
Not me, though I'd like to. Camping with the family, so I'll be gone Mon/Tue as well (everyone behave).
My 2012 SQL Saturday schedule moving forward is likely:
Sept 22 - Denver
Oct...
August 3, 2012 at 10:03 am
That looks better. It's what you want in a trigger, a way to handle multiple rows.
August 3, 2012 at 9:58 am
I've edited the question down since I think it was a good question. I didn't catch the typo (grrr, no more images).
I'll award points back.
August 3, 2012 at 9:55 am
In that case, you could grant permissions to the login to get to the DMVs, but I wouldn't leave them there permanently.
August 3, 2012 at 9:33 am
The permissions are those of the user executing the code, so whoever updates the table has their permissions used.
I doubt most users have access to sys.dm_exec_connections. I would suggest you...
August 3, 2012 at 9:02 am
Interesting thoughts from Craig, and I like them overall. However if you go with 2 lower priced people to handle the duties, may I suggest you grab a consultant on...
August 2, 2012 at 3:13 pm
SQLRNNR (8/2/2012)
Steve Jones - SSC Editor (8/2/2012)
August 2, 2012 at 1:42 pm
Just a quick reminder here to everyone. This is a public forum, so the things you post are tied to you and available for everyone to see.
Just like an email,...
August 2, 2012 at 12:47 pm
You'd have to provide more details, but if you have matching rows, then you don't need to loop.
If I delete from JournalEntryLine, I have a trigger there that does a...
August 2, 2012 at 12:24 pm
Hyperthreading does not add cores. It adds threads in the core.
You license cores, not threads. If you have a single 6 core machine, you need 6 licenses.
August 2, 2012 at 12:21 pm
There are single oar sculling, from what I've seen this refers more to a rear propulsion with an oar then competitive racing.
Perhaps there are sculls that aren't two oars per...
August 2, 2012 at 11:45 am
Viewing 15 posts - 13,396 through 13,410 (of 39,919 total)