Jeff Moden

Forum Replies Created

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

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
RE: Need help Insert and Update in Single Statement

abu.salim.6181 - Monday, September 3, 2018 8:09 PM
Hello Jeff,
I want to reduce deadlock. That's why I want to make it short @...
--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 8:31 pm

#2004295
RE: Fiscal Year Partition with Fact tables

It sounds to me that you don't even know if partitioning is the right thing to do never mind how to do it.
BigB -...
--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 8:23 pm

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

abu.salim.6181 - Monday, September 3, 2018 8:58 AM
Hello Sir Jonathan AC Roberts,
I mean...
--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 8:03 pm

#2004291
RE: Get databasename for a particular user

JackCarrington - Monday, September 3, 2018 9:47 AM
Never mind 🙂
Please share what caused you to say "Never Mind". What did you find...
--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 8:01 pm

#2004290

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