Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,981 through 16,995 (of 59,067 total)

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
RE: Tablix assistance please!

cad.delworth (8/17/2016)
I just noticed this thread: though Jeff's code is as always impressive (and as always, yet another plug for his Tally tables :rolleyes:), I can't help feeling it would...
--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, 2016 at 6:45 pm

#1896070
RE: Loop through an integer and test the values and update with a char

Alan.B (8/17/2016)
Jeff Moden (8/17/2016)
Just an opinion... you just about can't beat a Nested Replace, like what Scott wrote, for something like this. I say "just about" only because 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 17, 2016 at 2:35 pm

#1896037
RE: data load performance

arkiboys (8/17/2016)
Hello,
using a combination of ssis and C#, we are placing file data into sql server tables.
The files contain around 70 million of rows...
We can not use bulk insert as...
--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, 2016 at 2:30 pm

#1896036
RE: Loop through an integer and test the values and update with a char

Just an opinion... you just about can't beat a Nested Replace, like what Scott wrote, for something like this. I say "just about" only because I don't know of...
--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, 2016 at 2:15 pm

#1896030

Viewing 15 posts - 16,981 through 16,995 (of 59,067 total)