Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,541 through 15,555 (of 59,097 total)

RE: Using a WHERE clause as a parameter

frankb 74878 - Wednesday, March 1, 2017 7:53 AM
heb1014 - Wednesday, March 1, 2017 6:25 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)

March 1, 2017 at 8:09 am

#1930973
RE: Function works when passing in parameters, does not work with CROSS APPLY

ChrisM@Work - Wednesday, March 1, 2017 5:31 AM
kyagi.jo - Wednesday, March 1, 2017 3:44 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)

March 1, 2017 at 7:29 am

#1930959
RE: Getting Data and Headers

Unless they changed it in 2016, if your grid options are setup correctly for including headers, just a regular CTRL-C will do it. No need for the more complex combinations.
--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)

March 1, 2017 at 12:30 am

#1930881
RE: Insert into # Select without order by

You have to be more specific as to what you expected and how those expectations weren't met. If you're expecting a "natural order" of some sort in the table, then...
--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 8:47 pm

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

Viewing 15 posts - 15,541 through 15,555 (of 59,097 total)