Viewing 15 posts - 1 through 15 (of 325 total)
Martin, that would have been the best option, but unfortunately views doesn't allow table hints.
May 13, 2022 at 3:45 am
Thanks Phil. Seems like a good idea...will give it a try
March 16, 2022 at 11:41 am
Since we have NO previous knowledge of your tables and how they're used, we need specifics to make any reasonable judgements. It's rather frustrating when we ask such things...
April 9, 2021 at 6:29 am
We have dedicated Sr. People for optimization and they have been doing it for more than a decade for some good clients. So we trust their understanding...
April 9, 2021 at 5:40 am
I still have my doubts on the clus index keys. But you could be right.
By the way, are most of the tables clustered on an IDENTITY column? If so,...
April 9, 2021 at 5:37 am
(1) As always, the first step is to make sure you have the very best clustered index on every table of significant size. That is not an easy thing...
April 8, 2021 at 6:29 pm
Some of my queries return upto 15 million records which gets pushed to a temp table.
Does not look like a good choice of querying strategy.
It's never a good...
April 8, 2021 at 6:23 pm
Grant, yes we have indexes on temp tables wherever needed.
I'll deep dive into wait stats and see if I could get some help.
Besides this, is it also possible that I...
April 8, 2021 at 12:27 pm
I mean , we don't face high CPU, Memory or IO latency.What kind of issues do you face then?What's the bottleneck which makes your procedures slow?
I mean , we don't face high CPU, Memory or IO latency.
What kind of issues do you face then?
What's the bottleneck which makes your procedures slow?
The issue we...
April 8, 2021 at 12:02 pm
My eyes sparkled when I saw "Grant Fritchey" replied my post. I have been a big fan of your books and thank you very much for your elaborated response.
April 8, 2021 at 11:54 am
Can you expand a little on what the 'sessions' are?
How should one 'session' know what the other sessions are doing (so that they don't have any overlapping or missed...
October 27, 2020 at 5:27 am
Thanks for sharing your learning Mike. it was very helpful/
But my DB has is_parameterization_forced =0 and still clustered index scan is happening. The filtered index is not being picked. Still...
August 15, 2020 at 2:31 pm
So, what you are saying is you create procedures that are tested in development, and when moved into production, various issues cause them to perform poorly, or cause incorrect...
January 13, 2020 at 12:14 pm
For now, I have came up with this as I couldn't find a nice way to achieve it:
Create Proc MytestProc_V1 @DebugFlag bit =0
If @DebugFlag =0
Print 'You are running the proc...
January 7, 2020 at 10:27 am
If the procs don't contain DML, what do they contain?
ok, let me elaborate a bit more.
The idea that I am working on, is to add a debug flag as...
January 7, 2020 at 5:56 am