Viewing 15 posts - 286 through 300 (of 522 total)
Hugo Kornelis (9/4/2008)
Christian Buettner (9/4/2008)
I have adjusted my post above to remove the wrong information.
.... that I seem to have overlooked thus far. And now I find myself wondering what...
September 4, 2008 at 10:28 am
dunnjoe (9/4/2008)
Chris,Doesn't the second solution have to do the same B-tree traversal?
Good question, today, and good discussions!!
Joe
Hi Joe,
yes it does.
I assume I have not cleared the table between my tests.
Therefore,...
September 4, 2008 at 6:35 am
Nice question, but not "totally" deterministic in my opinion.
What If I ensure consistency through the transaction isolation level already?
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRANSACTION
IF NOT EXISTS... INSERT...
COMMIT
Edit: Deleted...
September 4, 2008 at 12:38 am
Hi dans,
You might try something like in the attached example.
I have not spent too much time verifying it, so it might contain a few errors.
But the concept might be helpful.
I...
September 3, 2008 at 5:17 pm
rbarryyoung (9/3/2008)
Here's what I get when I execute your script:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Msg 9421, Level 16, State 1, Line 5
XML parsing: line 149, character 30, illegal name character
Hm, I should have tested against...
September 3, 2008 at 3:12 pm
Try this one:
DECLARE @A nvarchar(max)
SELECT @A = ISNULL(@A,'') + OBJECT_DEFINITION(object_id) + '
GO
' FROM sys.procedures
SELECT CAST(@A AS XML)
Explanation:
1. Use OBJECT_DEFINITION to get the full script of the object in nvarchar(max)
2....
September 3, 2008 at 1:53 pm
GilaMonster (9/1/2008)
rbarryyoung (9/1/2008)
Of course we use a startup procedure to define the UDT's in TempDB.Does defining them in model work as well?
According to this article, yes
September 2, 2008 at 1:31 am
Hugo Kornelis (9/1/2008)
If this is the compliment it looks like, then I thank you for it.
Yes, it was a compliment (although a "passive" one ;-). You are welcome.
September 1, 2008 at 7:14 am
Hi skyline666!
I have turned off the daily notification, therefore I don't get the author from there.
And I usually use the link on the left menu and therefore missed the QOTD...
September 1, 2008 at 4:33 am
Hm, I am not sure whether I am correct, but from the QOTD, it is not clear whether the several steps involve the same tables or different tables. So DROPCLEANBUFFERS...
September 1, 2008 at 2:45 am
Aleksandr Furman (8/27/2008)
skyline666 (8/27/2008)
Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).
That's...
August 28, 2008 at 12:54 am
YeshuaAgapao (8/26/2008)
August 27, 2008 at 6:52 am
This is an interesting conversation. But it also reminds me that we all often are not what we make others believe we are.
The best examples are the rituals we...
August 22, 2008 at 6:40 pm
Mark D Powell (8/21/2008)
Blame MS not the author or question as I...
August 21, 2008 at 5:51 pm
Christian Buettner (8/21/2008)
One of the system pages stored in both the primary data file and the first...
August 21, 2008 at 5:29 pm
Viewing 15 posts - 286 through 300 (of 522 total)