Viewing 15 posts - 76 through 90 (of 275 total)
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
Why would you want to do that? You can't.... turn off the SQL services and you'll have access to them.... but careful, messing with them can render an unusable SQL...
March 24, 2010 at 7:36 am
Idera's SQL Diagnostic Manager includes the SQL Mobile Manager that lets you do that and much more. Of course, it is a steep price if only or that product.... plus...
March 22, 2010 at 9:14 am
Now, with Gail's explanation and what the OP did (take out of read only, Full backup, back to read only), the LSN for the Full backup registered would the one...
March 18, 2010 at 2:15 pm
Viewing 15 posts - 76 through 90 (of 275 total)