Viewing 15 posts - 4,726 through 4,740 (of 8,416 total)
COldCoffee (3/29/2010)
March 29, 2010 at 12:33 am
Another option is the EXECUTE AT syntax:
Example:
EXECUTE ('SELECT * FROM master.sys.tables WHERE name LIKE ?', 'spt%') AT <linked_server_name>;
The parameters are handy.
March 29, 2010 at 12:00 am
WayneS (3/28/2010)
Paul White NZ (3/27/2010)
The article I wrote on APPLY is in the queue for publication.
I'm ready for it! Judging solely by some of the posts where you have utilized...
March 28, 2010 at 11:54 pm
shashi_1409 (3/28/2010)
March 28, 2010 at 11:51 pm
Jeffrey Williams-493691 (3/28/2010)
March 28, 2010 at 11:46 pm
DECLARE @xmlDocument VARCHAR(8000),
@docHandle INTEGER;
SET @xmlDocument = '
<?xml version="1.0" encoding="UTF-8"?>
...
March 28, 2010 at 11:39 pm
The Dixie Flatline (3/28/2010)
I love the word "uniqueifier".
Me too 🙂
March 28, 2010 at 11:13 pm
Jeff now has 20,004 forum posts! Wow.
March 28, 2010 at 10:05 pm
GilaMonster (3/28/2010)
No, I meant RID. The binary combination of File ID, Page No and Slot index is generally referred to as the Record ID, Row ID or RID.http://msdn.microsoft.com/en-us/library/ms177484.aspx
Not the best...
March 28, 2010 at 10:02 pm
Perry Whittle (3/28/2010)
Paul White NZ (3/28/2010)
It is quite likely that you will run out of tempdb, and have to wait while the entire operation rolls back.
...assuming a sort operation is...
March 28, 2010 at 8:38 pm
Good. I would encourage you to read Jacob's other articles on XML too, at some stage. They are very good, and quite comprehensive.
March 28, 2010 at 8:28 pm
Mani-584606 (3/28/2010)
815 (particularly) and 818 will both affect performance. You should remove them. See SQL Server I/O Basics for full details
I went through the document but I did not find...
March 28, 2010 at 8:27 pm
Jeffrey Williams-493691 (3/28/2010)
I don't like using a different seed date, mostly because it only works for days and I like having something that works for all.
That code seems to produce...
March 28, 2010 at 10:40 am
Viewing 15 posts - 4,726 through 4,740 (of 8,416 total)