Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,256 through 39,270 (of 59,098 total)

RE: SQL DateTimeOverflow

Insert the data into a staging table with all VARCHAR() columns. Use ISDATE and couple of other checks on the date columns to validate the date BEFORE you try...
--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)

March 19, 2010 at 8:00 am

#1136733
RE: Representing a hierarchy from comma separated values

Did that help or what?
--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)

March 19, 2010 at 7:53 am

#1136725
RE: Calculate columns by adding the result of other coulmns on the fly

Divide'n'Conquer. Gather the data first, then manipulate it. It's a form of "pre-aggregation" and it can make for some very fast code because it can reduce the number...
--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)

March 19, 2010 at 7:51 am

#1136723
RE: Finding Training

One of the problems I've found that people face in getting some paid training is their own salary and position. Lots of salaried folks are underpaid especially if 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)

March 19, 2010 at 7:38 am

#1136710
RE: deletion of 2 million records

WayneS (3/18/2010)
sandip.vs (3/18/2010)
I want to delete 2 million records from my table(based upon a condition)....what is the easiest way to do???
Assuming that you read Stefan's post, and you need to...
--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)

March 19, 2010 at 7:20 am

#1136696
RE: Are the posted questions getting worse?

GSquared (3/18/2010)
john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?
Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, ...
--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)

March 18, 2010 at 8:52 pm

#1136419
RE: An Urgent Ad Hoc Report

Yakov,
If you weren't being sarcastic, I truly apologize for me taking it the wrong way. I do have to stand my ground on the issue, though, and I do...
--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)

March 18, 2010 at 7:57 pm

#1136412
RE: An Urgent Ad Hoc Report

Tim Walker. (3/18/2010)
Jeff, that is such an important point that it's a shame its buried here in response to the article posted here. It really warrants an article in its...
--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)

March 18, 2010 at 7:50 pm

#1136410
RE: An Urgent Ad Hoc Report

GOC-481399 (3/18/2010)
I honestly didn't think he was being sarcastic.
You could be right. I may have taken it all wrong because of the sensitive subject matter and the fact 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)

March 18, 2010 at 7:42 pm

#1136408
RE: An Urgent Ad Hoc Report

Yakov Shlafman (3/18/2010)
SSChampion, why we do not question the fact that in production environment
we have garbage - garbage database design, garbage data, garbage applications that produce garbage results.
Before 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)

March 18, 2010 at 7:26 pm

#1136404
RE: Adding a field to an aggregate query

There is nothing in the original data provided to guarantee the order of the rows... until there is, all of the methods offered so far (as well written as they...
--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)

March 18, 2010 at 4:49 pm

#1136376
RE: TempDB doing my nut in

Mr J (3/17/2010)
Hi Jeff,
It's hard to say just how big it wants to get, because it always runs out of HD, but i can tell you it gobbles up 40...
--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)

March 18, 2010 at 4:37 pm

#1136369
RE: Are the posted questions getting worse?

David Burrows (3/18/2010)
BWAAAHAAA....
TWANG......
Hmmmmm... the possible makings of new T-Shirt.:-P
--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)

March 18, 2010 at 3:30 pm

#1136348
RE: TSQL using parameters does not use the index

BWAA-HAAA!!! "It depends". 😉
--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)

March 18, 2010 at 2:15 pm

#1136303
RE: Are the posted questions getting worse?

john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?
Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could...
--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)

March 18, 2010 at 2:03 pm

#1136287

Viewing 15 posts - 39,256 through 39,270 (of 59,098 total)