Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,776 through 38,790 (of 59,098 total)

RE: Are the posted questions getting worse?

Roy Ernest (4/23/2010)
Paul White NZ (4/22/2010)
Adam Machanic (4/22/2010)
I'm convinced that it's a cultural thing. Apparently in Indian culture it's okay to copy someone else's work.
I have heard this before too....
--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)

April 23, 2010 at 1:24 pm

#1157111
RE: MCJ - The Missing Link

Lynn Pettis (4/23/2010)
CirquedeSQLeil (4/23/2010)
Lynn Pettis (4/23/2010)
After catching some interesting posts on the water cooler, I think I have another reason to revoke the certification -- plagiarism. I don't think...
--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)

April 23, 2010 at 1:00 pm

#1157103
RE: Using OPENROWSET to import CSV files

Wow... sorry about that, folks. I really lost track of this post.
Simon, after only 5 months of delay :blush:, do you still need any help on 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)

April 23, 2010 at 12:58 pm

#1157102
RE: Substring Function in Where Clause

eseosaoregie (4/23/2010)
Hi Jeff,
Just ran this at work on some of the data and it the first CTE failed because it could convert the string type to datetime.
After running some queries...
--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)

April 23, 2010 at 12:55 pm

#1157098
RE: Centrally located stored procs?

Steve Jones - Editor (4/22/2010)
Hey! someone agrees with me 🙂
Replication can work well for you. Consider that.
Heh... I almost always agree with you... I just hate to admit 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)

April 23, 2010 at 9:16 am

#1156946
RE: When not to use a temporary table?

Dan.Humphries (4/22/2010)
I see what you are saying but surely a select of 20 Mil rows from a properly indexed table is not the same as writing 20 million rows 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)

April 23, 2010 at 9:14 am

#1156945
RE: Substring Function in Where Clause

Let's try this again...
Here's the test harness I used... make sure you read the comments because it builds 17 million test rows in something less than 10 minutes...
-- WARNING... USE...
--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)

April 22, 2010 at 8:35 pm

#1156555
RE: Substring Function in Where Clause

{edit} Just noticed a boo-boo... had to take the code I posted down. I'll be back soon.
--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)

April 22, 2010 at 8:07 pm

#1156548
RE: Sum of column instead of row

Seems to me that a simple UPDATE with a join would do the trick and that's covered extensively in Books Online.
--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)

April 22, 2010 at 3:28 pm

#1156481
RE: OPENROWSET Query limit

I don't believe there's a limit on OPENROWSET. More likely, there's some error in the data especially if the data is actually coming from a file.
--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)

April 22, 2010 at 3:25 pm

#1156478
RE: What Do We Want?

Terry Mott (4/22/2010)
One more:
A built-in date truncation function to strip the time portion from a datetime value.
I guess this is not so big an issue anymore, as you can now...
--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)

April 22, 2010 at 3:20 pm

#1156470
RE: When not to use a temporary table?

Here's an example of why I say it's not the 20 million rows nor TempDB that's the problem. The following code generates 20 million orws of ID's just 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)

April 22, 2010 at 3:12 pm

#1156464
RE: When not to use a temporary table?

Dan.Humphries (4/22/2010)
With all respect
How would writing 20 Million rows to a temp table not be part of the problem even with the for-mentioned query problems. I would be very surprised...
--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)

April 22, 2010 at 2:41 pm

#1156437
RE: TempDB data file & Log file size

A couple of other folks and I recently discovered a possible problem with the IDENTITY function when used with SELECT/INTO in the form of explosive log file growth even 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)

April 22, 2010 at 2:15 pm

#1156424
RE: What Do We Want?

I wish they'd actually stop listening to most customers. Asking for things like enhancements to cursors just don't make sense to me. If they made things like PIVOT...
--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)

April 22, 2010 at 2:03 pm

#1156419

Viewing 15 posts - 38,776 through 38,790 (of 59,098 total)