Ola and Michelle. Anything else is a waste of time.

Cost alone? Nah, surely not. Not that SQL Server is cheap any more, it isn't, but DB2 is hardly the low cost alternative. It's either politics, or some other piece...

Oops. Instead of server there at the end, I should have said instance. That's more accurate.

Yes, 2012 has the shared disk cluster through the Failover Cluster. Same as before. You can also have Availability Groups, but they're actually a separate thing to set up and...

ONLINE index rebuild uses both memory and tempdb to keep the index online while the the rebuild process occurs.

I don't know Ola's scripts enough to help out.

tony28 (3/26/2014)

---

Thank you.

My boss said me about it, I said him this solution today morning, but it can be problem with cpu and first few minutes can be slowly... but...

Memory should manage itself, really. But if you need to clean a query out of the cache, you can get it's plan_handle value from sys.dm_exec_requests or sys.dm_exec_query_stats and then use...

paul.knibbs (3/26/2014)

---

Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something...

Contact Microsoft, from whom you have a license, right? They'll give you a link to download it.

No, it won't cause the service to restart. SQL Server is smarter than that. It will flush older information out of the memory. In addition to the book Gail recommends,...

Another vote for Itzik Ben Gan's book. It's an amazing resource.

If you can get the restore, the statistics and fragmentation will be the same after the restore (assuming you restore it to the same version of SQL Server). But you...

Maybe. I mean, the organization I was with is still using SQL Server,...

The Dixie Flatline (3/25/2014)

---

My poster child interview disappointment: Good resume' on paper, but then the man walked in, opened up his laptop, and scrolled through a "cheat...

ScottPletcher (3/25/2014)

---

Grant Fritchey (3/25/2014)

---

ScottPletcher (3/25/2014)

---

Grant Fritchey (3/25/2014)

---

I can't see the query since it exceeds the size of what's stored in the plan, so suggestions from the plan alone are going...