that's what i was thinking - that sql automatically spreads the data across datafiles.

many thanks!

thanks for the info suresh.

we have only one filegroup. does that mean i cannot move a table between datafiles in a single filegroup?

how does SQL manage data in...

thanks for the comments, guys.

i will go to SP3 and do some weeks worth of testing on some test servers that we have. across these test servers are hosted...

thanks for the help.

i thought it was proper forum etiquette to use a thread regarding the same subject. no?

i'm hitting this error during an index rebuild/reorg job:

Msg 2552, Level 16, State 1, Line 1

The index "VBDATA^0" (partition 1) on table "VBDATA" cannot be reorganized because page level locking...

MyDoggieJessie (2/22/2012)

---

I use modified versions of these scripts on DBS with over 800Gb of data...it actually works pretty well and skips the stuff not needing the index maintenance. Set...

cool scripts, thanks!

our environment is actually a little more complicated - can't take the system offline (easily) and we run SAN replication for DR purposes, so rebuilding an entire...

i get a boatload of errors with that script in SQL2008. 🙁

ok some success but not any understanding....

rather than linking the 2012 cube partition directly to the 2012 partition table, i link it to the main view (union of all the...

Tim Ermlich (12/20/2004)

---

- NetSend notifications will not be sent

I have this message in the error log for SQL Server Agent, which is running. I have tried bouncing the service...

why is it then that my backup maintenance plan can see the F: (local) drive?

when i access the backup gui in management studio, the information for the last backup...

Bueller?....Bueller?....Bueller?

DBCC CHECKDB ('WSS_Content_CLIENTS') WITH NO_INFOMSGS, ALL_ERRORMSGS

Command(s) completed successfully.

Nada.

yeah i know, but i was trying to avoid going through MS support. :crazy:

funny, i have never noticed those trc files before. what are they doing and why is...

and the problem is usually something very simple yet very hidden....

There was an orphaned login group on the server, with these users as members of the group. The login was...