Viewing 15 posts - 37,666 through 37,680 (of 49,552 total)
RBarryYoung (7/14/2009)
Paul White (7/14/2009)
Yep. Just couldn't be bothered...I'd gone to the trouble of wrapping it inand thought that would be good enough...seems notHmmm,
should work?
It works...
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
July 14, 2009 at 9:42 am
Also asked here. http://www.sqlservercentral.com/Forums/FindPost752790.aspx
No replies to this thread please.
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
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.
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
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...
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
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)...
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
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...
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
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...
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
July 14, 2009 at 8:52 am
664 - The beast next door
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
July 14, 2009 at 8:44 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...
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
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.
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
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...
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
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...
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
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...
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
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...
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
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...
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
July 14, 2009 at 6:40 am
Viewing 15 posts - 37,666 through 37,680 (of 49,552 total)