Viewing 15 posts - 4,666 through 4,680 (of 59,067 total)
You have 14182 total plans in your cache, with 100.00% plans created in the past 24 hours, 98.00% created in the past 4 hours, and 98.00% created in the...
September 8, 2021 at 6:00 am
That's an interesting point. Sp_BlitzCache told me a top priority was plans being built daily, but our server is not really taxed. I will check the indexes as well....
September 8, 2021 at 5:49 am
You've been around long enough to know and have been advised before (April 2020) that you need to post some real DDL for such problems. Please read'n'heed the article at...
September 7, 2021 at 3:20 pm
And on a fun note, this site isn't loading for me in Edge either. It just serves up blank pages. Not sure what's going on with that either.
I just...
September 7, 2021 at 3:13 pm
depending on number of columns on that table you may need (and it may be advisable) to resort to have a hash column added and make this column...
September 7, 2021 at 3:06 pm
as a developer, I am sure you will appreciate my next question............any chance you can provide set up scripts for your tables and sample data, please...? (Not everyone is...
September 7, 2021 at 5:57 am
Any index that is rebuilt also rebuilds statistics which will cause recompiles for any stored procedures that use the indexes.
Also, you should stop using REORGANIZE. It doesn't work the way...
September 7, 2021 at 5:52 am
Just to bump this question again because it's a great question, I second this question!
September 7, 2021 at 5:32 am
I believe that I'd have to bring the newly constructed 4 banded pork chop launcher into play if anyone did such a thing because there ae a huge number of...
September 7, 2021 at 5:14 am
If a TSV (Tab Separated Values) file or a CSV (Comma Separated Values) file that can be used by Excel is "good enough", you don't need Crystal Reports or SSRS,...
September 7, 2021 at 5:09 am
Create a unique index on all the columns and make that unique?
For 2014 and earlier, the limit for key columns in an index is 16 unless you have at...
September 7, 2021 at 4:57 am
Step 1 would be to do kind of what you say. Capture the queries that use the table and the column. Then, look at them and remember that the OP's...
September 7, 2021 at 4:33 am
Ah... be careful. Changing the clustered index on the quick fly could cost you everywhere else.
September 6, 2021 at 11:39 pm
What other useful DBA reports do you suggest? Maybe something we would run every month or so to check that our environment is configured/running optimally. We have these...
September 5, 2021 at 6:18 pm
Rod. Do you have a description that you can share of the particular "Analysis Paralysis" instance that you're talking about?
I ask because I've seen a huge number of articles that...
September 5, 2021 at 5:24 pm
Viewing 15 posts - 4,666 through 4,680 (of 59,067 total)