Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,436 through 12,450 (of 59,099 total)

RE: Log backup chain

I know this post is old but why the heck does a user have enough privs to backup a database? Such things can affect more than just your log file...
--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)

May 2, 2018 at 6:09 pm

#1989011
RE: Recursive with multiple first lines

If you could post some readily consumable data (see the first link in my signature line below under "Helpful Links" for how to do that), I'd be happy to scribe...
--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)

May 2, 2018 at 4:56 pm

#1989008
RE: Upper Case Lower Case

I'm seriously missing it in the thread above. What "small change" did Luis make?
--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)

May 2, 2018 at 4:47 pm

#1989007
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Wednesday, May 2, 2018 2:56 PM
Jeff Moden - Tuesday, May 1, 2018 10:04 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)

May 2, 2018 at 4:43 pm

#1989006
RE: The SQL Joke Thread

Why did the DBA get hit by a car? He didn't know how to back up.
--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)

May 2, 2018 at 10:25 am

#1988958
RE: Advanced Data Masking

If, by data masking, you simply mean something like using a mask for viewing purposes, then be aware that such masks are incredibly easy to overcome and you can actually...
--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)

May 2, 2018 at 10:23 am

#1988956
RE: Transpose Rows to column

Aye. Nicely done, Jason.
--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)

May 2, 2018 at 7:44 am

#1988930
RE: Upper Case Lower Case

jonathan.crawford - Wednesday, May 2, 2018 6:14 AM
Jeff Moden - Initial creation 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)

May 2, 2018 at 7:37 am

#1988928
RE: Counting Active records for each month based on date range in 2 columns

Please see the following article. It breaks it down to make it real simple. Although the article is title for the "previous month", it applies to any date range you...
--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)

May 1, 2018 at 8:23 pm

#1988882
RE: Transpose Rows to column

sksingh123 - Tuesday, May 1, 2018 2:58 PM
Can anyone help me to transpose below result
SVR    dates    count
SRV1    03/25/2018    1
SRV1    04/06/2018    59
SRV1    04/07/2018    9
SRV1    04/13/2018    1
SRV1    04/15/2018    1
SRV1    04/20/2018    4
SRV1    04/21/2018    2
SRV1    04/27/2018    5
SRV1    04/28/2018    5
SRV1    04/29/2018    1
SRV1    04/30/2018    62
Date can be variable and the range 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)

May 1, 2018 at 8:19 pm

#1988881
RE: Advanced Data Masking

WebTechie - Tuesday, May 1, 2018 11:07 AM
Steve,
Yes, I saw a demo of that product. That is why I was asking 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)

May 1, 2018 at 11:38 am

#1988826
RE: Number of Days between two Day Names

Thom A - Tuesday, May 1, 2018 9:58 AM
Jeff Moden - Tuesday, May 1, 2018 9:37 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)

May 1, 2018 at 10:04 am

#1988806
RE: Random Word Generation for Data Scrubbing

SQLBlimp - Tuesday, May 1, 2018 7:54 AM
Eirikur Eiriksson - Tuesday, May 1, 2018 7:52 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)

May 1, 2018 at 9:48 am

#1988803
RE: Number of Days between two Day Names

I'll be interesting as hell to see what happens during a "wrap around" when the start day is a Thursday and the end day is a Monday. And what 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)

May 1, 2018 at 9:37 am

#1988800
RE: Random Word Generation for Data Scrubbing

Great job, John. Can you share the link for the dictionary download that you used? I ask because most word lists seem to be rather unabridged when it comes 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)

May 1, 2018 at 6:09 am

#1988749

Viewing 15 posts - 12,436 through 12,450 (of 59,099 total)