Viewing 15 posts - 5,416 through 5,430 (of 19,564 total)
Lynn is correct. If you need to remove the table, you need to use DROP. If you are only trying to remove records, then DELETE is what you...
December 23, 2012 at 10:54 pm
L' Eomot Inversé (12/23/2012)
Lynn Pettis (12/22/2012)
Constantly amazed by the number of people who think that full backups truncate the transaction log. Where do they get such ideas?
That's a clear...
December 23, 2012 at 7:02 am
Mind sharing what you did to get it working?
December 22, 2012 at 8:38 pm
Jeff Moden (12/21/2012)
December 21, 2012 at 9:39 pm
The Dixie Flatline (12/21/2012)
GilaMonster (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
WayneS (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups....And do proper restores.
And they don't restart their servers...
December 21, 2012 at 9:35 am
The Dixie Flatline (12/21/2012)
WayneS (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups....And do proper restores.
And they don't restart their servers to fix data corruption issues.
And...
December 21, 2012 at 9:11 am
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups.
...And do proper restores.
December 21, 2012 at 8:52 am
There is a script here to help you with that.
December 21, 2012 at 1:26 am
The use of temp tables is a common practice even in production. There are many uses for a temp table some of which being to help with coding or...
December 21, 2012 at 1:24 am
What has likely been done is to setup the additional data files for recover-ability and not performance. The separation you have described is done often times when doing filegroup...
December 21, 2012 at 1:21 am
Your databases have been upgraded but it does not appear that the cluster upgrade has been completed. Check the link provided and verify your setup.
December 21, 2012 at 1:04 am
Viewing 15 posts - 5,416 through 5,430 (of 19,564 total)