Michael Valentine Jones (11/2/2012)

---

If you don’t have a clustered index on a table, you can have serious problems with empty pages that never get de-allocated. I once found a...

Thanks for all your replies.

Although it would normally be very unusual for me NOT to use a clustered index (yeah, yeah, i've been there, done that, got the t-shirt) I...

Thanks for the textbook answer. Not!

Yeah, that's what it says "in the manual", but the reality is that there is a point below which a Clustered Index is more of...

Bump.

As mentioned earlier, it turns out the Dev just used all the recommendations from the DTA so the indexes are a joke and I will get rid of pretty much...

We're using 2008 "Original" 🙂

This is why I love Microsoft...

The link you provided (which I also found earlier when searching through the MS website) seems to contradict the information in...

OK, reading through the latest SQL 2008 Licensing pdf I reckon in the example I gave it would be scenario 2 and i'd just need 1 CPU licence. http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

However, if...

Also you can download the SQL Server Migration Assistant (SSMA) from Microsofts website.

This nifty tool allows you to migrate a whole or partial database (ie: just one table) plus data...

We have 200+ Instances (increasing by the week it seems).

Builtin\Admins removed, SA set to a formula that can be worked out if necessary but no-one would normally login with SA.

Where...

At the moment there isn't too much traffic from the handhelds.

They can update live via GPRS when required but quite often they get "docked" in the evening and data currently...