Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,776 through 8,790 (of 59,067 total)

Reply To: The First Rule

RonKyle wrote:
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where there...
--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)

August 21, 2019 at 1:25 pm

#3673123
Reply To: Data Migration

Phil Parkin wrote:
I'm just waiting for Jeff to chime in on this one ...
I've not done an Oracle to SQL Server migration since 2002 and that was a "one time" transfer.
Since...
--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)

August 21, 2019 at 12:54 pm

#3673099
Reply To: Export to CSV

Jenny77 wrote:
Hi,
i am trying to export a table into csv, and it should be comma delimited with doublequotes around each value like this:
"value1","value2","value3"
this works fine, but one of the columns...
--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)

August 21, 2019 at 12:30 pm

#3673078
Reply To: The First Rule

Knuth once wrote the parable of "Premature optimization is the root of all evil". That has been interpreted (actually, improperly warped) by many as leaving in place NUMERIC(18,0) for integers...
--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)

August 21, 2019 at 12:27 pm

#3673076
Reply To: A DateRange Table Valued function

Nice function, Jonathan. Well done!
--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)

August 21, 2019 at 11:50 am

#3673067
Reply To: Number of Mondays between two dates

Sergiy wrote:
Look at the progress we've got in SQL over the years!
what used to be 13 years ago a short inline formula using system functions and integer arithmetic is 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)

August 20, 2019 at 12:14 pm

#3672709
Reply To: Primary Key and Clustered Index

RonMexico wrote:
Thanks for all of the information. It was very helpful because some things I read swear by adding an identity column for the primary key regardless of what type...
--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)

August 20, 2019 at 12:06 pm

#3672708
Reply To: Give Up on Natural Primary Keys

hmbacon wrote:
OH is actually an alfa surrogate for Ohio.
Not by definition. Part of the definition of a surrogate key is that you should be able to derive NO information by...
--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)

August 20, 2019 at 6:59 am

#3672626
Reply To: Give Up on Natural Primary Keys

nova wrote:
Don't get distracted by the arbitrary idea that one key or other has to be primary key. In practical terms it doesn't matter which of the keys in 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)

August 20, 2019 at 6:56 am

#3672625
Reply To: Are the posted questions getting worse?

BWWWAAAAA-HAAAAAA-HAAAAA-HAAAA!!!! HOOOOIIIEEEE! Man, I laughed 'til my sides hurt.
Like many of you, I get a lot of notifications from various groups I've signed up for. Here's a snippet of one...
--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)

August 20, 2019 at 1:19 am

#3672548
Reply To: Query Taking Exponentially Longer to Complete

awalton wrote:
Upon a quick google I think I should be looking for a Tasks entry on the right click menu, however I don't see that as an option when 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)

August 20, 2019 at 12:47 am

#3672541
Reply To: Query Taking Exponentially Longer to Complete

Jonathan AC Roberts wrote:
Jeff Moden wrote:
awalton wrote:
And here is the DDL (I think)
With one exception, all of the VARCHAR columns in that table are VARCHAR(MAX), which is a LOB datatype. That's the first...
--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)

August 20, 2019 at 12:38 am

#3672539
Reply To: Wait_type null

gana79950 wrote:
Thanks Jeff,
How did you convert 4 million reads to 31 GB of IO ?
Sue_H wrote:
A logical read is an 8K page. Divide the reads by 128 to get 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)

August 20, 2019 at 12:17 am

#3672533
Reply To: Query Taking Exponentially Longer to Complete

awalton wrote:
Jeff, which ones are VARCHAR(MAX)? Are those the fields with length -1?
Yes. You can verify that by right clicking on the table in the Explorer window of SSMS and...
--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)

August 20, 2019 at 12:12 am

#3672531
Reply To: Primary Key and Clustered Index

I totally agree with Scott on this one... the IDENTITY column is not needed, occupies space on each page (which is also reflected in memory and disk), and is 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)

August 19, 2019 at 11:07 pm

#3672516

Viewing 15 posts - 8,776 through 8,790 (of 59,067 total)