Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,646 through 45,660 (of 59,095 total)

RE: How to get all columns with empty value in table

Lowell (1/22/2009)
wait, i think i get it....still use a loop or FOR XML to construct the complete set of statements, and run the massive varchar(max) as a batch, instead of...
--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)

January 22, 2009 at 11:44 pm

#931646
RE: Slack SQL Server

Heh... ya just hit a sweet spot, Steve...
Proper windowing functions that you can do proper aggregations like SUM(xxx) OVER() with so running totals and the like are a bit...
--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)

January 22, 2009 at 10:50 pm

#931638
RE: The better server

Share with us why you want to know, please. And what do you define as "better"?
--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)

January 22, 2009 at 9:47 pm

#931628
RE: Offset in the date-time inserted while insertion

To quote a good friend of mine... "A Developer must not guess... a Developer must KNOW." Be sure and take a look. 😉
--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)

January 22, 2009 at 9:44 pm

#931627
RE: How to get all columns with empty value in table

I agree that dynamic SQL is the way to go here. You could concatenate the same dynamic SQL you have in your cursor using the ol' SELECT @sql =...
--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)

January 22, 2009 at 9:43 pm

#931626
RE: Zip Code Lookups

GSquared (1/22/2009)
Zip-code prefixes are state-specific. Can't span states. Lots of them span counties, but they don't span states. Even cities that span state-lines, have different Zip codes...
--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)

January 22, 2009 at 9:33 pm

#931623
RE: Timeouts on Update Statements

SELECT usually uses some form of shared lock unless it's in an explicit transaction along with one of the other statements. Inserts and Updates use anything from a rowlock...
--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)

January 22, 2009 at 9:25 pm

#931621
RE: How to get all columns with empty value in table

Using a cursor in 2k5 when VARCHAR(MAX) is available? Lowell? :hehe:
--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)

January 22, 2009 at 9:17 pm

#931619
RE: Offset in the date-time inserted while insertion

Is there, by any chance, a trigger on the table that trys to "normalize" time zones?
--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)

January 22, 2009 at 9:15 pm

#931618
RE: insert using cursor or store proc

The other part of the problem is the concatenations and the formulas on columns. No chance of an index being used for anything practical there.
Also, you're inserting into 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)

January 22, 2009 at 9:10 pm

#931616
RE: Need assistance avoiding rbar

Heh... you've just gotta know that any post with "RBAR" in the title is going to catch my eye. Thought I'd stop by and see what's up. Looks...
--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)

January 22, 2009 at 9:03 pm

#931612
RE: Open Source Pay

mtucker (1/22/2009)
If someone sees that you are doing a lot more work than them for the same salary they have a very good incentive to work harder. They would not...
--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)

January 22, 2009 at 8:44 pm

#931611
RE: Why do people need to do this?

Yep... I do the same thing... except I've been solving the problem and then asking for a bit of feedback. Of course, once the cat's out of the bag,...
--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)

January 22, 2009 at 8:11 pm

#931598
RE: Open Source Pay

mtucker (1/22/2009)
Jeff Moden (1/22/2009)
How are my fellow employees going to make better decisions if they know what I make?
better decisions with regard to their salary and conditions...should i ask for...
--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)

January 22, 2009 at 8:01 pm

#931592
RE: backup failure

I'm thinking it was a coincidence... not sure though... looks like one of those times when you "had to be there" to figure it out. I've never seen that...
--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)

January 22, 2009 at 7:35 pm

#931585

Viewing 15 posts - 45,646 through 45,660 (of 59,095 total)