Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,516 through 7,530 (of 59,098 total)

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
Reply To: Collections: Crossing intervals computed gaps

How is the performance for a large data set?
--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 12:57 pm

#3736208
Reply To: Sql to oracle replication

Interesting... thanks, Frederico.
--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:50 am

#3736148
Reply To: Sql to oracle replication

I'm not sure how the use of CDC will help you replicate to Oracle.
--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 12:43 am

#3736135
Reply To: What does the NULL file type mean in this query?

Post removed... I misread the code. See Jacob's post below.
--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 22, 2020 at 8:43 pm

#3736116
Reply To: Sql to oracle replication

Jeffrey Williams wrote:
Jeff Moden wrote:
Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side). The last...
--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 21, 2020 at 9:25 pm

#3736057
Reply To: Room booking system - calculating room occupancy

I recommend that you onvert that spreadsheet to actual INSERTs to a table to help us help you. Please see the first link in my signature line below for details.

--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 21, 2020 at 9:22 pm

#3736056
Reply To: SQl Stored Procedure - View Tuning

pdsqsql wrote:
Thank you Frederico.
Completely agreed with that view will be the issue as joining multiple tables and using some function which slows down the process.
But didn't not much fully understood...
--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 21, 2020 at 9:08 pm

#3736052
Reply To: SQl Stored Procedure - View Tuning

frederico_fonseca wrote:
downloading the plan from the link does have all the info as far as I can see, including predicates.
That would explain it... I didn't download the plan.
--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 21, 2020 at 8:00 pm

#3736050

Viewing 15 posts - 7,516 through 7,530 (of 59,098 total)