Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Rick-153145 - Monday, April 23, 2018 7:49 AM
Jeff Moden - Monday, April 23, 2018 7:38 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 23, 2018 at 12:17 pm

#1987927
RE: Spills into tempdb poor performing query fixed by converting to SP

SQL Bandit - Monday, April 23, 2018 4:33 AM
declare @accountId0 bigint = 1719,
@status1 int = 11,
@senderDone2 bit = 0,
@PreviewMode3 bit...
--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 12:12 pm

#1987926
RE: SQL 2014 Standard - Reindex DB Processing Time

cmp119 - Monday, April 23, 2018 10:56 AM
At the end of each month I reindex a critical financial database on 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)

April 23, 2018 at 11:23 am

#1987923
RE: Refreshing lower environments with prod copy

Feivel - Monday, April 23, 2018 11:02 AM
Jeff Moden - Monday, April 23, 2018 9:34 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 23, 2018 at 11:08 am

#1987921

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