Viewing 15 posts - 41,191 through 41,205 (of 49,552 total)
trackingraj (2/5/2009)
1. I found in the book, the CD of this training kit is available. Where can I download this CD freely ? - please mail me trackingraj@gmail.
No portion of...
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
February 5, 2009 at 1:50 pm
trackingraj (2/5/2009)
Based on your message, I came to know that the ceritication will expire soon ?
It'll never expire.
MS thought about the expiry, but didn't implement it. Your cert will be...
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
February 5, 2009 at 1:48 pm
nilmov (2/5/2009)
Changing the recovery model to simple and bring to full will help
But will break the log chain with all attendant risks and concerns.
and its better than truncate_only as...
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
February 5, 2009 at 1:37 pm
rudy komacsar (2/5/2009)
It workd on SQL 2000 ...
Thanks for the test.
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
February 5, 2009 at 1:36 pm
It did wait until the lock was released.
A shared lock is released as soon as the select has finished (in the default isolation level). You either need to do a...
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
February 5, 2009 at 9:10 am
psangeetha (2/5/2009)
I'm hoping the lock to the child table in exclusive mode will solve this problem, for testing.
No, it won't. If there's a foreign key in place 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
February 5, 2009 at 8:49 am
Christopher Stobbs (2/5/2009)
Now I've drawn up some tests to read some execution plans for unions.And I don't really see anything that looks very costly?
See a hash aggregate or a sort?
Union...
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
February 5, 2009 at 8:41 am
Ahmad Osama (2/5/2009)
GilaMonster (2/4/2009)
Why do you want to truncate and/or shrink your transaction log?
I have a job to rebuild indexes..this increases the transaction log size....so i want to truncate...
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
February 5, 2009 at 8:30 am
meichner (2/4/2009)
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
February 4, 2009 at 12:05 pm
Ahmad Osama (2/4/2009)
in those cases I hv used dbcc shrinklog to truncate log.....
Shrink file will never truncate the log. It shrinks the file. Truncate refers to discarding old log records...
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
February 4, 2009 at 11:51 am
Why do you want to truncate and/or shrink your transaction log?
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
February 4, 2009 at 11:48 am
Have the DBs perhaps been changed to simple recovery?
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
February 4, 2009 at 11:47 am
NotManyPoints (2/4/2009)
I have not said a DBA should know everything (to the point of being proficient in every aspect) about SQL, but have an 'awareness'. :w00t:
So do you have an...
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
February 4, 2009 at 11:38 am
Lynn Pettis (2/4/2009)
Well, guess I should not be a DBA then, as the only knowledge I have about SQLCLR is that it is there.
Likewise, same with log shipping,...
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
February 4, 2009 at 11:31 am
charlesz (2/4/2009)
I do not want to get to the details about our product.
Then why did you post info about it in your first post on this thread?
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
February 4, 2009 at 11:24 am
Viewing 15 posts - 41,191 through 41,205 (of 49,552 total)