Viewing 15 posts - 27,136 through 27,150 (of 49,552 total)
Jan Van der Eecken (3/23/2011)Craig, 'Inventing a Lane' did not originate in Boston, it was first registered as a purely South African invention. Our "communal" taxis (can't call them bl@ck...
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
March 23, 2011 at 3:28 pm
Elliott Berkihiser (3/23/2011)
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
March 23, 2011 at 3:20 pm
In that case shrinking to 10% free is not going to do anything.
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
March 23, 2011 at 3:12 pm
One thing that may help - drop the RTRIM off of the group by columns. SQL ignores trailing spaces anyway, and the function may be preventing SQL from leveraging...
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
March 23, 2011 at 2:22 pm
No.
Is there 10% free space?
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
March 23, 2011 at 1:52 pm
Please post new questions in a new thread. Thank you.
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
March 23, 2011 at 1:40 pm
Brandie Tarvin (3/23/2011)
A-Kon 22, the biggest Anime convention in the U.S., will be throwing a launch party for The Ladies of Trade Town anthology (edited by Lee Martindale)....
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
March 23, 2011 at 12:22 pm
Craig Farrell (3/23/2011)
Hm, an anthology of sci-fi and fantasy hookers. Anyone else have that list of books to read that just gets longer... and longer... and longer...? 😀
Last...
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
March 23, 2011 at 12:18 pm
Craig Farrell (3/23/2011)
Is this everything? The final component of the graph looks like it's a 3 way deadlocking but only spids 67 and 84 have descriptions above, and 60...
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
March 23, 2011 at 12:13 pm
Can you post the table definitions and index definitions?
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
March 23, 2011 at 11:51 am
Steve Jones - SSC Editor (3/23/2011)
Also, you should not be regularly truncating and shrinking. If you are in full mode, set up transaction log backups.
And on that point... Managing Transaction...
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
March 23, 2011 at 11:41 am
Grant Fritchey (3/23/2011)
No, you can't really avoid the compile process. If you try plan forcing you're at least guaranteed which plan you get.
However that can increase CPU usage as 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
March 23, 2011 at 9:47 am
KermitTheRock (3/23/2011)
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
March 23, 2011 at 9:46 am
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
March 23, 2011 at 9:44 am
It should, but the error indicates that something reset the differential base. I have heard of this before with backupexec backups, can't recall details.
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
March 23, 2011 at 9:35 am
Viewing 15 posts - 27,136 through 27,150 (of 49,552 total)