"Logic bug"? Heh... what's that?

I'm with Gus... if you do it right, it won't matter one way or the other. Using one or the other to make up for,...

No - the 32bit version of SQL has the same limitations that it would have on a 32bit OS. There is no reason to install the 32bit version on...

Ed Wyant (5/6/2009)

---

Hi everyone. Got a 64 bit 2008 server and want to install a 32 bit 2005 instance. Don't have the 64 bit SQL media on site. Has anyone...

No degree - went the Army route instead. Started as a computer operator, moved on to programmer and eventually DBA. I have now been a DBA for more...

SQL Server does not automatically allocate the minimum or maximum memory when it starts. It allocates the memory as it is needed. Once it reaches the minimum amount...

It depends - how much memory does the server have? Is this a single instance server - in other words, are there other SQL Server instances running on this...

I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using SELECT - if you are...

Not sure why you are getting these errors - I have no problems running those types of processes using Standard Edition.

Could it be that you don't have the standard version...

That drop-down works more as an MRU type of list - basically listing the most recently used server connections. There is another tab available on that dialog - select...

I am not sure what the problem is - but when running SQL Server 2005 Standard Edition (x64) there are issues when you have lots of memory.

I know that I...

Is this SQL Server 2005 Standard edition? If it is, you may need to drop the max memory even more. With 16GB of memory available, you might find...

I am not sure what you mean - where are you looking for localhost and it is not appearing?

Matt (4/27/2009)

---

Thanks guys, I was hoping that it was normal practise to restart on a weekly basis, but it looks like I'll have to try and diagnose the problem, or...

psangeetha (4/27/2009)

---

Sorry, I have another doubt. Is it required to rebuild the views after the SP3 install??

We are having some issues on a few programs that runs a...

This looks good to me - but, here are the questions I would ask:

1) Is this an upgrade from 2000? If so, have you updated statistics/rebuilt indexes/etc...

2) Is this...