Viewing 15 posts - 55,366 through 55,380 (of 59,078 total)
I wouldn't be surprised if it was a Java or C# batch job running at that time
SQL Scheduled Jobs aren't the only show...
August 14, 2007 at 10:51 pm
Thanks for the awesome compliment, Kenny... and thanks for the patch to the code!
August 14, 2007 at 6:58 pm
| I really don't care how bad the query was or care about optimizing it. All I wanted... |
August 14, 2007 at 6:30 pm
Yeah... Sorry about that... was thinking about something different and didn't double check. ![]()
August 14, 2007 at 6:16 pm
Whatever... I've been working with SQL Server for 12 years and I've never had to write a cursor. Yeah, sometimes the occasional While loop in a function (have even gotten...
August 14, 2007 at 6:09 pm
Thanks, Edward. Take a look at the above, if you want.
August 14, 2007 at 5:58 pm
For those that want to play...
--================================================================================================ -- Generate an 8 million row test file. This is NOT part of the solution. It is...
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 ![]()
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...
August 14, 2007 at 8:18 am
You didn't answer my other question... are the dashes supposed to be delimiters?
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...
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...
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.
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
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...
August 13, 2007 at 9:13 pm
Viewing 15 posts - 55,366 through 55,380 (of 59,078 total)