Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,806 through 8,820 (of 59,091 total)

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
Reply To: Query Taking Exponentially Longer to Complete

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 thing 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)

August 19, 2019 at 10:32 pm

#3672509
Reply To: Wait_type null

It means it's not waiting on anything. Since you're doing more than 4 million reads (more than 31GB of I/O), you likely have some performance challenged code that needs 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)

August 19, 2019 at 3:09 am

#3672167
Reply To: Best Work from Home training najafgarh

Heh... wait for 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)

August 17, 2019 at 8:32 pm

#3672090
Reply To: Query Taking Exponentially Longer to Complete

What's in the data you're returning? Any LOBS?
--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 17, 2019 at 4:46 am

#3671994
Reply To: Why would an indexed column could take 5 seconds to apply a where clause?

There's something wrong with the index on the persisted column or the persisted column itself. It should be as fast as the permanent column you just added. Perhaps the statistics...
--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 16, 2019 at 5:49 pm

#3671924
Reply To: The Sequel to SQL

nova wrote:
Jeff Moden wrote:
All the innovative data management software in recent times comes from Amazon, Cloudera, open source and numerous disruptive startups who have made advances that have left 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 15, 2019 at 3:46 pm

#3671594

Viewing 15 posts - 8,806 through 8,820 (of 59,091 total)