GSquared (7/9/2009)

---

For people who will be writing procs, I'd include something like, "What are the advantages and drawbacks of 'with(nolock)'?", as a key question. I've seen far too many...

I agree with Carl ... just allocate the existing databases across the 4 LUNs. Given the number of databases and your server hardware, I'm guessing that they aren't used...

Another option might be to send a database backup.

It really depends on the nature and purpose of the data. Will it be imported manually? Does it need to sync...

It will only help if blocking is the issue. Since you mentioned that the tables are rarely updated, are you sure that blocking is the problem? It could...

It makes no difference at all to a unique constraint as it will always check for equality on all columns in the constraint/index, therefore the number of page reads will...

Currently getting almost the same error on all attempts to post. Looks like the post counts may be the problem. Preview is working, posts are obviously applying regardless...

A filegroup with multiple files is using a proportional fill algorithm i.e. striping your inserts across the files. Performance benefits come from being able to push/pull data to/from the...

Sorry for double post - site is giving a .net error message.

Steve Jones, if you read this, this is a detailed .net message that should be trapped before it's sent...

I'm not aware of any hard limit, only ones imposed by available resources.

To answer the original question, each has its advantages and disadvantages - you would have to...

I'm not aware of any hard limit, only ones imposed by available resources.

To answer the original question, each has its advantages and disadvantages - you would have to...

It doesn't stop the proc from being cached exactly, but it makes it inefficient. When a proc is first compiled (on first use) the parameters are known and can...

If you can modify the createOrder proc then I would first investigate whether it can be changed to read the rows directly, or populate the rows into a temp table...

If you are scripting your backups you can check the database status in sys.databases and only backup those databases that are available. The same script can then run on...

Not necessarily ... stats can update regardless of the fragmentation levels, and regardless of whether the stats need to be updated.

To generate stats the engine needs to read the table,...

You might also want to have someone confirm (in writing) that restores are also the responsibilty of the sysadmins, and that they have someone competent to recover the database(s) accurately...