Hey,

I would suggest you set-up an alert in performance monitor to send an email, when data file size for tempdb is over a comfortable threshold, which provides ample opportunity for...

If you enjoy it, love it and breath it, then sky's the limit!

Good luck!

Hi,

If you are not selecting a range or large result sets, do not require record set sorted or not grouping, then no real benefit of a clusterd index, but I...

Hi,

Why?

Thanks,

Phillip Cox

Hey,

This should get you started.

http://technet.microsoft.com/en-gb/library/ms151827.aspx

Thanks,

Phillip Cox

Hey again,

Sorry, I forgot to add, the O\S needs at least 256MB, but to keep paging to a minimum and taking into consideration the applications on server, 1GB would be...

hey,

I would suspect some of the memory is being used for video.

Thanks,

Phillip

Ah, thanks for update regarding bookmarks!

I have restored the same database to each instance, thus everything is exact same and everything is running on same machine. This is why...

Hey,

There is absolutely no reason you couldn't configure 2 x SQL Server 2K5 instances on old server, but you would need to ensure memory is limited for each instance (e.g....

Sorry, question is: Has the query optimizer changed that much in terms of building an execution plan. In addition, the SQL Server 2000 run has book-marks, but none...

Hey,

You can also use Replication Monitor or review Replication container within SQL Server Management Studio.

Thanks,

Phillip Cox

Hi,

This looks like a SP1 issue and first port of call would be to install SP2 to see if problem still persist. This bascially means the CPU schedulers are...

Hi,

I have experienced this problem not so long ago and the workaround was as follows:

1. Completely remove all previous references to Oracle Client

2. Restart server

3. Re-Install 64-bit Oracle10g Release 2...

Hi,

Have you installed latest service pack to hopefully eliminate any network component issues within SNAC or MDAC? Sounds like a possible Time to Live problem, which would be a...

Hey,

Please review Vidhya Sagar's steps, as this is how you can create a new log file.

Thanks,

Phillip Cox