Jeff Moden

Forum Replies Created

Viewing 15 posts - 331 through 345 (of 59,099 total)

Reply To: Best Clustered Index Configuration for Partitioned Multi-Tenant Table with RLS

Jonathan AC Roberts wrote:
Jeff,
Have you got any recommendations for the fill factor when I create the new clustered primary keys on (TENANTID, ID)?
Where ID is an identity column on the table.
Yes. And...
--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)

November 20, 2024 at 7:42 pm

#4486710
Reply To: A Design Question using a fictious example

Using your fictitious example, if you have the correct indexes in place, the code can be designed to do a seek to the correct row in "Grades" based on 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)

November 20, 2024 at 1:50 am

#4486277
Reply To: Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing

Allenii02 wrote:
If my SQL 2014 instance was in 2012 compatibility mode, could the upgrade to SQL 2016 resulting in the DB upgrading to 2016 compatibility mode be causing the many...
--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)

November 20, 2024 at 1:32 am

#4486275
Reply To: A Strange Result

And it doesn't matter which version of SSMS or SQL Server you're using.
--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)

November 20, 2024 at 1:07 am

#4486267
Reply To: Best Clustered Index Configuration for Partitioned Multi-Tenant Table with RLS

Jonathan AC Roberts wrote:
Does partitioning by TENANTID improve query performance when most queries are filtered by tenant? For instance, will partitioning reduce the amount of data SQL Server scans, or is it...
--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)

November 20, 2024 at 1:05 am

#4486266
Reply To: Fill in missing hours for each VisitID during the day

NineIron wrote:
You make a good point. We need to keep counting hours for the VisitID until we get a DISCHARGED status.
Without saying it quite that way, that's been my whole...
--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)

November 19, 2024 at 5:58 pm

#4486086
Reply To: Pivot Help

Howdy and welcome aboard!
Please see the article at the first link in my signature line below for how to post "Readily Consumable Data" to help us give you the best...
--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)

November 17, 2024 at 8:04 pm

#4485065
Reply To: Fill in missing hours for each VisitID during the day

Before I can give the demo I promised above, I need to know what the condition of the real table is.
In your example data, you have a DATE datatype column...
--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)

November 17, 2024 at 3:42 pm

#4484997
Reply To: Need help with GROUP BY...

It would be real helpful it you listed the datatypes for the columns you are working with and pasted what the exact error message was.
--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)

November 16, 2024 at 8:01 pm

#4482767
Reply To: Need help with GROUP BY...

Duplicate post. Don't post here... post at the following link so we can keep any answers in one spot.
https://www.sqlservercentral.com/forums/topic/need-help-with-group-by-2
--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)

November 16, 2024 at 7:58 pm

#4482764
Reply To: Table Delete

Jeff Moden wrote:
@ Bruin,
Which edition of 2016 do you have? Standard or Enterprise?
Also, are there any FKs that are pointing AT this table?
--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)

November 15, 2024 at 5:52 pm

#4482332
Reply To: Table Delete

@ Bruin,
Which edition of 2016 do you have? Standard or Enterprise?
--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)

November 15, 2024 at 5:48 pm

#4482330
Reply To: Fill in missing hours for each VisitID during the day

NineIron wrote:
It is possible that the patient entered the ER on a previous day. However, I'm focused on one day in order to work out that piece. I don't think...
--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)

November 15, 2024 at 5:40 pm

#4482328
Reply To: Fill in missing hours for each VisitID during the day

I don't have a beef with the data provided. I'd rather have "too much" than not enough.
I just need an answer to my previous question. 😀
--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)

November 14, 2024 at 8:40 pm

#4481884
Reply To: Fill in missing hours for each VisitID during the day

Silly questions on my part because the likely answer is "Yes" to both of my questions but, I've got to make sure...
In your given example, is it possible that any...
--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)

November 14, 2024 at 6:43 pm

#4481851

Viewing 15 posts - 331 through 345 (of 59,099 total)