If not, start with this, and check out the blog posts it links to as well.

http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

Lynn Pettis (8/27/2009)

Personally, looks like a good reseearch topic for some one. I'd just...

Yes, it's nuts, unless you've verified that the NAS supports write order preservation and write-through guarantees

http://blogs.msdn.com/sqlblog/archive/2006/10/03/SQL-Server-and-Network-Attached-Storage-_2800_NAS_2900_.aspx

http://support.microsoft.com/kb/304261

Query sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)

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/Topic778508-146-1.aspx

I love these kinds of questions. http://www.sqlservercentral.com/Forums/Topic778499-146-1.aspx

Maybe I'll elaborate later on what it depends on...

Yup, but that's only for errors in sys.sql_dependencies. Fixing this kind of error if it's in sys.objects or any other system table is a massive amount harder.

Did you listen to the podcast I recommended?

It depends.

From what I can tell it's deleted 4 rows from the table (a heap, if I'm not mistaken) and their corresponding off-row (lob columns or row overflow) data.

These are the...

I would suggest either SSIS or bcp (if it's to be a repeated task) or the import/export wizard if it's once-off.

With bcp you'd have to bcp the data to a...

Anytime an index is moved to another filegroup all the pages that comprise that index are moved, root, intermediate ane leaf levels. This applies to clustered and nonclustered indexes alike

A restart of the service or the execution of sp_cycle_errorlog. Easy to tell which, check the beginning of the error log, if the SQL startup messages are there then it's...

I wonder how long he's going to protest.

It's not possible. Files and filegroups are intrinsically linked to the databases that they are part of and there is no...