Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,481 through 15,495 (of 59,101 total)

RE: How to parse this, 'F0-B20170225131636437{A^CM.INIT}'

NineIron - Wednesday, March 8, 2017 4:08 AM
I didn't think you needed rules but, here goes.............
The ^ is always the character before...
--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 8, 2017 at 8:03 am

#1932313
RE: Are the posted questions getting worse?

ThomasRushton - Wednesday, March 8, 2017 7:46 AM
Gazareth - Wednesday, March 8, 2017 7:40 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 8, 2017 at 7:55 am

#1932310
RE: TempDB Database On a Local Disk for an FCI

I've found that putting TempDB on SSDs normally doesn't help much. Good code doesn't need it and bad code might see a 2X-5X improvement, which is still a pitiful improvement...
--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 8, 2017 at 7:51 am

#1932308
RE: Import problem

Sue_H - Tuesday, March 7, 2017 4:09 PM
bmg002 - Tuesday, March 7, 2017 3:34 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 7, 2017 at 10:36 pm

#1932209
RE: Are the posted questions getting worse?

ZZartin - Tuesday, March 7, 2017 12:33 PM
Neil Burton - Tuesday, March 7, 2017 12:14 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 7, 2017 at 3:17 pm

#1932191
RE: Import problem

Sue_H - Tuesday, March 7, 2017 2:10 PM
That could just be me as SSIS just pisses me off sometimes.
Sue
I'm sensing...
--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 7, 2017 at 3:10 pm

#1932189
RE: How to overcome the identity column "jump 1000" issue

Grant Fritchey - Tuesday, March 7, 2017 2:15 AM
Jeff Moden - Monday, March 6, 2017 9:12 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 7, 2017 at 1:00 pm

#1932149
RE: Please explain difference between these terms

Ah...yup. Bad spelling on my part. Thanks for pointing it out. Hopefully, the OP understood the principle I was trying to get across. 😉
--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 6, 2017 at 9:45 pm

#1931971
RE: How to overcome the identity column "jump 1000" issue

spaghettidba - Thursday, January 15, 2015 4:40 AM
It's a known issue. The TF resolves it, but IMHO a gap or jump in...
--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 6, 2017 at 9:12 pm

#1931969
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 8:00 PM
Jeff Moden - Monday, March 6, 2017 6:51 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 6, 2017 at 8:46 pm

#1931968
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 12:34 PM
>>I am using the date / time from a view to join on...
--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 6, 2017 at 6:51 pm

#1931964
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:57 PM
Jeff Moden - Monday, March 6, 2017 12:30 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 6, 2017 at 4:07 pm

#1931956
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:20 PM
The original article.
I'd recommend avoiding the rCTE in the original article. Please refer to 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)

March 6, 2017 at 12:30 pm

#1931904
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 11:56 AM
Interesting read - greatly appreciated.
One point to note: since the second query in the CTE...
--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 6, 2017 at 12:17 pm

#1931900
RE: Usage of CTE - Trick with Dates

SoCal_DBD - Monday, March 6, 2017 8:58 AM
Awww Jeff..... I hang my head in SHAME!!! :crying: Original post revised as...
--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 6, 2017 at 10:37 am

#1931875

Viewing 15 posts - 15,481 through 15,495 (of 59,101 total)