Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,511 through 15,525 (of 59,063 total)

RE: Efficient SQL Programming?

My pleasure again. You seem like you really want to hit it off on SQL server and if I can help you help your self not only on developing 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)

February 28, 2017 at 6:10 pm

#1930868
RE: DBA without sa rights???

jim.powers - Thursday, December 8, 2016 8:56 AM
Agreed...
Absolutely agreed. Especially if your boss isn't going to bat for you. It may be...
--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)

February 28, 2017 at 9:19 am

#1930736
RE: Efficient SQL Programming?

DataStorm - Monday, February 27, 2017 10:06 PM
Hi Jeff!Speaking of books, do you have any recommendations? Any favorites for someone at...
--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)

February 28, 2017 at 9:05 am

#1930729
RE: Performance improves after reboot

I can't help there. Won't even try to make an educated guess because I don't use Mirrors or AG.
--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)

February 27, 2017 at 9:06 pm

#1930608
RE: Efficient SQL Programming?

My pleasure. You're on the right path because you "try". Practice and the experienced gained from trying is worth a ton more than just being book learned although the books...
--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)

February 27, 2017 at 9:02 pm

#1930607
RE: Efficient SQL Programming?

Matt Miller (#4) - Monday, February 27, 2017 7:50 PM
Jeff Moden - Monday, February 27, 2017 9:22...
--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)

February 27, 2017 at 8:18 pm

#1930603
RE: The Secure Medical Data Challenge

jay-h - Monday, February 27, 2017 8:00 AM
Years ago Social Security was the ONLY legal use for a SSN. Now it's college...
--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)

February 27, 2017 at 7:12 pm

#1930598
RE: Efficient SQL Programming?

Grant Fritchey - Monday, February 27, 2017 2:18 AM
Man, Jeff. Leave some crumbs for the rest of us.
Heh... thanks for the feedback,...
--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)

February 27, 2017 at 9:22 am

#1930495
RE: Check if xp_cmdshell is turned on and flip the bit

SQLShark - Monday, February 27, 2017 8:24 AM
Great Deck, I agree with all your points. Sometimes it would be nice to include...
--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)

February 27, 2017 at 9:12 am

#1930490
RE: Check if xp_cmdshell is turned on and flip the bit

Thank you both for the feedback. In fact, I've been considering converting it to an article so I really appreciate it.
--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)

February 27, 2017 at 8:14 am

#1930477
RE: Human and Machine Learning

xsevensinzx - Sunday, February 26, 2017 12:10 AM
I know from my end where I work primarily with data science, we are using...
--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)

February 26, 2017 at 11:22 pm

#1930418
RE: Roll from lowest level child to it's subsequent parent

PSB - Sunday, February 26, 2017 8:28 PM
Any help will be appreciated..
For your entire series of questions on this particular table, 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)

February 26, 2017 at 11:00 pm

#1930416
RE: Efficient SQL Programming?

What you have there is a "Catch-All" query where the input parameters could be missing, have a special meaning (All), or have an actual value. As you found out, that...
--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)

February 26, 2017 at 10:34 pm

#1930414
RE: Searching for date and weekday counts within Nvarchar column

I tend to "over-engineer" a bit when it comes to the quality of data. Yep... we need to know the hourly stuff but I'd also want to know how...
--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)

February 26, 2017 at 1:31 pm

#1930393
RE: XP_CMDSHELL & RS.EXE and access rights

John Mitchell-245523 - Friday, February 24, 2017 5:19 AM
Have you tried running SQL Server under a named Windows account (either domain or...
--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)

February 25, 2017 at 3:38 pm

#1930357

Viewing 15 posts - 15,511 through 15,525 (of 59,063 total)