Viewing 15 posts - 55,756 through 55,770 (of 59,078 total)
Vijaya,
Since you're brand new, lemme just tell you that posting data in the following manner is much more helpful to those that would help you... tell's us almost everything we...
July 17, 2007 at 9:55 pm
Just from the practical point for ease of troubleshooting, here's from our "standards" book at work...
All column names shall be prefixed with a table alias in the presence of joins...
July 17, 2007 at 9:18 pm
Phill is spot on. I'll kick in that BCP has some additional features that make it a bit slower than Bulk Insert (but still faster than DTS) including error logging...
July 17, 2007 at 9:09 pm
It's not often that I see a query improve performance by applying Index Hints. Usually, it's the other way around... When you say you are seeing some impressive improvements in...
July 17, 2007 at 6:07 pm
Lookup sp_Rename in Books Online... that'll do what you need...
July 17, 2007 at 5:58 pm
... and, that's just the date... doesn't include time...
But, Serqiy is correct... there's a date format that's based on the number of seconds since the 01/01/1970. There are other "numeric" date...
July 17, 2007 at 5:53 pm
SELECT CAST(CONVERT(CHAR(8),somedate,112) AS INT)
...but it's an insane thing to do for so many reasons...
July 17, 2007 at 5:52 pm
Almost forgot to ask... I know you said you can't normalize the table (would be the greatest space saver of them all here) so I won't bug you about that... but...
July 17, 2007 at 5:46 pm
Using LTRIM(RTRIM()) will not make NULLs... that may be a part of the problem... here's the proof...
DECLARE @NullOrBlank VARCHAR(8000)
SELECT @NullOrBlank = REPLICATE(' ',100)
SELECT DATALENGTH(@NullOrBlank) AS DataLengthBefore,
...
July 17, 2007 at 5:44 pm
It wouldn't be a "sum"... it would still be a COUNT except it wouldn't be DISTINCT. And, because you are not counting DISTINCT LID's, you already have the sum of...
July 17, 2007 at 5:30 pm
Michael,
Why don't you write an article here on SQLServerCentral about you number and date range generator functions? I've always been really impressed with the speed of the darned things...
July 17, 2007 at 5:22 pm
Oh, yeah... if you want the actual "Region ID", you'll need to get Telcordia's "NNACL"... but I think that's only for the US and Canada. Prepare to pay some $$...
July 17, 2007 at 3:41 pm
I'll second that on LincMad... been using his stuff for years and is one of the best places to find this type of free info.
If you need something to pay...
July 17, 2007 at 3:38 pm
Heh... also hacked one for Peter's method... slowed it down just a bit but it's still faster than the traditional method...
--===== Peter's method of generating random numbers from...
July 17, 2007 at 3:26 pm
Hacked a fix for the zero distribution problem on the traditional method...
--===== Traditional method of generating random numbers from -5 to +5
SELECT SUM(CASE WHEN r = -5...
July 17, 2007 at 3:16 pm
Viewing 15 posts - 55,756 through 55,770 (of 59,078 total)