Viewing 15 posts - 1 through 15 (of 34 total)
I'm surprised Hugo hasn't already chimed in here, but everything about this question and answer choices is, at best, misleading.
What's stored in the plan cache is THE execution plan. It's...
March 10, 2022 at 12:07 am
The third option should say "Gives an unknown object type ERROR" otherwise you could assume (like I did) that you're saying that the sentence works and it gives you...
October 25, 2021 at 9:30 pm
Not quite the same situation, but it shares some similarities with this article, in which Brent Ozar uses views to implement deletes from very large tables to avoid memory grant...
October 15, 2021 at 6:26 pm
Just want to point out that while an OR clause is the simplest way to solve for this, it is not always the best way.
If you have an index on...
July 14, 2021 at 5:24 pm
Fun question, although the explanation could've been clearer. For anybody still confused:
For NULLIF, the first expression determines the data type. So in this case, everything is being implicitly converted to...
March 25, 2021 at 4:56 pm
Thank you for writing this article! It was nice and clear, but given that this is sqlservercentral.com I would have liked more of a direct comparison between how some of...
January 7, 2021 at 7:29 pm
The wording is confusing, but I believe the question is trying to ask:
"Given that SQL Server creates statistics for a primary key upon its creation, what will be the state...
November 10, 2020 at 7:30 pm
I noticed the author used an ID column of IDENTITY as the PK in every table. This appears to be a best practice based on what i've read online....
February 28, 2020 at 6:55 pm
Ha, I was going to say 3 too, same rationale as anthony.green. Then I saw Grant Fritchey was the author, and I've read enough of his recent posts to know...
February 11, 2020 at 6:16 pm
The data type of the values is not important here, as they can vary. The value of @j-2 will determine the casting. If the data cannot be implicitly...
January 13, 2020 at 4:31 pm
From the explanation link:
See also: numpy.loadtxt - equivalent function when no data is missing.
Good question, just not a good selection of answer choices :-
November 6, 2019 at 6:54 pm
Always exciting to see a new article from The Jeff Moden and a guarantee to learn something new. Thanks for sharing!
August 8, 2019 at 5:30 pm
How I know it's a Monday... I looked up all four trace flags and found that only one of them is known, so figured logically that had to be...
November 27, 2017 at 11:49 am
November 14, 2017 at 10:21 am
March 31, 2017 at 7:02 am