Viewing 15 posts - 21,346 through 21,360 (of 49,552 total)
SQLRNNR (1/4/2012)
That would be two really good things tied into one - a vacation trip to London and Immersions. I'll daydream about it a few hours longer.
Well I'm not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 1:29 pm
As for the deadlock, there's a select being run on the connection before that update. I need to see what that select does.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 1:28 pm
It won't be the scripts, it'll be in the connection properties or one of the data access classes. Speak to the .net developers on that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 1:20 pm
DBCC USEROPTIONS gives you the default options. Connections can override that and the connections involved in the deadlocks is explicitly setting an isolation level of serialisable, overriding the default.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:41 pm
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
Have a read through this: http://msdn.microsoft.com/en-us/library/ms345146.aspx
There are performance benefits in some situations, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:11 pm
Have you read through this: http://blogs.msdn.com/b/psssql/archive/2009/05/29/how-it-works-sql-server-timings-and-timer-output-gettickcount-timegettime-queryperformancecounter-rdtsc.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:06 pm
Brandie Tarvin (1/4/2012)
GilaMonster (1/4/2012)
What do you guys want to see an article on? (keep it to backups,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:04 pm
SQLRNNR (1/4/2012)
GilaMonster (1/4/2012)
SQLRNNR (1/4/2012)
itpcpro (1/4/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:03 pm
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
It is, but then people tout Nolock as a performance improvement and shrink...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 12:02 pm
Kiara (1/4/2012)
GilaMonster (1/4/2012)
What do you guys want to see an article on? (keep it to backups, database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 11:42 am
It's one statement, not 2. The first update to run takes U locks, any other has to wait (U locks are not compatible with each other, S locks are), so...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 11:39 am
Stefan Krzywicki (1/4/2012)
Microsoft says it improves speed, but I think that's not true in certain situations, like if you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 11:04 am
SQLRNNR (1/4/2012)
itpcpro (1/4/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 10:55 am
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 10:55 am
Ask your vendors to replace the select .. update combo with this:
UPDATE dbo.AutoNumberSettings
SET NextValue = NextValue + 1
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2012 at 10:53 am
Viewing 15 posts - 21,346 through 21,360 (of 49,552 total)