Viewing 15 posts - 55,366 through 55,380 (of 59,072 total)
For those that want to play...
--================================================================================================ -- Generate an 8 million row test file. This is NOT part of the solution. It is...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 5:57 pm
Heh... I once had a friend that tried to make bottles from broken glass. That didn't work out so well, either ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 8:26 am
Thanks for the feedback, Lowell ![]()
One more thing... you said the article explains how to save each "field" as SMALLINT. Even that is...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 8:18 am
You didn't answer my other question... are the dashes supposed to be delimiters?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 7:57 am
Heh... some of the best (and worst) ideas are spawned on cocktail napkins... this one happens to be one of the worst... if you run it more than once, it...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 7:46 am
I only had the chance to work with 2k5 once, so far, but I did notice other strange (different) default settings... for example, "Concatenate Null Yields Null" was turned off...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 14, 2007 at 7:37 am
The object of the FROM clause may not be a variable. You'll need to use dynamic SQL to do this.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 10:45 pm
You sure it was 2,147,483,647 MB? That's two billion mega bytes... no wonder the server was having a hard time swallowing that ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 9:39 pm
East Indian, American, or other, I'd really like to see 3rd party vendors adopt the strategy of doing things right. Not just software, either... call centers of all sorts should...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 9:13 pm
With the PARSENAME function, there's no need even for that. PARSENAME (see Books Online) was developed almost soley for the purpose of interogating IP Addresses provided that the dots are...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 9:04 pm
Since I can't even spell "Matrix Control", I kinda figured someone else would take a shot at it
I'm definitely NOT a GUI...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 7:01 pm
Heh... just seeing if you're awake, David ![]()
Ah... old habits are hard to break ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 6:50 pm
No explanation except for maybe parallelism, different stats, different number of processors, different section of harddisk, different memory, etc, etc.
It's just not a good idea to update a view...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 6:42 pm
| My boss already rewrote the query to pull one day at a time and it runs in under... |
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 6:37 pm
That's cool... Thanks Micheal...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 13, 2007 at 6:31 pm
Viewing 15 posts - 55,366 through 55,380 (of 59,072 total)