a colleague used to have a personal account with these guys that he was pleased with (they offer a corporate/workgroup account according to the FAQs under "How it works")

Safari books...

"selectivity" - that's the word, it's been driving me crazy all day trying...

If it's only selects, and you have the space for more indexes, I'd certainly consider adding them.

Of course, as with all these things: testing, testing, testing 🙂

Edit: and of course...

If you have a lot of inserts/updates/deletes happening, then you could take a hit as each index would have to be updated when these happen.

Also you would have increased filesize...

Armathreaddon

That looks very handy - thanks!

I grew up in Greece and, back when I was a student, the mere mention that I was studying Mathematics would elicit "Oh, so you'll want to become a teacher...

Thanks very much Adi, very useful!

Clifton Collins (4/1/2009)

---

When a new database is created using a script and the script objects are not in dependency order, objects will be created, but the sysdepends table is not...

It can take a while to run, and as far as I've noticed, you can't run contains() queries while it's populating (ie, they return no data)

I think if you right...

Update:

I have now found this:

http://www.sqlservercentral.com/scripts/Administration/62801/

Seems a bit...

I don't spend too much time at work on the SN sites, although they have made me late for work on occasion! We work flexible hours here, so it's not...

Jeffrey Williams (3/27/2009)

---

Once an index is disabled - the only way to enable it is to rebuild. Rebuilding an index that was disabled in an offline operation (meaning, the...

Thanks very much Jeffrey

Jeffrey Williams (3/27/2009)

---

Since you are truncating and loading every time - here is what i would recommend:

1) Disable all NC indexes

a) Leave clustered...

Grant Fritchey (3/27/2009)

---

It is one of those places where your mileage will vary, so testing is necessary.

Ordering the data helps.

If you're using GUID's, make sure you use sequential guids and...