A good deal, will be purchasing this.

Is there a good reason why this new hardware has to have the same names? After all the SQL server instance does not use them.

I would add a third...

Something I found out a couple of years ago to remember, additional features cannot be added once you've set up a cluster. I've always found it prudent to install...

I had a similar issue with this when it came to a restored db which contained an old schema related to the user being created. I had to drop...

Idera also do a free tool if you are able to install it.

Idera Permissions 2.0[/url]

I see what you mean as a temporary space requirement. I had to retest this to confirm my original interpretation on space was right 🙂

create table temp2(uid INT identity...

Oliiii (10/21/2010)

---

Creating the clustered index might take way too long and use a lot of space (you'll need at the very least the size of your table in extra free...

Our current rowcount is 1,169,466,138. Its a matter of scale. 😉

I'm not a fan of the idea that you will be partitioning the data on a column that will be updated. This will bring about an overhead in the...

GilaMonster (10/20/2010)

---

I have personally brought down a busy production server...

FWIW I've found lightweight traces are...

This is the key page for understanding how SQL Trace works and feeds into the I/O providers (rowset/SMO/Profiler is one of them).

SQL Trace

The rowset provider, on the other hand, is...

It might be worth assessing your capacity requirements before making...

The transaction log backups made for log shipping are identical to the ones that would be produced from a transaction log maintenance plan and can be used in exactly the...

For the purposes of this post I'll assume you meant ALTER INDEX. I've just double checked and REORGANISE isnt a table option. 😉 REBUILD could work but...