Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,481 through 12,495 (of 59,099 total)

RE: Database Administration Team Reporting Hierarchy

alex.sqldba - Wednesday, April 25, 2018 4:49 AM
Morning Guys,
I have an organisational question and dilemma I am trying to work through; 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)

April 25, 2018 at 7:49 am

#1988176
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 25, 2018 3:42 AM
We've decided to split the table into sections (with _1, _2, etc. where necessary).
We kept...
--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)

April 25, 2018 at 7:38 am

#1988173
RE: Packaged-Application Database Nightmares - A Horror Story.

andrew gothard - Wednesday, April 25, 2018 4:01 AM
And, having worked with numerous third party packages I'm supposed to be surprised by...
--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)

April 25, 2018 at 7:35 am

#1988172
RE: Calculating Date Difference

tinausa - Tuesday, April 24, 2018 9:00 AM
Jeff Moden - Tuesday, April 24, 2018 7:33 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)

April 24, 2018 at 12:36 pm

#1988099
RE: Packaged-Application Database Nightmares - A Horror Story.

Good lord. "Packaged Application" certainly does include Microsoft. Here's what I found when I went to download SSMS 17.6. Thankfully, I use precisely zero maintenance plans but I'll be damned...
--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)

April 24, 2018 at 12:19 pm

#1988095
RE: Auditing

I've no experience in such auditing software but can only imagine how much extra data you'll end up needing to store. It also seems like a Catch-22... wouldn't you also...
--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)

April 24, 2018 at 8:09 am

#1988022
RE: New IT Departments

xsevensinzx - Tuesday, April 24, 2018 6:48 AM
Jeff Moden - Tuesday, April 24, 2018 6:35 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)

April 24, 2018 at 7:40 am

#1988015
RE: Calculating Date Difference

Shifting gears a bit, I probably wouldn't store the original data in such a horizontal format because you'd need to add columns to the table to add other event points. ...
--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)

April 24, 2018 at 7:33 am

#1988014
RE: New IT Departments

xsevensinzx - Tuesday, April 24, 2018 6:11 AM
The whole reason I exist is because of this quote from the article:
Citizen development...
--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)

April 24, 2018 at 6:35 am

#1988001
RE: Cloud Snake Oil

Heh... glad to see this article. I'd done some contract work for different companies where they contracted a "provider" for both hardware, SQL Server, and things like backups. None 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)

April 24, 2018 at 6:27 am

#1987999
RE: Potential presentation idea: Networking -- an interactive how-to

Ray K - Monday, April 23, 2018 9:24 AM
I have yet another presentation idea. What do you folks think of this?
My working...
--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)

April 24, 2018 at 6:06 am

#1987993
RE: Need to add MMM-yyyy to end of file in exp.builder-SSIS

David Burrows - Tuesday, April 24, 2018 5:56 AM
Jeff Moden - Monday, April 23, 2018 4:53 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)

April 24, 2018 at 6:00 am

#1987992
RE: error in backup encryption

Hopefully you didn't just publish a real password. 😉
--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)

April 23, 2018 at 5:04 pm

#1987959
RE: Need to add MMM-yyyy to end of file in exp.builder-SSIS

ZZartin - Monday, April 23, 2018 3:31 PM
Why are you doing this in SSIS at all, this can be done in one...
--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)

April 23, 2018 at 4:53 pm

#1987957
RE: Need to add MMM-yyyy to end of file in exp.builder-SSIS

I'll also state that you'll really, really end up hating yourself or someone will end up hating you if you use the format of MMM-yyyy for this because it's flat...
--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)

April 23, 2018 at 3:03 pm

#1987944

Viewing 15 posts - 12,481 through 12,495 (of 59,099 total)