Jeff Moden

Forum Replies Created

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

RE: Modeling relational databases

To be honest, I usually tell auditors "NO" when it comes to producing a full system ERD. They usually don't have the need to know and it is a proprietary system. ...
--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 4:42 pm

#1956983
RE: Right Size for LDF physical disk

luismarinaray - Friday, August 25, 2017 1:44 PM
Dear friends,
Please, help me to take action, the facts are:
Big database 1.5 terabyte database size,...
--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 4:31 pm

#1956982
RE: Lookup values similar to VLookUp in Excel

JJR333 - Saturday, August 26, 2017 6:16 AM
Hi,
I am struggling to write a procedure which looks up a value in a...
--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 4:25 pm

#1956981
RE: Are the posted questions getting worse?

Sean Lange - Friday, August 25, 2017 11:54 AM
Boy the forums are getting buggier all the time. I have had several notifications...
--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:17 pm

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

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