Viewing 15 posts - 48,061 through 48,075 (of 49,552 total)
Will Summers (12/11/2007)
( I wouldn't complain either if I got to play golf in shorts on xmas day though.)
Come visit my neck of the woods. Christmas day here is...
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
December 11, 2007 at 11:16 pm
We've all done it at least once.
I told a lot of people that truncate wasn't logged and couldn't be rolled back. Even mentioned that in some code reviews I did....
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
December 11, 2007 at 5:45 am
It's fine. Just to interpret the graph requires most of it. I'll note which lines say what, so that you can see how I read the graph. (I just numbered...
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
December 11, 2007 at 2:17 am
Jeff Moden (12/5/2007)
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
December 11, 2007 at 2:04 am
Please don't cross post. Continued here
http://www.sqlservercentral.com/Forums/Topic431592-149-1.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
December 10, 2007 at 11:32 pm
The N signifies that the following value is unicode (nvarchar/nchar)
The LEN should return the same, the datalenght for the N-prefixed value should be twice that for the value without the...
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
December 10, 2007 at 11:11 pm
Agreed. They, along with the index usage stats are among the first things I check when tuning.
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
December 10, 2007 at 12:58 pm
I'm not sure I follow you. Can you post what you've tried and what error it gives please?
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
December 10, 2007 at 12:29 pm
If you know little to nothing about indexing, the DTA may be a good place to start. It's better that the index tuning wizard was (but that's not saying much)
Personally,...
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
December 10, 2007 at 12:04 pm
Derek Dongray (12/10/2007)
Basically, the question is "can the optimiser recognise an uncorrelated subquery (or CTE) and separate it out as query into an internal temporary table
My guess is not. I've...
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
December 10, 2007 at 11:59 am
That doesn't look like the entire deadlock graph. Post the whole thing (in code blocks) please.
From the bit there, I can see the following.
The deadlock was between processes 130 and...
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
December 10, 2007 at 11:54 am
Good luck.
I'm writing this one on friday morning. Still need to work through two of the course guides. :Whistling:
Shall we compare results monday morning?
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
December 10, 2007 at 6:18 am
Datalength works on text and ntext data types where len does 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
December 10, 2007 at 6:13 am
Ananth (12/10/2007)
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
December 10, 2007 at 6:12 am
You can, but you will have a performance impact. How much depends on your hardware and the activity.
Try shrinking in smaller chunks. Sometimes that works out faster overall. Even if...
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
December 10, 2007 at 6:09 am
Viewing 15 posts - 48,061 through 48,075 (of 49,552 total)