Viewing 15 posts - 37,681 through 37,695 (of 49,566 total)
Also asked here. http://www.sqlservercentral.com/Forums/FindPost752790.aspx
No replies to this thread please.
July 14, 2009 at 9:39 am
Look in books online for "Torn Page Protection" to see what it is and what it's there for.
July 14, 2009 at 9:39 am
It's a bitmask. A bit value of 1 means that the option is set, 0 means not set. So the decimal value 0 means that all of the bits are...
July 14, 2009 at 9:21 am
Straight from Books Online:
status
Status bits, some of which can be set by using ALTER DATABASE as noted:
1 = autoclose (ALTER DATABASE)
4 = select into/bulkcopy (ALTER DATABASE using SET RECOVERY)...
July 14, 2009 at 8:58 am
Tom West (7/14/2009)
What i need to do is to copy out the data from the table into a new table, to allow me to drop the existing table.
Hang on...
Do you...
July 14, 2009 at 8:55 am
True, however SELECT ... INTO is minimally logged when the recovery model is other than FULL. Hence the changes don't get logged, just the fact that certain extents have changed.
Take...
July 14, 2009 at 8:52 am
Mel Harbour (7/14/2009)
Just tried Jeff's suggestion, restructured the query to do a pre-aggregation with a CTE, and that slowed the performance down (more CPU time).
It will. A CTE, despite it's...
July 14, 2009 at 8:44 am
As far as I know, network path is required and local path is optional. It's not that you specify one or the other.
July 14, 2009 at 7:31 am
Gianluca Sartori (7/14/2009)
Gail, in this case won't SELECT .. INTO copy the whole table in a single transaction?
Yup, it will
In that scenario BULK_LOGGED recovery won't help.
Why do you...
July 14, 2009 at 7:28 am
dastagirid (7/13/2009)
I need to install sql server 2008.May I know what version I install.
Depends on what features you need and what your budget looks like. What are you installing it...
July 14, 2009 at 6:46 am
river (7/13/2009)
The command "LEFT OUTER JOIN" does not work in SQL Server 2005.I can replace it for LEFT JOIN.
LEFT OUTER JOIN works very well in SQL Server 2000, 2005 and...
July 14, 2009 at 6:45 am
Tom West (7/14/2009)
Is there a table hint or something similar that I can apply to turn off the logging?
There is no way to turn off logging completely. Best you...
July 14, 2009 at 6:42 am
In SQL 2000 the ; is not required, it's optional. Rumour has it that it may be required in a future version of SQL. It's a T-SQL language construct, so...
July 14, 2009 at 6:40 am
I'm guessing the backup is damaged. Can you get another backup?
July 14, 2009 at 6:37 am
Viewing 15 posts - 37,681 through 37,695 (of 49,566 total)