Hello Jack,

This is also my understanding when SQL need to read (a page at the time) but I need to make sure what this profiler number mean.

having x read i/o...

As Grant Fritchey said, it is probably a permission issue.

One thing I often see and it's overlook is the file / folder permission. Even if all services are using admins...

Thank you for taking time! I'll take a look at the solution and understand what I did wrong with mine.

I've coded an iterative replacement but it lack the optimization of the CTE. Still if someone could get the CTE to work I would be very grateful.

Here's the working example...

I do not recall everything but I do remember that there was a new cluster system (using votes from each nodes).

More node support (up to 16)

New quorum model

Table disks less...

I found the issue and how to correct it. No need to think about it.

Forgot to add, here's the list of supported OS:

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

You need SP2 minimum to run it on win2k3 if you plan to go that path

It is not a question of issue installing it on a win2k3 box instead of a win2k8 box. It is a question of features. If you are in a cluster...

What I would suggest as a first step is to use profiler and check if the query is really executing within the same amount of time as SSMS do and...

This is the reason I wanted to use the estimated one, having a feeling of what it looks like rapidly. Using the actual one would take a long time to...

Ok.

You can mark it as answered 😛

I forgot something that will speak out the answer by itself.

Which is what is the main purpose of SSC? What is it's living reason.

This will answers what need to be...

From a learning point of view I totally agree with the replies found on that thread Lynn. When I'm looking at an issue I'll gladly read mostly everything related to...

Plus it is slightly more efficient not using brackets than it's exact counterpart. So two birds one stone.

No object should have a space in them as well as being a SQL keywords. In others words, if brackets are needed, the object name is not valid.

The main purpose...