Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,281 through 11,295 (of 59,095 total)

RE: When is too many columns too many columns?

andycadley - Thursday, September 6, 2018 6:19 AM
In this particular case it is still a 32-bit system and most queries against 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)

September 6, 2018 at 7:04 am

#2004698
RE: When is too many columns too many columns?

Kevlarmpowered - Thursday, September 6, 2018 6:16 AM
Jeff Moden - Wednesday, September 5, 2018 7:47 PM
--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)

September 6, 2018 at 6:59 am

#2004696
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 12:32 PM
Jeff Moden - Wednesday, September 5, 2018 12:19 PM
--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)

September 6, 2018 at 6:21 am

#2004693
RE: When is too many columns too many columns?

andycadley - Wednesday, September 5, 2018 10:19 PM
I'd never do it with date and time values, it just becomes impossible to query...
--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)

September 6, 2018 at 5:36 am

#2004675
RE: When is too many columns too many columns?

Kevlarmpowered - Wednesday, September 5, 2018 6:51 PM
Without having it right in front of me, I'm willing to say that almost all...
--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)

September 5, 2018 at 7:47 pm

#2004625
RE: Managing a large SQL estate ?

CC-597066 - Wednesday, September 5, 2018 2:20 PM
I built an in-house monitoring system based on Rodney Landrum/David Bird's SSIS packages 10 years ago...
--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)

September 5, 2018 at 3:49 pm

#2004612
RE: When is too many columns too many columns?

ScottPletcher - Wednesday, September 5, 2018 12:04 PM
Jeff Moden - Wednesday, September 5, 2018 11:38 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)

September 5, 2018 at 12:21 pm

#2004569
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 11:43 AM
Jeff Moden - Wednesday, September 5, 2018 11:36 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)

September 5, 2018 at 12:19 pm

#2004568
RE: When is too many columns too many columns?

ScottPletcher - Wednesday, September 5, 2018 11:34 AM
Sergiy - Tuesday, September 4, 2018 9:04 PM
--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)

September 5, 2018 at 11:38 am

#2004556
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 11:17 AM
Jeff Moden - Wednesday, September 5, 2018 10: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)

September 5, 2018 at 11:36 am

#2004555
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, September 5, 2018 10:28 AM
Sean Lange - Wednesday, September 5, 2018 8:38 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)

September 5, 2018 at 11:01 am

#2004547
RE: Separating SSIS Datetime

RonKyle - Wednesday, September 5, 2018 7:45 AM
Jeff Moden - Monday, September 3, 2018 7:29 PM
--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)

September 5, 2018 at 10:46 am

#2004541
RE: Can't Get BULK INSERT TO ERROR!!!

Is the production description field in the file ALWAYS encapsulated in double quotes?
--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)

September 5, 2018 at 5:13 am

#2004480
RE: Fiscal Year Partition with Fact tables

Didn't get home very long ago. Really full days lately but figured I tell you what I've done for my largest portioned table, which consists of a little bit 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)

September 4, 2018 at 8:47 pm

#2004458
RE: Fiscal Year Partition with Fact tables

ScottPletcher - Tuesday, September 4, 2018 1:28 PM
What often happens with partitioning is that, as part of the partitioning process, the table...
--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)

September 4, 2018 at 7:04 pm

#2004456

Viewing 15 posts - 11,281 through 11,295 (of 59,095 total)