Ok, finally got it to install, what I did was:

1. Install SQL Server - everything except the SQL tools.

2. Extract the second x64 archive (disc 2)

3. Navigate to folder in...

Thanks, Oh well - its more of a pain than anything else - especially when you know it can't be more than a reference in a hidden system table somewhere...

Also, just because you use NOLOCK, doesn't mean that nothing is locked.

I ran into a nasty issue a few years back when a SELECT statement caused the Pages of...

Hi All, thanks for all the help.

I had re-installed SQL Server a number of times, and tried applying sp3a and sp4 without any luck.

The most confusing thing was that even...

Yep, I've had issues with Windows Firewall before. I have stopped the service as well as the anti-virus etc, and still am not having any joy. I have compared my...

Yep, it looks fairly normal:

TcpPort = 1433

TcpDynamicPorts = Empty

TcpHideFlag = 0

Other Key:

LoginMode = 1

ListenOn = SSMSSH70

SSNETLIB

DefaultLogon = guest

SetHostName =...

From what I recall (I haven't done this for a good year), it is the same name and ip address.

The default will depend on your network submask etc, and its...

Hi, running the query through Query Analyser, with the show execution plan option on will help determine what might be the problem.

I agree that you may need a clustered index, but...

Did you ever get to the bottom of your problem?

I have encountered the same thing when connecting from Delphi consoles (via BDE) to SQL Server over a network.

Thanks,

As suggested - use SQL Server Profiler to monitor missing statistics (errors and warnings) while you run the query. My theory is that your statistics could be missing altogether. While...

Without statistics SQL Server cannot make accurate guesses over which execution plan is best. Unfortunately, sometimes updating the statistics after a query/stored proc has already performed poorly doesn't always help....

Yep, its possible to write an application which runs on the cluster and writes cluster events to a port.

Check out the following page on MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mscs/mscs/notification_port_example.asp

You should be able to re-attach the database, if all is in order, and the files are identical.

There are a number of things to bear in mind though. Firstly, you...

How about writing your own simple service which can be registered with the cluster administrator?

Your application could then log the information about when the service is starting or stopping, as...

Well, I haven't had a good look at your scripts, but may I suggest the following:

Firstly you should get the execution plan of the fast queries and then compare it...