Jeff Moden

Forum Replies Created

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

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
RE: The GDPR is Coming to the US

David.Poole - Tuesday, July 17, 2018 1:33 AM
I've read through the GDPR several times. From the perspective of a data person 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)

July 17, 2018 at 6:44 am

#1997803
RE: Finding a particular date in all tables

ben.brugman - Tuesday, July 17, 2018 6:09 AM
Hello TIA,
What I use is a stored proc which can do a number of different...
--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:18 am

#1997795
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Monday, July 16, 2018 10:58 PM
dreynolds-779539 - Monday, July 16, 2018 9:01 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:14 am

#1997794

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