Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,466 through 15,480 (of 59,097 total)

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

GilaMonster - Wednesday, March 8, 2017 3:07 PM
GilaMonster - Wednesday, March 8, 2017 12:16 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 5:02 pm

#1932435
RE: how to use following xml query with out prefix

rajemessage 14195 - Wednesday, March 8, 2017 8:38 AM
hi,
in following link
https://msdn.microsoft.com/en-us/library/ms175178.aspx
i found this cote
"This prefix is then used 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 8, 2017 at 4:57 pm

#1932433
RE: Are the posted questions getting worse?

djj - Wednesday, March 8, 2017 1:02 PM
Well I have been out of a job for a few weeks now, and I...
--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:42 pm

#1932430
RE: SQL Server 2016 DBA Training

Andy Reilly - Wednesday, March 8, 2017 3:19 AM
Hi Jeff,
You say to get the books - But unless I'm going blind there...
--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:35 pm

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

Viewing 15 posts - 15,466 through 15,480 (of 59,097 total)