Viewing 15 posts - 91 through 105 (of 716 total)
Absolutely no idea abut this, so thanx 4 getting new info!
August 18, 2015 at 3:35 am
Ed Wagner (8/14/2015)
I've never used them either and guessed at what I thought was the closest one.
+ 1
August 16, 2015 at 11:30 pm
SQLRNNR (8/11/2015)
Yes the string length in the messages tab is 4000 characters. And the variable length is 48,893. Are you seeing something different in the messages tab?
Damn 😎 didn`t see...
August 12, 2015 at 12:04 am
g.maxfield (8/11/2015)
The result I get when I ran all the code is 48893
+1 Same here, trying to figure out where is the mistake exactly.
August 11, 2015 at 4:56 am
Uwe Ricken (8/6/2015)
In my test Environment with 4 cores, 32 GB and SSD the elapsed times were:
dbo.GUID: 1.45 seconds
dbo.Identity: 5.32 seconds
dbo.heap: 3,98 seconds
NO OTHER USER PROCESSES WHERE ACTIVE ON SQL...
August 6, 2015 at 6:34 am
That is 1 good tricky question, thanx!
Stewart "Arturius" Campbell (7/31/2015)
Closing Query 1 effectively disconnects the session.
Query 2, being a SELECT *, while running, takes an exclusive table lock on the...
August 2, 2015 at 11:32 pm
Good question & new piece of information for me, so thanx a lot.
July 27, 2015 at 11:08 pm
Viewing 15 posts - 91 through 105 (of 716 total)