Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

jasona.work - Wednesday, March 1, 2017 10:50 AM
Brandie Tarvin - Wednesday, March 1, 2017 10: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)

March 1, 2017 at 11:40 pm

#1931101
RE: Code Test from IE

Is that cut and paste from SSMS or from Notepad like I have to preserve both the leading spaces and the proper line spaceing? Also, I'm see it as 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)

March 1, 2017 at 10:50 pm

#1931100
RE: Detecting Issues

Steve Jones - SSC Editor - Wednesday, March 1, 2017 9:01 AM
Jeff Moden - Wednesday, March 1,...
--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 1:50 pm

#1931061
RE: Detecting Issues

Ironically, the very techniques talked about in this article apparently haven't been exercised for the recent forum update and one of the most important parts of this site, the SQL...
--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:36 am

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

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