Viewing 15 posts - 721 through 735 (of 18,926 total)
SQLRNNR (11/29/2011)
ChrisM@Work (11/29/2011)
Evil Kraig F (11/22/2011)
SQLRNNR (11/22/2011)
riddleQuestion Mark
Mark is innocent!
3rd degree
I got 3 first degrees here. Who do I talk to? 😀
November 29, 2011 at 9:50 am
We're completely outside my expertise here... going to have to bow out of this one!
November 29, 2011 at 9:45 am
jeff.coulson (11/29/2011)
So, that's cool, I can build another sp that will execute the others in the sequence I place them in? Excellent!
Yes you can. (should) 😉
November 29, 2011 at 9:44 am
Just to add to what's been said.
If you're waiting on something to complete outside the current scope you can waitfor delay.
You can also use jobs to schedule things at time...
November 29, 2011 at 9:40 am
How long does it take if you do select top 1 or top 100?
Network debuging is way outside my competence. What did the network admin say?
November 29, 2011 at 9:22 am
Then you can only wait.
Or increase the bandwith.
There's no magic button here.
You have a traffic bottle neck.
Increase the neck or reduce traffic.
November 29, 2011 at 9:11 am
Bcp out, zip, copy, unzip, bcp in??
November 29, 2011 at 8:58 am
NickBalaam (11/29/2011)
Does the "nolock" table hint you're using in the select statement negate the isolation level in this case?
No idea what takes precedence here. "Should", "might" make sens to...
November 29, 2011 at 7:22 am
TheSQLGuru (11/29/2011)
How many times do we need to ask you for the code that does the insert and select???
1.876 LACK. :hehe:
November 29, 2011 at 7:01 am
Trying to think outside the box.
Calculated fieds with functions?
Schema bound views?
Long open tran?
November 29, 2011 at 6:40 am
Denesh Naidoo (11/29/2011)
I ran dbcc useroptions to get this - isolation level = read committed
This is for the current connection, not the 2 external ones.
November 29, 2011 at 6:34 am
Dev (11/29/2011)
Ninja's_RGR'us (11/29/2011)
Transaction isolation level?repeatable reads would cause this.
How?
Google broken??
There's a link somewhere, a bug in SS is very unlikely. Could just be a dev with an...
November 29, 2011 at 6:26 am
Transaction isolation level?
repeatable reads would cause this.
November 29, 2011 at 6:20 am
TheSQLGuru (6/30/2009)
>> negative faithNew term - I think I may like it! Although perhaps antifaith could be better. 🙂
Or simply DTA = ANTItuning
November 29, 2011 at 4:58 am
Viewing 15 posts - 721 through 735 (of 18,926 total)