Viewing 15 posts - 50,671 through 50,685 (of 59,078 total)
Oh no... Hugo! You're one of those folks that actually believes in the myth of code portability! :hehe:
You wrote the following in your blog...
SQL Server will happily update...
May 8, 2008 at 2:14 am
Hugo Kornelis (5/8/2008)
May 8, 2008 at 1:43 am
jose (5/8/2008)
Amazing ... you really open my eyes, what a good article.Best wishes from Peru.
Thanks, Jose. Best wishes from the "U S of A"!
May 8, 2008 at 1:32 am
Anirban Paul (5/8/2008)
We had a discussion regarding this article couple of days back in another forum. I was waiting for this article. I have no words to praise this one....
May 8, 2008 at 1:31 am
Eric Wilson (5/8/2008)
A "Tally" table (sorry Jeff) is a bad name though. It really should be just an "Integer" domain table.
Not a problem... a rose is a rose and I...
May 8, 2008 at 1:29 am
Sorry for the delay, Neil...
No, those don't look like the stats or system generated indexes I was expecting. I don't know on this one... my appologies.
May 8, 2008 at 1:11 am
john pan (5/6/2008)
no not this piece of the code, but another sample I ran a qep for has a 9.1 million row table as an input into a select...
May 8, 2008 at 1:07 am
jeff.williams3188 (5/7/2008)
HP EVA 5000
Disk Group 1 has 104 72GB/15K drives
Disk Group 2 has 24 300GB/10K drives
When I need a...
May 8, 2008 at 1:00 am
If it's truly a "file" and not just some passed parameter, I'd import it with Bulk Insert or BCP, instead. Dunno about others but I've been able to import...
May 8, 2008 at 12:53 am
Peso (5/7/2008)
Michael, what if starttime and endtime is NOT on weekend as op wrote originally?Jeff, what if starttime AND endtime is ON weekend as op wrote originally?
Dunno.... I wrote the...
May 8, 2008 at 12:47 am
Cool... thanks for the feedback, Eric. Sounds like a great CLR! Any chance of twisting your arm into posting the source code for it?
Also... what did you use...
May 8, 2008 at 12:41 am
Well, folks... I guess that's just about it for tonight. I'd also like to say thanks to...
Christopher Ford
David McKinney
humbleDBA
Cory Ellingson
Manie Verster
curbina
tbeadle
JJ B
... for...
May 8, 2008 at 12:27 am
Matt Miller (5/7/2008)
What - only 12 useful tips? in a single article?:hehe:Stop it now - you're setting the bar too high for the rest of us....
(superlative as usual).....
Ah, my ol'...
May 8, 2008 at 12:23 am
Kevin Kennedy (5/7/2008)
However... on the parameter split if parameter list happens to be exactually 8000 characters the substring in the select will fail. For example:
DECLARE @Parameter...
May 8, 2008 at 12:18 am
Eric Wilson (5/7/2008)
I used an "Integers" table for years, but starting with 2005 found that CLR functions to stream out integers is better (faster and takes virtually no space...
May 8, 2008 at 12:05 am
Viewing 15 posts - 50,671 through 50,685 (of 59,078 total)