Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,081 through 43,095 (of 59,063 total)

RE: Threw an exception... out of memory

Just check Zip 2 because there will always be all zip codes in that column.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 4:46 pm

#1020137
RE: Flakey behavior of code windows on SSC

Very cool... I'm not the only one having such problems. Thanks for posting this, Wayne. If we can get enough other people to document the problems, maybe they'll...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 1:35 pm

#1020110
RE: Threw an exception... out of memory

Never mind, Steve... I found one that's a CSV file at
http://www.boutell.com/zipcodes/
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 11:56 am

#1020095
RE: Threw an exception... out of memory

Steve, I'm not sure I can help but I'm certainly interested in this problem. Would you provide a link to the free database you mentioned so I can "play"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 11:24 am

#1020084
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

My apologies for being thick... just trying to figure this out because the propensity for deadlocks on such a table is very high, indeed.
You listed the following values for the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 11:13 am

#1020082
RE: How to store output of a Script in a .csv file in sql 2005?

Gosh... I just use good ol' BCP for this type of thing.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 10:56 am

#1020081
RE: SQL Split query

I've been bitching to Steve Jones and the others that the code windows don't work correctly with IE. One voice isn't very effective though. It would be handy...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 10:54 am

#1020080
RE: MS2005 OR MS2008?

There are a fair number of enhancements when comparing 2008 to 2005 but the basics are the same. There're things like new ways to monitor the system, new data...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 5, 2009 at 10:00 am

#1020071
RE: MS2005 OR MS2008?

I'd have to say 2008... if you're qualified in 2008, most people will consider you qualified in 2005.... but not the other way around.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 10:28 pm

#1020027
RE: The Independence Day Ruckus

Perhaps... just couldn't get past the reduction of the holiday to "To me, Independence Day is all about making a ruckus." 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 10:24 pm

#1020026
RE: moving rows

dineshbornleo (7/4/2009)
Hi Guru's
Is there any chance to move the particular rows from one table to other...?if yes..how do we do that..?
Thanx in advance..
A better question would be, why do you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 10:19 pm

#1020025
RE: SQL brian teaser...

Digs (7/4/2009)
Here is another tab split function that I pulled from a SQL 2000 book by Andrew Novick : Transact SQL UDFs
Which is better Lynns or Andrews ??? 😎
We've given...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 7:10 pm

#1020019
RE: How can i abel to see the data change in the tables

Apparently, it's not urgent since there's been no response for more than 17 hours. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 7:06 pm

#1020018
RE: Can lots of User Connections cause high CPU use

A single poorly written stored procedure, view, or UDF can bring a server to it's knees. I'd recommend running SQL Profiler and find out which one it is so...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 7:03 pm

#1020017
RE: Music for DBAs

Even if you don't put a database or SQL slant on it, it's still appropriate...
"One" by 3 Dog Night
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 4, 2009 at 6:51 pm

#1020015

Viewing 15 posts - 43,081 through 43,095 (of 59,063 total)