I wonder if you partition SSDs if that screws up the write-leveling infrastructure. i.e. does the write leveling not really honor partition boundaries. If it doesn't and the...

paul.knibbs (2/3/2010)

---

If they were to add some RAM, though, virtualisation might well make more efficient use of the extra RAM than three separate instances of SQL server do; for instance,...

David.Poole (2/2/2010)

---

If you have separate instances then you can of course use sp_configure to specify a maximum amount of memory for each instance.

You can also specify which CPUs get used...

Paul White (2/2/2010)

---

TheSQLGuru (2/2/2010)

---

Something tickled the back of my mind on this one that there was an important reason for giving the engine some breathing room between the min and...

Paul White (2/2/2010)

---

Oh it...

About min = max memory - See here: http://msdn.microsoft.com/en-us/library/ms178067.aspx

Setting the Memory Options Manually

There are two principal methods for setting the SQL Server memory options manually:

In the...

kakapuri, you have gone back and forth several days on this forum to try to figure out your issue. Time for me to yet again recommend that you get...

Thanks for the Myth Busting there, although I will point out the obvious in that you get the 'right' plan with temp tables without the need for the OPTION (RECOMPILE)....

with the limited knowledge of your system, data and data access patters I have I would leave the active table with char and make the history table variable.

Jeffrey Williams-493691 (1/29/2010)

---

You should not set the min memory equal to the max memory. This prevents SQL Server from managing memory correctly and can cause some problems (as you...

Rule of Thumb for Normal Stuff: avoid table variables until such time as you can prove that you are having recompilation problems.

Can you please explain how virtual servers will be more effective than separate instances on...

didn't we have a HUGE string-splitting thread on sqlservercentral some time back?? Lots of code examples, benchmarking, etc.

Personally I think this may be a case where CLR...

Employers had bad experiences in the past and I'm not hot with the idea of someone coming in and fixing things behind a curtain and then like a magic trick...

I know a production DBA who just moved to a new job because he had gotten his former company so stable and everything running so routinely that he became bored...