Viewing 15 posts - 1 through 15 (of 109 total)
I am here with Brian Gale. For me it is more a commercial than a technical post.
I would love to see the incoming statements on the database side.
e.g.
January 27, 2024 at 8:43 am
I suspect that you wanted to describe something else with your article but not the benefits of MIXED vs. UNIFORM extents.
January 10, 2024 at 7:50 am
Although this topic came quite late to my attention it is more actual than ever. I see lots of people favorite sequential INT/BIGINT as PK but - as Jeff has...
July 24, 2020 at 8:29 am
Hi Stuart,
WHY would you not recommend partitioned heaps? Can you give reasons for your rejection?
July 10, 2020 at 10:45 am
Hi Steve,
I trapped into the pitfall and didn't see that the last query was not using any predicate 🙂
If you use a query with a predicate it will create a...
July 9, 2019 at 7:30 am
Although this article is over 3 years old I came around by accident today. Very interesting and - to be honest - I didn't had it on the focus so...
May 11, 2018 at 2:30 am
Hi Jeff,
THREADPOOL is definitely a problem of a heavy used system with lots of requests at the same time. To fight against it I would of course check the...
December 19, 2017 at 6:22 am
Hi Kev,
" Can anyone explain the discrepancy between max_workers_count and the calculation as I presented it here?"
You can set the max number of threads manually (basically not...
December 19, 2017 at 5:36 am
November 3, 2017 at 6:59 am
Thank you David,
i can only repeat the others; very interesting. I will definitly use this as a good example for uneven configured multiple database files 🙂
November 3, 2017 at 3:00 am
Thank you all for your positive feedback.
I love to create QotD with a bit more "substance" from my real world experiences.
I will try to write more of them in the...
January 6, 2017 at 10:43 am
MMullane-222251 (1/5/2017)
Uwe, do you have a test showing that creating a Clustered Index wouldn't improve the execution plan?
Hi,
of course you can test it with a clustered index on one or...
January 5, 2017 at 1:49 pm
Thank you Carlo for your valued comment. Pleas take into consideration that your example is completely different from the original question. The usage of a variable in a batch will...
January 5, 2017 at 2:18 am
Koen Verbeeck (12/9/2016)
According to the official resource it's indeed Enterprise only.
Don't worry Koen,
forgiven - you are an expert for BI 🙂
December 9, 2016 at 1:25 am
Hi Koen,
NO - TDE is EE only. Extract from the official resource:
Feature | EE | SE | ..
TDE | Yes |...
December 9, 2016 at 1:15 am
Viewing 15 posts - 1 through 15 (of 109 total)