Viewing 15 posts - 3,916 through 3,930 (of 18,926 total)
Lowell (8/2/2011)
Ninja's_RGR'us (8/2/2011)
sqlfriends (8/2/2011)
Lowell, just curious how did you add the image to the post?
Upload the image, then right click on the attachement and hit copy link.
Then use the img...
August 2, 2011 at 2:01 pm
Krasavita (8/2/2011)
Thank you, But What do I need look for on seting up a new server(memory...)
You need the specs for the new server?
How can I possibly know that?
What...
August 2, 2011 at 2:00 pm
Actually...
Dump the main query into a temp table.
Put a synonym on it.
Call the itvf and use the synonym and use that to return the final dataset :alien:
http://www.sqlservercentral.com/Forums/Topic1145600-2965-1.aspx#bm1149754
So in essence it...
August 2, 2011 at 1:58 pm
Leo.Miller (8/2/2011)
Jeff Moden (8/2/2011)
Leo.Miller (8/1/2011)
August 2, 2011 at 1:55 pm
sunny.tjk (8/2/2011)
Can someone please reply?
We're free volonteers here, we don't work for you.
I don't know this one but since we're talking about windows permission I guess admin on the local...
August 2, 2011 at 1:53 pm
cfradenburg (8/2/2011)
Ninja's_RGR'us (8/2/2011)
Converting int to varchar might force the server to do index scans rather than seek. This is far from optimal.
Indeed. But if the DDL can't be...
August 2, 2011 at 1:51 pm
The best step is upgrade advisor.
Ideally you'd have a way to rerun all the queries from the app to the new server.
sub-ideally you can run a trace for replay.
Of course...
August 2, 2011 at 1:51 pm
sqlfriends (8/2/2011)
Lowell, just curious how did you add the image to the post?
Upload the image, then right click on the attachement and hit copy link.
Then use the img tags and...
August 2, 2011 at 1:49 pm
cfradenburg (8/2/2011)
August 2, 2011 at 1:47 pm
Nothing more to say.
You ask the server to join an int column to a varchar so it fails because it can't convert the varchar to an int (yes...
August 2, 2011 at 1:46 pm
stolbovoy (8/2/2011)
Sorry for my impulsive reply. I just finished handled a performance issue caused by "it knows better" attitude. No attack perceived or meant
...and you couldn't handle the MS might...
August 2, 2011 at 1:45 pm
Bottom line is this. Don't use MP to do index maintenance. Steve pointed to an awesome, extremelly efficient way to do it.
Check out my full results with it...
August 2, 2011 at 1:43 pm
Are you sure the dataset is set as SP rather than text? Maybe that could be the difference :unsure:
August 2, 2011 at 1:37 pm
... and assuming tranid is the PK or already index, then no there's nothing you can do about it.
No hint can bypass the delete table lock for the update operation.
August 2, 2011 at 1:36 pm
That's where the smaller batch comes in. If the whole table is locked, the only improvement is to shorten that lock.
Also since this is archiving it doesn't really matter...
August 2, 2011 at 1:34 pm
Viewing 15 posts - 3,916 through 3,930 (of 18,926 total)