Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,011 through 17,025 (of 59,101 total)

RE: difference betwwn inner join and intersect in sql

There's another huge difference than many overlook. All such operators (Intersect, Except, Union, etc) use NULL = NULL regardless of any server setting to the contrary for "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)

August 19, 2016 at 10:03 am

#1896383
RE: Are the posted questions getting worse?

The Dixie Flatline (8/18/2016)
Jeff Moden (8/18/2016)
I guess it's my turn in the proverbial barrel.
http://www.sqlservercentral.com/Forums/FindPost1810510.aspx
For this, you wear the HAT OF SHAME.
Heh... Cross out the "S" and the "E" 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)

August 19, 2016 at 7:52 am

#1896353
RE: Tablix assistance please!

David Burrows (8/19/2016)
Jeff Moden (8/18/2016)
You're mistaken. It's not a contest. I'm just interested in possible differences in performance and I'm interested in seeing the actual package because most...
--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, 2016 at 7:35 am

#1896345
RE: Update statistics after Index Rebuild ?

GilaMonster (8/19/2016)
I don't know why that warning sometimes appears. It might be the QO needs multi-column stats, which will not be manually created. I need to research that sometime.
I'd say...
--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, 2016 at 7:31 am

#1896342
RE: Still Confused about the difference between varchar(max) and varchar(8000)

RonKyle (8/18/2016)
This is also why I don't let "developers" do database design unless they've been trained to do it right
Unfortunately not everyone has that luxury. It doesn't help 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 18, 2016 at 5:41 pm

#1896274
RE: Index on table with 70+ million rows

Rowan-283474 (8/18/2016)
Well the table is part of an ETL process, so it gets truncated and re-populated with approx 70 mil rows.
Before I populate the table I disable all indexes 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 18, 2016 at 5:21 pm

#1896271
RE: Are the posted questions getting worse?

I guess it's my turn in the proverbial barrel.
http://www.sqlservercentral.com/Forums/FindPost1810510.aspx
--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 18, 2016 at 4:47 pm

#1896268
RE: Update statistics after Index Rebuild ?

GilaMonster (8/18/2016)
Jeff Moden (8/18/2016)
I'm toying with the idea of just dropping all the stats that have the minor nuance in the name that I spoke of and letting the system...
--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 18, 2016 at 4:27 pm

#1896265
RE: Tablix assistance please!

cad.delworth (8/18/2016)
Sorry Jeff, No I don't have the spare time at work that you seem to have. What I posted was intended to show anyone with a basic knowledge...
--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 18, 2016 at 4:14 pm

#1896263
RE: Update statistics after Index Rebuild ?

GilaMonster (8/17/2016)
Yup, but those column stats are usually very important (if they weren't necessary the optimiser wouldn't have had them created), and there's still the index stats on indexes 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 18, 2016 at 8:15 am

#1896164
RE: Are the posted questions getting worse?

Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"
erm... SELECT...
--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 18, 2016 at 8:01 am

#1896162
RE: Still Confused about the difference between varchar(max) and varchar(8000)

RonKyle (8/18/2016)
This is a choice that developers doing database design make...
THAT would be the most important problem to fix. Such people will recite Knuth's famous "Pre-optimization is the root...
--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 18, 2016 at 7:48 am

#1896154
RE: Tablix assistance please!

@faulknerwilliam2,
I know you must be busy but any feedback on the questions below?
Jeff Moden (8/16/2016)
If you don't mind and if you have the time, I'd like to ask a couple...
--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 18, 2016 at 7:11 am

#1896145
RE: Tablix assistance please!

Any other takers on showing how this problem (return the same output as the T-SQL I provided) could be done in SSRS and attaching a package for folks to learn...
--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 18, 2016 at 7:07 am

#1896141
RE: Tablix assistance please!

cad.delworth (8/18/2016)
Hmm, seems the only (?) way to put an image on here is to add it as an attachment.
So, the tablix in the first image file is produced 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 18, 2016 at 6:50 am

#1896136

Viewing 15 posts - 17,011 through 17,025 (of 59,101 total)