Viewing 15 posts - 196 through 210 (of 18,926 total)
GilaMonster (1/4/2012)
Ok, talk about deja vu....Deadlocks 1: http://www.sqlservercentral.com/Forums/Topic1229544-1550-1.aspx
Deadlocks 2: http://www.sqlservercentral.com/Forums/Topic1230105-391-1.aspx
Same cause (well, almost), same pattern, same day.
That could be your next article. Comes up often enough that it'll be...
January 4, 2012 at 4:02 pm
Hawkeye_DBA (1/4/2012)
perhaps you are on to something with the serializable isolation level
I am going to talk with the developers at the...
January 4, 2012 at 10:42 am
Sum(IIF(same condition as visibility,field, 0))
January 4, 2012 at 10:15 am
Use that to find avg run times for all your sps and then catch the ones that are far out of whack.
Rerun that code in SSMS and save the actual...
January 4, 2012 at 10:06 am
Dev (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Dev (1/4/2012)
Ray K (1/4/2012)
Steve Jones - SSC Editor (1/4/2012)
January 4, 2012 at 9:54 am
Dev (1/4/2012)
Ray K (1/4/2012)
Guess the caffeine didn't kick in. This is one of those days when I wish coffee pots came with octane ratings. 😉
LOL... Remi also...
January 4, 2012 at 9:52 am
Ray K (1/4/2012)
Guess the caffeine didn't kick in. This is one of those days when I wish coffee pots came with octane ratings. 😉
Alcool is very effective as fuel...
January 4, 2012 at 9:49 am
Dev (1/4/2012)
Ray K (1/4/2012)
Steve Jones - SSC Editor (1/4/2012)
When you rebuilt, and resinstalled, I assume, did you "add Current User" as an administrator? That's easy to miss.
Yeah, that...
January 4, 2012 at 9:47 am
SQLRNNR (1/4/2012)
GilaMonster (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
We should adjust that to 4PM Hawaiian instead of Pacific:-D
And...
January 4, 2012 at 9:44 am
Ray K (1/4/2012)
Steve Jones - SSC Editor (1/4/2012)
When you rebuilt, and resinstalled, I assume, did you "add Current User" as an administrator? That's easy to miss.
Yeah, that I did remember...
January 4, 2012 at 9:42 am
She still needs this.
GilaMonster (1/4/2012)
BEGIN TRANSACTION
DECLARE @className nvarchar(47) = 'WillNotExist'
Update dbo.AutoNumberSettings Set NextValue = NextValue + 1 Where dbo.AutoNumberSettings.[ClassName] = @className
ROLLBACK...
January 4, 2012 at 9:41 am
Steve Jones - SSC Editor (1/4/2012)
randren (1/4/2012)
January 4, 2012 at 9:22 am
Viewing 15 posts - 196 through 210 (of 18,926 total)