Jeff Moden

Forum Replies Created

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

RE: Archiving database in SQL Server 2008 R2 Standard

Create one database for each month using an extension of _YYYYMM as a part of the database name. The "table" in each of these databases can be the same name...
--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 18, 2018 at 9:08 am

#1994306
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Eric M Russell - Monday, June 18, 2018 8:25 AM
It's no surprise that, after manufacturing, customer service would be the next industry...
--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 18, 2018 at 8:51 am

#1994302
RE: Providing Feedback to Speakers

"I don’t like the speaker’s choice of shirt"
My understanding is that Steve Jones get's that complaint a lot. 😀
Seriously... good article. Thanks for taking the time...
--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 18, 2018 at 8:46 am

#1994300
RE: Help needed on TSQL query: update using a self join

This request just doesn't seem right. I don't know why anyone would actually need to do this but my initial impression is that it's on the edge of "data tampering".
--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 18, 2018 at 8:30 am

#1994296
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Victor Kirkpatrick - Monday, June 18, 2018 4:40 AM
There has to be a balance here. I mean, if automation will put so...
--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 18, 2018 at 8:24 am

#1994294
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 6:46 PM
Hi Jeff,
I understand and accept your words,...
--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 17, 2018 at 7:08 pm

#1994228
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 5:11 PM
Junior GalvÃ£o - MVP - Sunday, June...
--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 17, 2018 at 6:14 pm

#1994226
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

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