Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,281 through 35,295 (of 59,099 total)

RE: Formatting Dates with 3 Character Months (SQL Spackle)

UMG Developer (1/21/2011)
Thanks for another great piece of spackle!
Thanks, UMG. Like I've been telling folks, take a look at some of the posts on this thread concerning international short...
--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, 2011 at 3:02 pm

#1276930
RE: Formatting Dates with 3 Character Months (SQL Spackle)

ColdCoffee (1/20/2011)
Hey Jeff, thanks for article.. well written and full of information! Thanks a bunch! 🙂
Thanks for stopping by, CC. Make sure you read some of the discussions on...
--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, 2011 at 3:00 pm

#1276928
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Anirban Paul (1/20/2011)
I nowadays do the original conversion like a mechnical machine. Just type those 10-15 lines to convert the date. Thanks Jeff I will now switch over to Datename....
--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, 2011 at 2:59 pm

#1276927
RE: How to make Net Meeting a success

Good to know about the firewall thingy. I hadn't thought about that.
Roy... I really enjoyed the "meeting" with you and your good folks. It was a first 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, 2011 at 10:36 am

#1276911
RE: An Introduction to Database Design

kenambrose (1/22/2011)
Hi Paul,
What I try to do when I train beginners in DB work is to emphasize Codd's fundamental logical concepts- in layman's language.
I start out...
--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, 2011 at 10:29 am

#1276910
RE: Filter a table to get unique rows in a certain logic

@ColdCoffee,
It's not just unique values the OP is trying to find. If it was, the OP probably would have been able to do it himself.
The goal is to find...
--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, 2011 at 9:56 am

#1276906
RE: Creating a comma-separated list (SQL Spackle)

WayneS (1/21/2011)
(oh yeah... you really need to update that 9-yr old computer you have!!!)
Heh... nah... two reasons. 1) If I can make something run fast on my machine, it...
--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, 2011 at 9:28 am

#1276903
RE: Creating a comma-separated list (SQL Spackle)

WayneS (1/21/2011)
With your test data, on my 2yr old dual core Intel P-8600 @ 2.40GHz, 8GB RAM, Vista Ultimate 64-bit SP2, SQL 2008 64-bit SP2 (phew!):
(oh yeah... you really need...
--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, 2011 at 7:11 am

#1276893
RE: Creating a comma-separated list (SQL Spackle)

Ok... here's the test data generator that I borrowed from Wayne's article. I set it up for 10 times more rows and 10 times more accounts for a million...
--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 21, 2011 at 8:47 pm

#1276860
RE: Creating a comma-separated list (SQL Spackle)

WayneS (1/12/2011)
WayneS (1/12/2011)
Mark-101232 (1/12/2011)
Changing
value('.','varchar(max)'),1,1,'')
to
value('(./text())[1]','varchar(max)'),1,1,'')
appears to give a better query plan
Thanks for the information... I'll have to test this out.
Edit: WOW! What a...
--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 21, 2011 at 8:09 pm

#1276859
RE: Formatting Dates with 3 Character Months (SQL Spackle)

David McKinney (1/21/2011)
Jeff,
I'm waiting for you to blow us away with your tally table solution to pull the correct month from the comma separated field in sys.syslanguages.
Or will I...
--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 21, 2011 at 4:24 pm

#1276848
RE: Where do you look for DBA's?

The absolute best job description I ever saw was a single sentence as follows:
"Basically what we need is someone who can look at SQL, tell what's wrong, and fix it".
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 21, 2011 at 4:21 pm

#1276846
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Very cool, Peter! Thanks for the coding, the testing, and the hypothesis! I'll do some additional testing over the weekend.
--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 21, 2011 at 8:14 am

#1276582
RE: Filter a table to get unique rows in a certain logic

I've not been able to dedicate much more time thinking about this than I originally did. Did you ever get this problem figured out?
--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 20, 2011 at 8:17 pm

#1276350
RE: SSIS task causes tempdb to grow uncontrolled

romanoplescia (1/19/2011)
Happy days 😀 Problem's been solved.... Tracked it down to a developer in Australia who had added a new column to a select query in the sp. However this...
--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 20, 2011 at 8:10 pm

#1276349

Viewing 15 posts - 35,281 through 35,295 (of 59,099 total)