Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,091 through 12,105 (of 59,095 total)

RE: SSRS 2016 - HTML5 rendering issues

I'm curious... who is actually going to peruse a 4,000 row HTML document?
--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)

June 16, 2018 at 5:28 pm

#1994215
RE: Grouping and Exporting to Text File

Here's the test data setup I used...

CREATE TABLE #TestTable
        (
         id         INT
        ,location   VARCHAR(50)
        )
;
INSERT INTO #TestTable
       ...
--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)

June 16, 2018 at 5:14 pm

#1994214
RE: Entering random data into a table

p.s. I guess you had a couple of special characters in your @Texto string... they didn't copy correctly when I pasted my code. You may have to change some 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)

June 16, 2018 at 3:12 pm

#1994210
RE: Entering random data into a table

I appreciate anyone that will step up to the plate with an article or a script. Since you brandish the title of "MVP" in your handle and I've verified 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)

June 16, 2018 at 3:10 pm

#1994209
RE: One large vs several small files

p.s. To answer the question that was asked... no... I wouldn't split up the files. It's just another "touch" on the data that could screw something up and complicates things...
--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)

June 16, 2018 at 12:20 pm

#1994207
RE: One large vs several small files

kdbarrett 88655 - Friday, June 15, 2018 10:35 AM
It's a bit more than just streaming into a database. There is some processing,...
--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)

June 16, 2018 at 12:15 pm

#1994206
RE: Building Test Data

Frank W Fulton Jr - Friday, June 15, 2018 3:40 PM
The biggest problem with creating your own test data...
--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)

June 15, 2018 at 9:18 pm

#1994195
RE: Building Test Data

Eric M Russell - Friday, June 15, 2018 8:56 AM
Jeff Moden - Thursday, June 14, 2018 9:16...
--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)

June 15, 2018 at 9:09 am

#1994128
RE: The Data Submarine

Steve Jones - SSC Editor - Friday, June 15, 2018 8:01 AM
Jeff Moden - Thursday, June 14,...
--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)

June 15, 2018 at 9:07 am

#1994126
RE: Return All affected dbs in error

Super Cat - Friday, June 15, 2018 1:47 AM
I was really simple. Embarrassed I posted now. Dumped the name in a temp...
--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)

June 15, 2018 at 7:55 am

#1994112
RE: REPLACE Multiple Spaces with One

Thanks for the feedback, Jessin.
--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)

June 15, 2018 at 7:53 am

#1994110
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, June 14, 2018 10:37 AM
Jeff Moden - Wednesday, June 13,...
--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)

June 14, 2018 at 11:57 pm

#1994079
RE: Removing blank spaces in records.

jessinthomas012 - Thursday, June 14, 2018 1:53 AM
Hi Tryst,
Please try this one..
--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)

June 14, 2018 at 11:46 pm

#1994078

RE: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Thanks for sharing that, Leon. A lot of people forget about such things. MSDB IS a database and it does need to be maintained.

--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)

June 14, 2018 at 11:36 pm

#1994077

RE: DelimitedSplit8k and Performance

Steven.Grzybowski - Thursday, June 14, 2018 11:38 AM

After splitting things out into temp tables before attempting to do the big calculations, I...

--Jeff Moden

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)

June 14, 2018 at 9:38 pm

#1994074

Viewing 15 posts - 12,091 through 12,105 (of 59,095 total)