Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,311 through 41,325 (of 59,069 total)

RE: Data like Crosstab

Hmmmm... CSV format... that's NOT a cross-tab. That's concatenation. Here's another article link. This one shows a couple of methods of concatenation and some of the associated...
--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)

October 28, 2009 at 11:00 pm

#1072238
RE: Are the posted questions getting worse?

Roy Ernest (10/28/2009)
I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly on 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)

October 28, 2009 at 10:46 pm

#1072235
RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

BWAA-HAAA... I didn't read the quote in your response, Tim... I just read your response and thought you misunderstood me. It's funny how all that worked out. Me?...
--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)

October 28, 2009 at 10:35 pm

#1072233
RE: Would you be concerned??

It was a joke, Elliot... no one in their right mind would waste perfectly good gravy base on such a task. 😉
--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)

October 28, 2009 at 9:23 pm

#1072216
RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

Heh... sorry, Tim... my post was meant to be a wee bit ironic (ok... I really mean sarcastic to the max :-D). 😉 There are so many companies with...
--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)

October 28, 2009 at 9:18 pm

#1072213
RE: Advice of Optimization Techniques for Mass Replace Command on a 1 million+ record DB.

huston.dunlap (10/28/2009)
Jeff Moden (10/28/2009)
I'll do all the updates in an extra column that I form while doing a high speed SELECT/INTO. Then, it's a very simple update...
--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)

October 28, 2009 at 9:09 pm

#1072210
RE: Merging Values in a temporary table

There are a couple of concatenation methods (what you need to do this) along with some things to avoid in the following article...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

October 28, 2009 at 9:06 pm

#1072206
RE: How to RTRIM a Text type field longer then 8000

Henk Schreij (10/28/2009)
@lowell & garadin
The combination of your tips did the trick. 🙂
Problem solved.
Thank you. 😎
Cool... can you post the code that you ended up with? Thanks.
--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)

October 28, 2009 at 9:03 pm

#1072202
RE: Recursive Queries

martin.edward (10/27/2009)
Hello,
I am in the process of creating a recursive query, but have no idea on the basics i.e. recursion,looping through sql statements etc.
Could some give me a drill down...
--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)

October 28, 2009 at 9:00 pm

#1072200
RE: Table valued function with cursor

mikesmithee (10/28/2009)
I am trying to create a generic table valued function which returns all child IDs for a specified parent of any self join table.
The function is passed the table...
--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)

October 28, 2009 at 8:52 pm

#1072198
RE: Openrowset to select and Insert Millions of records

Ok, I'll be honest, as well. If I could avoid SSIS, I would. A simple BULK INSERT (possibly using a BCP "Format File") will blow the doors off...
--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)

October 28, 2009 at 8:45 pm

#1072197
RE: Advice of Optimization Techniques for Mass Replace Command on a 1 million+ record DB.

Yes... sometimes you can get yourself into some pretty deep Kimchi if you update what you are using as a criteria. In these types of situations, I'll also bring...
--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)

October 28, 2009 at 8:42 pm

#1072196
RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

Heh... if the infrastructure is setup correctly, the correct answer is.... none.... the servers will take care of themselves and on the rare occasion that they can't, they'll call someone...
--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)

October 28, 2009 at 8:28 pm

#1072189
RE: 4 table join - easy one for you guys

"It Depends". Which table has ALL Loan_ID's and what do you want to actually return? There may be the need for an "OUTER" join in there but, like...
--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)

October 28, 2009 at 8:09 pm

#1072186
RE: Providing 2 numbers as hour numbers and third input number as minute and getting result in third number's difference from start hour to end hour

slange-862761 (10/28/2009)
This sounds a lot like a school project. Why in the world would you need something like this otherwise? That being what it is this was a fun challenge!!
Here...
--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)

October 28, 2009 at 8:02 pm

#1072185

Viewing 15 posts - 41,311 through 41,325 (of 59,069 total)