bpw (3/29/2012)

---

Thanks again Gail. I've read your post and watched a video you linked to - very useful.

I'm a bit confused about stats now, as DTA recommended creating lots (19...

>> table data increasing heavily

This makes me feel that manual statistics updates could also be a big benefit. With a large table you need to insert/modify 20% of the...

This is simply bad advice. There are MANY avenues to...

WRACK (3/28/2012)

---

Did not realise that this topic was still going. Well I have something to report. The client has finally appointed a DBA and I shall gladly handover everything I...

I've already said where! Auto-trading apps, they need to be super quick to find discrepancies in market prices and try to get some profit from it. As you can guess...

I think most admins will use sysprep to get an image ready to use as a deployable template.

Yes, it is. Integers are 4 bytes, and CPUs and code are optimized for their...

alark (3/27/2012)

---

GilaMonster, You heard me right. I will bring the secondary databases for testing the apps in DR environment, meanwhile primary databases will continue running in real production. Then after...

itpcpro (3/22/2012)

---

I was wondering if anyone has attempted this? We are wanting to create a VM image with SQL already on it so when we create a new VM Server...

>>but I have this strange feeling that you do not know how to do things efficiently in SQL Server.

Absolutely correct - and it shouldn't be a 'strange feeling' either, but...

GilaMonster (3/27/2012)

---

TheSQLGuru (3/26/2012)

---

I have a client with OLD ADO Classic crappy code on SQL 2005 RTM that gets MASSIVE plan cache bloat. I run a job every 30 minutes...

I think you absolutely, positively must split the inputs into a firstname and lastname in the UI. That must be part of an efficient solution I think, and it...

Confusing Queries (3/26/2012)

---

so, under...

+1. I like that much better than chewing through plans to evict!

Robert Davis (3/26/2012)

---

If you modify...