Viewing 15 posts - 631 through 645 (of 928 total)
As Gianluca has shown, one way to do this is to split @P1, because it is no use in it's current format as a parameter.
Col1 would have to have...
March 6, 2012 at 2:19 am
Backup WITH CHECKSUMS can make the backup file itself more reliable - http://msdn.microsoft.com/en-us/library/ms189587.aspx.
However, the best way to check backups are ok is to restore the data elsewhere and run DBCC...
March 2, 2012 at 4:14 am
The backup option 'WITH CONTINUE_AFTER_ERROR' may work - it all depends upon the corruption.
Why do you want to backup a corrupt database?
March 1, 2012 at 1:23 am
I particularly like the fact that a QOTD was verified by several people before publication.
February 29, 2012 at 1:45 am
Wonderful, thank you very much for your time and assistance.
I had just found the section within my copy of "Programming Microsoft SQL Server 2008", and although I could see it...
February 27, 2012 at 9:47 am
Paul Randal wrote a technical article that is worth reading, showing the various ways to enable it and the performance issues (and other areas too):
http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
February 27, 2012 at 1:26 am
HowardW (2/24/2012)I'm not convinced these things are a massive opportunity to learn new skills in details,
I think it depends on the presentation you go to and the skill of...
February 24, 2012 at 5:13 am
So the real answer is that SQL Server mantra - 'It Depends'!
February 22, 2012 at 2:11 am
Hugo Kornelis (2/22/2012)
February 22, 2012 at 1:48 am
ganeshkumar005 (2/21/2012)
February 21, 2012 at 2:44 am
Wicked (2/15/2012)
I'll try to group them into files
That is an inordinate amount of work in order to retrieve all rows back quickly. To repeat Gail's question - why do...
February 15, 2012 at 4:09 am
First of all - NOLOCK should not be considered as a 'go faster' switch. That's a misconception that abounds the forums for no good reason - http://itknowledgeexchange.techtarget.com/sql-server/what-does-with-nolock-actually-mean/. It avoids locks...
February 15, 2012 at 3:10 am
Roy Ernest (2/9/2012)
Lynn Pettis (2/7/2012)
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was...
February 9, 2012 at 9:16 am
The closest equivalent to that Oracle option is probably Bulk Logged Recovery - see http://msdn.microsoft.com/en-us/library/ms189275.aspx and http://msdn.microsoft.com/en-us/library/ms191244.aspx.
February 1, 2012 at 4:45 am
You have a couple of '=' missing - double-click on the error message and it will take you to the appropriate line.
@Surname '',
@Suffix '',
February 1, 2012 at 2:51 am
Viewing 15 posts - 631 through 645 (of 928 total)