Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,421 through 15,435 (of 59,097 total)

RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Wednesday, March 15, 2017 7:40 PM
Lynn Pettis - Wednesday, March 15, 2017 9: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 17, 2017 at 8:37 pm

#1933856
RE: 'Spell check' a string-valued field

Just curious... is that what you were looking for?
--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 17, 2017 at 8:28 pm

#1933855
RE: Replacing BCP with SQLBulkLoad

I know this article is 14 years old but it's interesting to see that the grammar police were just as petty back then as they are now. What the hell...
--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 17, 2017 at 8:04 pm

#1933853
RE: Replacing BCP with SQLBulkLoad

DavidCameron - Monday, July 21, 2003 1:02 AM
This article assumes that XML is the way of the future, which is a false...
--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 17, 2017 at 7:18 pm

#1933852
RE: Encapsulating complex logic without using a scalar UDF

While the conversation on a workdays cumulative column and some of its permutations is certainly a good one, it has nothing to do with the original post of how 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)

March 17, 2017 at 6:01 pm

#1933850
RE: Are the posted questions getting worse?

Sean Lange - Friday, March 17, 2017 7:56 AM
Luis Cazares - Thursday, March 16, 2017 3:16 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)

March 17, 2017 at 9:39 am

#1933775
RE: Windows Functions: Tell me when that changes.

adame - Thursday, February 18, 2016 1:38 AM
Agreed, always look to use new features.
Nah...you did good. I agree that there have been...
--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 17, 2017 at 9:14 am

#1933770
RE: Windows Functions: Tell me when that changes.

ChrisM@Work - Friday, March 17, 2017 2:54 AM
davidawest00 - Wednesday, February 17, 2016 10: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)

March 17, 2017 at 8:57 am

#1933765
RE: A full and a diff

Heh... for me, the correct answer for me is there would be no files because I don't use PoSh to do backups. 😉
--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 16, 2017 at 7:18 am

#1933458
RE: Day-of-week to Week-Number mapping

Cross Join with a list of weeks? Don't forget to compensate for laundry day offsets. 😉
--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 16, 2017 at 7:06 am

#1933453
RE: Are the posted questions getting worse?

Hugo Kornelis - Thursday, March 16, 2017 2:47 AM
Jeff Moden - Wednesday, March 15, 2017 8:49 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)

March 16, 2017 at 6:47 am

#1933449
RE: Getting Data and Headers

Ed Wagner - Thursday, March 2, 2017 6:25 AM
Luis Cazares - Wednesday, March 1, 2017 6:53 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 15, 2017 at 9:06 pm

#1933393
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Wednesday, March 15, 2017 7:40 PM
Lynn Pettis - Wednesday, March 15, 2017 9: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 15, 2017 at 9:02 pm

#1933392
RE: Are the posted questions getting worse?

Alan.B - Wednesday, March 15, 2017 3:01 PM
Lowell - Wednesday, March 15, 2017 1:32 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)

March 15, 2017 at 8:49 pm

#1933391
RE: How to allow a user to consult all jobs in my server, using SSMS?

Haley - Wednesday, March 15, 2017 10:38 AM
Hello,
I need some help with SQL Server 2012, please!
How to allow a user 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)

March 15, 2017 at 6:39 pm

#1933388

Viewing 15 posts - 15,421 through 15,435 (of 59,097 total)