You'll have to test because as usual, it will depend on your workload and data. Here is a great place to start:

Does Index Fragmentation Matter with SSD’s?

dwain.c (11/15/2012)

---

opc.three (11/15/2012)

---

Linked Servers are useful for server-to-server communication but if you're just needing to communicate from one database to another on the same instance then Linked Servers would not...

According to Kalen Delaney (buy her book) you can safely disable these services on Server 2003 running SQL 2008:

Alerter, ClipBook, Computer Browser, Messenger, Network Dynamic Data Exchange (DDE), Task Scheduler

I...

Linked Servers are useful for server-to-server communication but if you're just needing to communicate from one database to another on the same instance then Linked Servers would not be a...

bugg (11/15/2012)

---

Luis Cazares (11/15/2012)

---

The "." is not part of the table name, it's the schema name.

You could check the Stairway for Database Design, it can give you an introduction to...

The site says under Requirements:

Is CozyRoc Script Task Plus something that must be purchased?

RTO > Recovery Time Objective: the duration of time and a service level within which a business process must be restored after a disaster (or disruption) in order to avoid...

You skipped Step 1. Please define your RTO and RPO, then you can start to evaluate your options. If your RPO is 24 hours then Simple Recovery Model with nightly...

kwyman (11/15/2012)

---

Can anyone help me with adding log in information to a script task which goes to a webpage?

The current code I have is :

string website = "http://www.findafosters.com/formbuilder/export_entries.php?id=9&type=csv"; //or...

Just curious, is this another design where the UUIDs are generated in the app tier within disconnected memory-resident objects and then committed to the database when the user likes what...

eugene.pipko (11/15/2012)

---

Not sure why it doesn't make sense to you.

For instance you have a scheduled job that runs at 6PM daily. You have an automated email every morning reporting success/failure.

Then...

Huh? If one job executed twice then asking "which one executed last" does not make a lot of sense since it is the same job that executed both times.

For detailed...

OK, have to keep going 🙂

It would be convenient to know whether these drops were caused by internal or external memory pressure, but it could be a combination.

External - Do...

marc.snoeys (11/14/2012)

---

Apparently there is a view where one can query for possible problems when changing to a CONTAINED database: SYS.DM_DB_UNCONTAINED_ENTITIES

But a query on this view does not show this...

Thanks for the detailed write-up! Are you confirming that the reduction in reads due to adding a new covering index has curbed the PLE drops?