Viewing 15 posts - 18,226 through 18,240 (of 19,564 total)
Thank you. You posted a question and still worked on solving it. Thanks for posting back the solution you found.
January 11, 2010 at 10:55 pm
Steve Jones - Editor (1/11/2010)
Go with the one you feel comfortable with. You'll deliver it better, and I bet you get more questions on it.
Heh, that is the way I...
January 11, 2010 at 10:54 pm
Lowell's solution should work nicely for you.
One question - will the order of the records always be the same (agegroups will not get out of order)?
January 11, 2010 at 10:46 pm
Deadlocks was the primary goal.
The Backup plan was to discuss an inventory solution. More lessons on getting to know your data better. I feel more comfortable...
January 11, 2010 at 10:37 pm
Lowell (1/11/2010)
January 11, 2010 at 10:24 pm
WayneS (1/11/2010)
...PS. Jason - just how do you go about embedding the execution plans inside the messages? I've seen you do this many times...
Wayne,
set statistics xml on
Or Click show actual...
January 11, 2010 at 9:40 pm
Jeff Moden (1/11/2010)
WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
:blush:
Still, that's an interesting warp on the "quirky update". Nicely done, Wayne.
It would be interesting to run a...
January 11, 2010 at 9:35 pm
WayneS (1/11/2010)
Probably not random enough, but I changed the 5 initial rows (abc xxxxx, etc.) to be:
1st row: abc 1,
2nd row: zyx 100,
3rd row: def 10000,
4th row: ghi...
January 11, 2010 at 9:31 pm
And now, while I was typing up my last post, I see that Wayne has gone and updated the script he provided.
January 11, 2010 at 7:13 pm
lmu92 (1/11/2010)
CirquedeSQLeil (1/11/2010)
...
Ok, I now have had some time to go back and redo the tests.
I found one flaw in my tests - they were not equivalent. In the...
January 11, 2010 at 7:11 pm
Worth a shot on the service account. Set both to use the same account.
January 11, 2010 at 5:06 pm
lmu92 (1/11/2010)
I would use an index on ID, idx on table [test] for it...Running over a minute for 100k rows seems strange...
What test scenario do you use?
I will get back...
January 11, 2010 at 4:46 pm
Is the Browser Service running in both instances?
Also, is the server defined using the \InstanceName or using the ,portNum method? Have you tried both methods?
January 11, 2010 at 4:45 pm
Are you using named instances by chance?
January 11, 2010 at 4:29 pm
lmu92 (1/11/2010)
CirquedeSQLeil (1/11/2010)
I have tested both scripts and compared results.
I would go with the script provided by Wayne. When the result sets are small, then both are similar. ...
January 11, 2010 at 4:27 pm
Viewing 15 posts - 18,226 through 18,240 (of 19,564 total)