Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,901 through 39,915 (of 59,072 total)

RE: Patern Matching

UT,
It's been a couple of days... how'd all that work out for 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)

February 5, 2010 at 6:05 pm

#1114874
RE: Local Temporary Tables and Table Variables

True enough. You should also mention that most UDFs aren't necessary either. 🙂
--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)

February 5, 2010 at 6:03 pm

#1114873
RE: HUGE Database Update (> 550 million rows)

Brian.Dunat (1/23/2010)
Jeff,
This is the proper clustered index and it makes up the primary key on the table. This is a wealth management database, so the data that will be inserted...
--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)

February 5, 2010 at 5:52 pm

#1114872
RE: how to Split DateTime value in seprate date and time column

dan.hare (7/30/2009)
I didn't explain myself well enough, apologies.
Of course you can choose to report a date/time to whatever level of granularity you want.
Dead easy.
My point was that if you choose...
--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)

February 5, 2010 at 5:40 pm

#1114871
RE: How to query on acedemic years?

mcommmgr (2/1/2010)
Working on it!
BUSINESS @ THE SPEED OF THOUGHT
J. Joshi
Harvard University Medical Informatics
Cambridge, USA.
BWAA-HAA!!! Now there's a bit of irony in that post! 😀
--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)

February 5, 2010 at 5:30 pm

#1114868
RE: How to display a columns current row and next row value in single select query?

nareshmca (1/20/2010)
Thanks for your reply. Sorry for the confusion.
First i have to tell one thing, sol_sub_cat_Id is a PK column, sol_cat_id is a FK column. I am looking for an...
--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)

February 5, 2010 at 5:25 pm

#1114866
RE: How to display a columns current row and next row value in single select query?

arr.nagaraj (1/20/2010)
@jeff,
His sample result has 19,20 and after that 8,9. So I guessed he felt he needs it in the order in which Database stores ( or unordered scan resultorder...
--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)

February 5, 2010 at 5:21 pm

#1114865
RE: Extract X and Y coordinates out of a string and check if within range

Charlotte,
It's been a couple of days and I'm just being curious... how did all of this work out for 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)

February 5, 2010 at 5:08 pm

#1114862
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

Sorry for the late reply. Thanks for the explanation, Dan. I really appreciate 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)

February 5, 2010 at 5:00 pm

#1114860
RE: Column With Multiple Values

WayneS (2/4/2010)
@jeff - thinking outside the box again...:smooooth:
BaldingLoopMan (2/4/2010)
very nice. i wouldn't have thought about using the parse name. nice work.
Heh... thanks guys. But I prefer to think 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)

February 5, 2010 at 4:58 pm

#1114859
RE: Bulk Insert Q

Ah... thanks for the reminder, Adi. I flat forgot about 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)

February 5, 2010 at 4:50 pm

#1114856
RE: BULK INSERT eliminating quotes

Almost forgot... I believe that setting up a "Text" linked server may do the
trick, as well. However, both OPENROWSET and a Text Linked Server will be
a bit slower than...
--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)

February 5, 2010 at 4:42 pm

#1114852
RE: BULK INSERT eliminating quotes

I agree... it's a huge pain. I think they made it that way to get folks to use SSIS. 😉
As a side bar, there is another way but 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)

February 5, 2010 at 4:38 pm

#1114850
RE: backup selected month from database

To use flat files you would also need complete and up to date documentation of all relationships used within the tables.
Nope... that should all be in the code 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)

February 5, 2010 at 4:30 pm

#1114846
RE: BCP utility

Admittedly, I've not look at the license recently but it used to say something about having to install the entire client and not just parts. So I suspect 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)

February 5, 2010 at 4:20 pm

#1114842

Viewing 15 posts - 39,901 through 39,915 (of 59,072 total)