I've had a number of 4GB machines and they never go above 1.7GB. It seems that the server algorithms that balance memory with the OS max out here.

Not that I know of, but you could use VBScript and SQL-DMO to execute quries for a DBA.

That's a good question as to whether the defrags at the OS level help. If you could preallocate teh space, then at there shouldn't be a problem at the OS...

That is strange. Most likely the regional settings aren't applied until someone is logged in. Can you log in as the SQL Server service account and set the settings for...

Antares has the best suggestion. Follow his advice.

Windows 2000 SP4. At the end of thus year, all support for NT 4 goes away. While the OS is fairly stable, there are still security issues being found and...

You need to be sure you specify a different databaes name. You want to create a "new" database by restoring the original database's backup as a new database with the...

Can you post some sample DDL and DML? That's a strange one. I'd still suspect that it's a data issue, but it could possibly be some bug.

You'll need some type of delay to run profiler. What you could do is create a stored procedure to start profiler. There are various stored procedures to setup a trace...

I couldn't get objectname to work either. I tend to just record them all and then search later in the textdata column for those sql or sps that I am...

You can also run profiler for specfically that event. I'm not sure that event log will show the hostname. Keep in mind that hostname is a field that is "sent"...

Thomas,

Apologies!, I rebuilt it and it should be there now.

I agree with the above. Paper based systems are a problem in and of themselves. Most of us are getting less used to paper not more. Even email based "forms"...

That is interesting. I would have thought performance would be similar. This is a simple view, not an indexed view? Is there an index on these columns?

Perhaps the query processor...

There are decryption routines on the internet. Search Google and decrypt it and recompile on the new machine.