Viewing 15 posts - 9,211 through 9,225 (of 59,078 total)
It's likely that it's a version thing then, and certainly, likely to be 2014+ since that's when the cardinality estimation engine changed. Funny enough, Pinal's advice is the opposite...
May 30, 2019 at 11:20 pm
if I set "set STATISTICS IO on" , and execute one SQL Query statement it shows as below, can you say it took 1767*8kb memory when runing this state...
May 30, 2019 at 11:01 pm
No problem. Thanks for the question and the feedback.
May 30, 2019 at 10:56 pm
Some people are of the opinion that if you have to go back and forth a few times in email then you are better off picking up the phone...
May 30, 2019 at 6:59 pm
Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the...
May 30, 2019 at 6:25 pm
Ok...
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions....
May 28, 2019 at 7:49 pm
I treat Dev systems exactly the same way that I treat prod systems. Being able to restore to a point in time has save a lot of lost work many...
May 28, 2019 at 1:55 pm
16 is the total memory and 12 is assigned to sql.
How big is your largest clustered index?
May 25, 2019 at 2:02 am
Concerning the risk of injunction in the SQL code, I'm thinking of putting a right which prevents deleting the data from the database. What do you think?
Totally inadequate. Either...
May 25, 2019 at 1:55 am
I have used data janitor often for other IT people asking.
BWAAA-HAAAA!!!! I have told people that when it comes to data, "I'm the cleaning lady... but I don't do...
May 24, 2019 at 11:31 pm
Heh... I could tell that you weren't offended and were probably having a pretty good guffaw while writing it and, yes, absolutely, you and Sean are outstanding heavy hitters on...
May 24, 2019 at 2:09 pm
Not sure but, since you went from 2008 R2 to 2017, you're also in the realm of the "improvement" they made to the "Cardinality Estimator" (which happened in 2014, IIRC). ...
May 24, 2019 at 2:01 pm
Hi All, Thanks for the replies. I have considered aligning the indexes with the partition scheme but as you mentioned Frederico, this requires tuning of the queries using the...
May 24, 2019 at 1:57 pm
Just curious...
May 24, 2019 at 12:53 pm
Very cool testing (especially with the ancillary tests) and feedback, Maria. As has been said "One GOOD test is worth a thousand expert opinions" (Werner von Braun). I've not...
May 24, 2019 at 12:36 pm
Viewing 15 posts - 9,211 through 9,225 (of 59,078 total)