Viewing 15 posts - 33,391 through 33,405 (of 49,552 total)
Perry Whittle (3/19/2010)
it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!
Minimally logged, but that doesn't change the 'no commit,...
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 20, 2010 at 3:57 am
GSquared (3/19/2010)
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 19, 2010 at 3:55 pm
Can you run CheckDB manually on that database?
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
The 'severe error on the current command' is likely because you killed the connection.
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 19, 2010 at 3:47 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic886655-146-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
March 19, 2010 at 3:46 pm
DropCleanBuffers only drops clean pages. ie ones that have not been modified and do not need to be written back to the data file. So if you have lots 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
March 19, 2010 at 3:44 pm
Shrinking a database does not break the log chain, ever. There is no option to ShrinkFile or ShrinkDatabase that will break the log chain and hence log shipping.
That said, why...
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 19, 2010 at 3:40 pm
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
This is the one...
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 19, 2010 at 3:36 pm
Steve Jones - Editor (3/19/2010)
Henrico Bekker (3/18/2010)
When are you coming to South Africa to host a SQL Saturday? 😉
South Africa?!?!? Isn't that 3 light days of travel from CO? Can...
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 19, 2010 at 3:35 pm
GSquared (3/19/2010)
GilaMonster (3/19/2010)
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.What is this 'below freezing' that you mention?
It's what happens in the top part 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
March 19, 2010 at 8:58 am
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.
What is this 'below freezing' that you mention?
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 19, 2010 at 8:36 am
Henrico Bekker (3/18/2010)
When are you coming to South Africa to host a SQL Saturday? 😉
Silly question, but why does someone international have to come down here to organise an event?
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
March 19, 2010 at 6:46 am
Resurrected two year old 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
March 19, 2010 at 6:10 am
Brandie Tarvin (3/19/2010)
Unless... Are you treating it as a separate database in your query code?
Yes. A snapshot appears as a separate, read-only database. Hence, if you want to undo 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
March 19, 2010 at 5:50 am
As with any data modification, if the transaction is not committed and there's a server failure, the changes will all be rolled back as part of the database restart-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
March 19, 2010 at 3:36 am
Ratheesh.K.Nair (3/19/2010)
When we backup the log file will it create the backup of entire txion log file in different drives?
It'll backup the inactive log records, regardless of what file they'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
March 19, 2010 at 3:07 am
Viewing 15 posts - 33,391 through 33,405 (of 49,552 total)