Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,436 through 15,450 (of 59,063 total)

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

Did you try Lowell's code (looks like it will work and he's really good about testing his stuff) and, if so, are you all set now?
--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 4:22 pm

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

GilaMonster - Wednesday, March 8, 2017 12:16 AM
Jeff Moden - Tuesday, March 7, 2017 1:00 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 8, 2017 at 2:25 pm

#1932409
RE: Whitespace in 3-part name ignored???

Heh... I don't let users design the tables and I do design reviews with the Developers prior to them writing code against new objects as well as having a written/enforced...
--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 2:20 pm

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

t.franz - Wednesday, March 8, 2017 8:07 AM
Michael L John - Wednesday, March 8, 2017 7:41 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 9:14 am

#1932347
RE: SQL Database Growing but Maintaining 40-50% Free Space

Although Ola's good code is a work of art, consider the following before you implement any index maintenance.
SQL Server doesn't actually care if the indexes are fragmented 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)

March 8, 2017 at 8:34 am

#1932327
RE: Whitespace in 3-part name ignored???

You guys are doing a really good job of keeping it all a "secret". 😉
--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:15 am

#1932320
RE: need Help for failed JOB

In other words, there may be a problem with the data where there is unexpected duplication and you need to check and make sure that's what's expected and then fix...
--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:13 am

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

Viewing 15 posts - 15,436 through 15,450 (of 59,063 total)