Viewing 15 posts - 241 through 255 (of 59,039 total)
GENERATE_SERIES() has a "little" problem for me. I generate shedloads of test data and the following problem means that I'll not be giving up the fnTally function any time soon...
November 22, 2024 at 2:44 am
Crud. I just did a code review where this happened and forgot about it when I answered here. 🙁
And great question, BTW!
November 22, 2024 at 2:26 am
I don't know how many people need the precision Jeff sees issues with.
People seem to be missing the point here. The simple fact is that it...
November 22, 2024 at 2:21 am
Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?
I posted a take at the following...
November 22, 2024 at 2:18 am
Stop rebuilding indexes.
Microsoft's documentation states:
Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should...
November 21, 2024 at 8:22 pm
Thank you Jeff - I'd never tried that in all my years since SQL Server V7.0
You bet. I hope that's one thing that they'll never change.
November 21, 2024 at 2:54 pm
I'm doubtless being inexpressibly dim but I don't know what "It depends on whether results are in the grid or text" means.
In SSMS, you have a choice of displaying...
November 21, 2024 at 2:38 pm
Thank you! I was reading about the CE possibly being the problem. I did check some of the queries and they were individually set to CE to 70. I...
November 21, 2024 at 1:18 am
Since you say the updates are not "extremely frequent", it's mostly an "Insert" index by TenantID. It's a Type 98 Index and since there aren't a large number of ExpAnsive...
November 21, 2024 at 12:58 am
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...
November 20, 2024 at 7:42 pm
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...
November 20, 2024 at 1:50 am
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...
November 20, 2024 at 1:32 am
And it doesn't matter which version of SSMS or SQL Server you're using.
November 20, 2024 at 1:07 am
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...
November 20, 2024 at 1:05 am
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...
November 19, 2024 at 5:58 pm
Viewing 15 posts - 241 through 255 (of 59,039 total)