Viewing 15 posts - 76 through 90 (of 279 total)
Great article Paul! Looking forward to next weeks article.
April 12, 2010 at 9:37 am
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...
April 8, 2010 at 7:10 am
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...
April 7, 2010 at 1:36 pm
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...
April 5, 2010 at 8:49 am
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?
April 1, 2010 at 8:54 am
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...
April 1, 2010 at 8:40 am
Kit G (4/1/2010)
Any chance of getting a translation of that Latin in that last paragraph?
One transaltion I got was this
But in truth these and to accuse and due forms to...
April 1, 2010 at 8:12 am
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...
March 31, 2010 at 10:02 am
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,...
March 31, 2010 at 9:29 am
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...
March 31, 2010 at 9:08 am
What command did you use to Reorganize the index?
March 31, 2010 at 8:48 am
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...
March 31, 2010 at 8:30 am
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
March 29, 2010 at 9:33 am
...and I guess the only caveat on doing this, of course, is that none of the databases to be mirrored have the same name....
March 25, 2010 at 6:40 am
Viewing 15 posts - 76 through 90 (of 279 total)