Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,821 through 11,835 (of 59,102 total)

RE: The GDPR is Coming to the US

David.Poole - Tuesday, July 17, 2018 11:57 AM
Jeff Moden - Tuesday, July 17, 2018 6:44 AM
--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)

July 17, 2018 at 12:46 pm

#1997893
RE: The GDPR is Coming to the US

Jason A. Long - Tuesday, July 17, 2018 12:20 PM
I like to have some fun with them...
#1... I give them 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)

July 17, 2018 at 12:39 pm

#1997890
RE: How to improve Delete Performance

Better yet.... stop doing the deletes and learn how to do a proper "UPSERT" on a properly clustered/index table! Do you really think that many rows from the previous month...
--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)

July 17, 2018 at 12:32 pm

#1997888
RE: dm_db_index_usage_stats not accurately reflecting index usage

Lynn Pettis - Tuesday, July 17, 2018 9:43 AM
Jeff Moden - Tuesday, July 17, 2018 8:59 AM
--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)

July 17, 2018 at 11:47 am

#1997878
RE: The GDPR is Coming to the US

Jason A. Long - Tuesday, July 17, 2018 10:51 AM
Jeff Moden - Tuesday, July 17, 2018 8:18...
--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)

July 17, 2018 at 11:45 am

#1997877
RE: Who Likes NULL?

Lynn Pettis - Tuesday, July 17, 2018 10:30 AM
I hope you weren't thinking that I actually was advocating for 6th normal...
--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)

July 17, 2018 at 11:40 am

#1997876
RE: Finding a particular date in all tables

I agree that you have a developed a fine tool. I was just wondering if you knew of anyone else that would use it to find a specific date in...
--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)

July 17, 2018 at 9:27 am

#1997848
RE: How to improve Delete Performance

quinn.jay - Monday, July 16, 2018 9:29 AM
I have an SSIS pkg, where I have three tables to load, with 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)

July 17, 2018 at 9:23 am

#1997847
RE: Cluster on partitioned table

My understanding of partitioned tables may leave something to be desired but my understanding of it all is that any UNIQUE index that is also ALIGNED with the partitioned will...
--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)

July 17, 2018 at 9:18 am

#1997846
RE: dm_db_index_usage_stats not accurately reflecting index usage

Hmmm... I wonder if it's simply because when you create an index, it also creates a new set of stats that go with it, which CAN be used by 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)

July 17, 2018 at 8:59 am

#1997838
RE: Cluster on partitioned table

Are there any other tables that point to this table using "field 1" as a Foreign Key?
--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)

July 17, 2018 at 8:48 am

#1997832
RE: The GDPR is Coming to the US

As a fun bit of contrast, which also seems to be correct... i.e. "Free with advertising"...
https://www.techdirt.com/articles/20121219/18272921446/stop-saying-if-youre-not-paying-youre-product.shtml
--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)

July 17, 2018 at 8:18 am

#1997828
RE: The GDPR is Coming to the US

Jason A. Long - Tuesday, July 17, 2018 8:05 AM
jasona.work - Tuesday, July 17, 2018 7:46 AM
--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)

July 17, 2018 at 8:10 am

#1997824
RE: The GDPR is Coming to the US

jasona.work - Tuesday, July 17, 2018 7:46 AM
Reading through this topic, it's interesting to see the viewpoints...
Leaving aside the fact that GDPR,...
--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)

July 17, 2018 at 8:08 am

#1997822
RE: how can i get the top 3, after i count the column ?

Luis Cazares - Tuesday, July 17, 2018 6:19 AM
Jeff Moden - Tuesday, July 17, 2018 6:12 AM
--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)

July 17, 2018 at 6:47 am

#1997804

Viewing 15 posts - 11,821 through 11,835 (of 59,102 total)