Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,501 through 7,515 (of 59,091 total)

Reply To: would like to know more about identity_cache

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
Steve Collins wrote:
Afaik and imo there are no pros only cons. There is no such thing as a "gap" in a primary key because 'unit consistency' is not a...
--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 24, 2020 at 4:53 pm

#3736686
Reply To: Partitioning Limits in SQL Server 2019

Understood but, unless specifically stated (and I found this out the hard way a long time ago), the QOTD questions are based on the current version of SQL and do...
--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 24, 2020 at 4:42 pm

#3736681
Reply To: PARSENAME and Input Length

Aaron N. Cutshall wrote:
Doesn't this work only provided that the delimiter is a period?
Yes.
--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 24, 2020 at 4:09 pm

#3736651
Reply To: Collections: Crossing intervals computed gaps

Just to be sure, I appreciate anyone willing to step up and write articles to share their knowledge with other people especially when they come up with such a different...
--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 23, 2020 at 11:05 pm

#3736468
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice...
--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 23, 2020 at 10:37 pm

#3736465
Reply To: Having No Routine

The President just reported success with the malaria drugs and sited a specific episode where a guy was dying from Covid-19 and had been both written off and had said...
--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 23, 2020 at 10:33 pm

#3736464
Reply To: DB Restore is very slow ....

Mmmmm... maybe. I've frequently seen where striped backups and restores actually take longer, just like parallelism can sometimes have adverse effects.
--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 23, 2020 at 4:58 pm

#3736354
Reply To: I was asked to get rid of this Dynamic SQL for performance purposes.

If you're going to make dynamic SQL for the WHERE clause, there's a right way to do it and using EXEC() is NOT the right way. Please see the following...
--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 23, 2020 at 3:53 pm

#3736304
Reply To: would like to know more about identity_cache

Steve Collins wrote:
Afaik and imo there are no pros only cons. There is no such thing as a "gap" in a primary key because 'unit consistency' is not a necessary attribute. ...
--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 23, 2020 at 3:43 pm

#3736299
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic
we all...
--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 23, 2020 at 3:33 pm

#3736290
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.
Now my FIL, I'm...
--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 23, 2020 at 3:28 pm

#3736283
Reply To: Having No Routine

There's really no difference for me. It's all kind of like the cartoon at the following link except I have a white beard. 😀
http://www.commitstrip.com/en/2020/03/19/stay-at-home/
--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 23, 2020 at 3:10 pm

#3736275
Reply To: Are the posted questions getting worse?

Shifting gears a bit, today's editorial on Routine has a broken discussion link. The editorial is all about the changes people are having to make because of recent world events. ...
--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 23, 2020 at 2:29 pm

#3736240
Reply To: Select Group Members from Logins

Since the code came out all on one line, please consider resubmitted where the code looks more normal. 😉
--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 23, 2020 at 2:16 pm

#3736236
Reply To: Partitioning Limits in SQL Server 2019

It's a little spooky that about half the people that have answered so far have gotten this one wrong. Not because it's partitioning but because people won't take the time...
--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 23, 2020 at 2:12 pm

#3736235

Viewing 15 posts - 7,501 through 7,515 (of 59,091 total)