Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,521 through 14,535 (of 59,097 total)

RE: Why did added partitions make cube processing slower?

It's funny how the term "incremental load" seems to have changed over time. To me, an "incremental load" has always meant an "upsert" where items that already exist aren't reloaded,...
--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)

August 26, 2017 at 2:12 pm

#1956977
RE: Responsibility to Learn

Matt Miller (4) - Saturday, August 26, 2017 12:52 AM
Eric M Russell - Friday, August 25, 2017...
--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)

August 26, 2017 at 1:43 pm

#1956976
RE: how to perform update

marko.celarc - Saturday, August 26, 2017 12:59 AM
Thanks guys for your replies. I appreciate your effort very very much.
Now to the results:
I've...
--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)

August 26, 2017 at 1:20 pm

#1956975
RE: how to perform update

sgmunson - Friday, August 25, 2017 10:54 AM
Thanks Jeff for reminding me of the rest of the requirements on quirky update. 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)

August 25, 2017 at 1:06 pm

#1956934
RE: SQLCMD Mode; Run all SQL files in a directory

Lowell - Friday, August 25, 2017 7:52 AM
i do something exactly like this in PowerShell; with that, i can capture the output...
--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)

August 25, 2017 at 9:58 am

#1956886
RE: SQLCMD Mode; Run all SQL files in a directory

BTW, Jason... cool article. I know what your goal was and you nailed that. The article is also spawning some pretty good side-bars. 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)

August 25, 2017 at 9:55 am

#1956885
RE: Data flow concept - Thoughts wanted

Tom_Hogan - Friday, August 25, 2017 8:07 AM
Jeff Moden - Thursday, August 24, 2017 11: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)

August 25, 2017 at 9:53 am

#1956884
RE: how to perform update

Phil posted a great solution that becomes available in 2012 and above. It's appropriate because this is a 2012 forum. 😉
Although I'm a really big fan...
--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)

August 25, 2017 at 8:32 am

#1956862
RE: SQLCMD Mode; Run all SQL files in a directory

wmyers01+SSC - Monday, September 14, 2015 7:59 AM
You know you can skip all of that and just run this following from the...
--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)

August 25, 2017 at 7:31 am

#1956838
RE: SQLCMD Mode; Run all SQL files in a directory

wim.buyens - Monday, September 14, 2015 7:24 AM
u can also use CLR and run all the code from T-SQL
I love it when...
--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)

August 25, 2017 at 7:26 am

#1956835
RE: Trying to create function to create folders (and sub folders)

barsuk - Friday, August 25, 2017 12:16 AM
Jeff Moden - Thursday, August 24, 2017 11:42 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)

August 25, 2017 at 7:16 am

#1956830
RE: Data flow concept - Thoughts wanted

Seems like it would use a whole lot less resources if you...
1. Bulk insert just the first row as a blob.
2. Split the first row to get...
--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)

August 24, 2017 at 11:47 pm

#1956753
RE: Trying to create function to create folders (and sub folders)

barsuk - Thursday, August 24, 2017 11:07 PM
you can also incorporate creating folders via mkdir:
SET @Path = '\\xxxxxxx\yyyyyy\'
SET @ssql...
--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)

August 24, 2017 at 11:42 pm

#1956752
RE: Curious Case of SUM Function

This "spackle-size" article actually packs one hell of a wallop if you take the time to read it and understand the examples given. People forget about things such as precision, 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)

August 24, 2017 at 8:37 am

#1956643
RE: SQL Server - It's not really a Mailer Service, is it?

My apologies for the delay.
Here's the proc I use to send email from SQL Server without using sp_Send_DBMail. This is my "presentation" version that I give to others and...
--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)

August 24, 2017 at 7:58 am

#1956626

Viewing 15 posts - 14,521 through 14,535 (of 59,097 total)