In our Island there is one make of car that they always target. Toyota. Especially Yaris.

What is the latency that you are getting. In my set up we get a latency of 2 to 3 sec. If your Distributor is sharing the same DB as...

By any chance the Application is Purging Data using Truncate table command?

Sorry to hear about the Break in. I know that if you see them by any chance inside the apartment, you are going to give them a whooping of their...

sp_recompile uses quite a bit of resource. It does a cache lock when it has to a recompile. So be careful when you are doing a recompile on a server...

Sql Server DBA with 4 Hrs of experience. Thats a strange experience... 🙂

You know what Sam, If I was in your position, I would gladly take up the offer. You get to learn a lot and get into a field that is...

Flash drive is the magic word my man... Just kidding..:-)

Windows 2003 Enterprise edition 32 bit can give you total of 32 GIG RAM.

You can use SAN to have very large DB.

This is what I have read about Windows 2003 Datacenter.

Windows Server 2003, Datacenter Edition is designed[8] for infrastructures demanding high security and reliability. Windows Server 2003 is available for x86,...

Then why not move to Windows 2003 Datacenter Edition? This will give you the chance to add more memory without having to use a mixed bit environment.

Here is an MSDN link that explains your issue.

http://msdn.microsoft.com/en-us/library/aa224554.aspx

Also maybe try running Update stats would also help.

This guy reminds me of the White house guy that was in the forum.