Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,296 through 11,310 (of 59,099 total)

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
RE: Can't Get BULK INSERT TO ERROR!!!

Jacob Pressures - Tuesday, September 4, 2018 10:33 AM
Hello guys! Thanks for the feedback. My team decided not to use SSIS at...
--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 12:56 pm

#2004425
RE: Managing a large SQL estate ?

mark 52160 - Tuesday, September 4, 2018 6:53 AM
Jeff Moden - Tuesday, September 4, 2018 5:56 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 4, 2018 at 12:52 pm

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

Jonathan AC Roberts - Tuesday, September 4, 2018 12:20 PM
I've had a Dimension table that had over 520 columns.
The updates to...
--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 12:45 pm

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

One of the big problems that people tend to either be totally unaware of or just forget is the issue of wasted disk space and wasted memory. For example, if...
--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 11:38 am

#2004401
RE: Fiscal Year Partition with Fact tables

BigB - Monday, September 3, 2018 10:48 PM
Sergiy - Monday, September 3, 2018 6:23 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 4, 2018 at 6:13 am

#2004331
RE: SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise

quackhandle1975 - Tuesday, September 4, 2018 3:48 AM
I am just please we found a solution as when you are dealing with 10+...
--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 6:03 am

#2004328
RE: Managing a large SQL estate ?

mark 52160 - Tuesday, September 4, 2018 1:54 AM
Jeff Moden - Monday, September 3, 2018 7:56 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 4, 2018 at 5:56 am

#2004327
RE: Separating SSIS Datetime

Brandie Tarvin - Tuesday, September 4, 2018 5:35 AM
There are a couple of ways you can do this.
1) Build the file import...
--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 5:51 am

#2004326
RE: Separating SSIS Datetime

tmmutsetse - Tuesday, September 4, 2018 1:44 AM
Thanks,the database was set up like that and i am new with the company it's...
--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 5:46 am

#2004324
RE: Get databasename for a particular user

JackCarrington - Tuesday, September 4, 2018 5:10 AM
Jeff Moden - Monday, September 3, 2018 8:01 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 4, 2018 at 5:22 am

#2004321
RE: Need help Insert and Update in Single Statement

abu.salim.6181 - Monday, September 3, 2018 8:59 PM
Here my function
CREATE FUNCTION [dbo].[fn_Split](@text varchar(8000), @delimiter varchar(20) = ' ')
RETURNS @Strings...
--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 3, 2018 at 9:41 pm

#2004297

Viewing 15 posts - 11,296 through 11,310 (of 59,099 total)