Great article Paul! Looking forward to next weeks article.

For 80 CALs + Server License you'd probably pay more than 2 CPU Licenses....

If it is only 1 CPU, then per CPU license is definitively the way to go.\So, in...

The way you are running it, it will still do it on all the objects in that database and then only return the results for the Invoice table.

You might want...

jwa082276, did you ever find out why the query was running slower with more memory?

We are having some weird issues that are intermittent but kind of similar after we upgraded...

It seems like you have a disparate installs of Cumulative Updates and Security Patches, which yielded those "odd" versions.

Now, the A Server, is Standard, not Enterprise, will that matter?

I am not sure, but I believe the OP meant to know the number of current requests on a SQL instance.

To obtain the number of current connected sessions you could...

One transaltion I got was this

But in truth these and to accuse and due forms to...

Brilliant Steve!

I'd suggest creating a new post with that inquiry, so it gets proper attention. Embedding it here will probably not produce answers you need, plus it makes it more difficult...

How many results where you getting before?

Did you by any chance change the Database selected in SSMS? If you are not in the same database where the tables reside in,...

In that case it should only have reorganized that specific index. I thought you might have used the ALL parameter on a table which would have done all indexes on...

What command did you use to Reorganize the index?

Here's the solution we use:

-- 1) List all Orphaned users on existing DB

-- 2) Associate the DB User with the server Login, if existing

-- 3) If 2) fails, try to...

not sure if related, but the line that reads

FETCH NEXT FROM my_cursor INTO @SPId

should be changed to

FETCH NEXT FROM my_Spid INTO @SPId

...and I guess the only caveat on doing this, of course, is that none of the databases to be mirrored have the same name....