Viewing 15 posts - 52,876 through 52,890 (of 59,070 total)
jldsql (1/16/2008)
Microsoft documentation suggest that both derived tables and temporary table will first use memory cache if available.Jim
Jim... First, I absolutely agree with what you said... But, I also...
January 16, 2008 at 7:24 am
Shaun McGuile (1/16/2008)
Sorry - had not read all of the posts before posting!:rolleyes:--Shaun
Heh! Man, I had to laugh out loud! I've done that many times myself... it's normally...
January 16, 2008 at 7:15 am
Paul Bakker (1/16/2008)
Does anyone have experience with the freeware version of SqlSafe? Can this product safely used in a production enviroment?
Heh... freeware...
My recommendation is that you read the license...
January 16, 2008 at 7:12 am
Samuel Vella (1/16/2008)
(Did you miss my earlier posts?)
Case would be a lot easier for very simple examples but sometimes @nbr is derived and for clarity/optimization it would be better to...
January 16, 2008 at 6:58 am
Hey Prashant...
You remember I said "don't let it dampen your writing spirit"? Here's why... like I said, you have some good information in your article and people have already...
January 16, 2008 at 6:43 am
...and everything happens in memory instead of a combination of memory and disk.
...while a temporary table exists until the server is brought down and also it uses lot of disk...
January 16, 2008 at 12:44 am
You bet, Jeremy... thanks for the feedback. Just remember... if you have lots of data, BCP with a format file will absolutely scream compared to this concatenation method.
January 16, 2008 at 12:27 am
Crud... guess I need to start another rant! This forum won't allow me to post a "backslash-n" even in the code window. Line 188 of the BCP format...
January 16, 2008 at 12:16 am
Well.... I should have known better... as soon as I saw that it was a Government agency, I should have known that the record layout they provided wasn't going to...
January 16, 2008 at 12:08 am
David.Poole (1/15/2008)
LICH (1/15/2008)
Also "Analyser" should be "Analyzer"
Not if you're British it shouldn't.
Well, at least not until we've had a couple of "P's & Q's" 😀 Got beer? :w00t:
January 15, 2008 at 7:12 pm
Of course... but I guess I'd rather keep it professional (or at least try to salvage some semblance of professionalism on my part after my initial outburst) by not citing...
January 15, 2008 at 7:05 pm
That would be the one... they're pretty smart making it a new datatype... will actually keep 23:59:59.997 code from breaking... unless it's used on the wrong column type.
January 15, 2008 at 5:57 pm
Heh... glad someone occasionally gets a laugh out of those... 😛
More on the serious side... the "Bat with a nail in it" is actually a metaphore for what I do...
I'll...
January 15, 2008 at 5:24 pm
Right idea but no need for the loop...
SELECT CAST(varchara AS CHAR(10))
+ CAST(varcharb AS CHAR(255))
+ CAST(varcharc AS CHAR(50))
...
January 15, 2008 at 4:58 pm
GSquared (1/15/2008)
January 15, 2008 at 4:45 pm
Viewing 15 posts - 52,876 through 52,890 (of 59,070 total)