After you do the install, you change this...

It depends on the system, but, in general, you should retain 1-2gb for the OS, so set...

It sure sounds like it's statistics related. When you rebuild the stats, are you using sp_updatestats or are you running UPDATE STATISTICS? If the former, try using the latter and...

When you say performance tuning, what do you mean? Do you mean monitoring and alerting or something that will literally suggest or make changes to your system and/or queries?

I really don't think this is a good solution for a production system, at all, but if you want very fast restores, you should take a look at something like...

I'm with Steve. However, this checklist will give you a starting point.

Performance on that query should be interesting. By interesting I mean, very, very slow.

Just so you know, LIKE statements with a leading wild card lead to scans with no opportunity...

Ninja's_RGR'us (12/5/2011)

---

Grant Fritchey (12/5/2011)

---

Ninja's_RGR'us (12/5/2011)

---

Grant Fritchey (12/5/2011)

---

Oh crap!

I edited that. Oops....

Ninja's_RGR'us (12/5/2011)

---

Grant Fritchey (12/5/2011)

---

Oh crap!

I edited that. Oops. I'm sure that...

Oh crap!

I edited that. Oops. I'm sure that didn't help at...

nico van niekerk (12/5/2011)

---

Grant Fritchey (12/5/2011)

---

nico van niekerk (12/4/2011)

---

...Table variables are created in memory with the current batch as scope exclusively. #temp and other tables are explicitly created "on disk"...

nico van niekerk (12/2/2011)

---

The original query's construct, somehow, allowed SS to rely on the statistics alone and not look at the query from a new perspective. The OPTIMIZE hint steered...

I realize this thread is 18 months old, but I'm...

nico van niekerk (12/4/2011)

---

...Table variables are created in memory with the current batch as scope exclusively. #temp and other tables are explicitly created "on disk" as you put it, and...

The chapter I wrote for the MVP Deep Dives 2 book is all on parameter sniffing "Parameter Sniffing, Your Best Friend in the World, Except When It Isn't." I lay...