Jeff Moden

Forum Replies Created

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

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
RE: how can i get the top 3, after i count the column ?

Folks are still forgetting about "ties". If you have a dozen ties for 1st, 2nd, or 3rd, is it actually appropriate to ignore such ties or should (must) they be...
--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:12 am

#1997792
RE: The Age of Multiple Databases

xsevensinzx - Monday, July 16, 2018 6:28 PM
Nope, I mean I am NOT JUST using SQL Server to solve everything. I'm...
--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 16, 2018 at 8:27 pm

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

BONITO - Monday, July 16, 2018 8:00 PM
I got it , thanks for all the reply,
i review my code again and 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 16, 2018 at 8:22 pm

#1997762
RE: The Age of Multiple Databases

Rod at work - Monday, July 16, 2018 8:41 AM
Challenging article, Steve. For almost 2 decades I've worked with only relational databases,...
--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 16, 2018 at 4:47 pm

#1997756

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