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,...
March 20, 2010 at 3:57 am
GSquared (3/19/2010)
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.
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
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...
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...
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...
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...
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...
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?
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...
March 19, 2010 at 6:46 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...
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.
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...
March 19, 2010 at 3:07 am
Viewing 15 posts - 33,391 through 33,405 (of 49,552 total)