If you really want to appreciate some of the finer points of the max server memory setting, read this by Slava Oks.

Me? I start deliberately low and then increase...

Please see my previous post for details. Also:

Make sure you are doing a REBUILD rather than a REORGANIZE.

REORGANIZE just shuffles stuff around inside already-allocated pages - it...

Well spotted Ian! I have also corrected my typo recommending 6.5GB on an 8MB server :laugh:

But which one...?!

So sorry bro - I just find your name hard to recall/type - my bad.

Sorry - ta.bu.shi.da.yu 🙂

I don't mind people posting to say...

Last thing (can't believe I didn't mention this before):

If it is VAS pressure/fragmentation (it almost always is, especially if you can last for 3 weeks before a reboot), use the...

Yes. This one seems fine so far.

Though I must say that I agree with Ian Scarlet, Silverfox,...

To answer the original question:

Enable AWE. Follow the instructions in This Technet Article. Make sure you follow the instructions for your version of Windows (2003).

There is a link...

mjarsaniya (9/11/2009)

---

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build...

Jeff Moden (9/11/2009)

---

I've not had to actually setup a production server in quite some time... I've usually had the pleasure of a "System's DBA" setting them up in all the...

To expand the original example to illustrate the point:

DECLARE @nstring nchar(1)

SET @nstring = N'Åkergatan 24'

SELECT UNICODE(@nstring),

NCHAR(UNICODE(@nstring)),

...

ta.bu.shi.da.yu (9/11/2009)

---

Silverfox (9/11/2009)

---

Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the same...

Cool. While you are correct that the article I referened talks about SELECT INTO, the situation with INSERT INTO is similar.

The code INSERT INTO @Employees SELECT Emp_No , EName,...

The idea is to include code based on that snippet into the procedure of interest,...