Cute idea, but seems about as likely as porting SQL Server to Linux!

I can't wait to find some code or explanations from this article quoted back by copilot or some...

I'm a little surprised nobody has pointed out one of the biggest problems with AI-generated code:  it can be flat-out wrong and give no indication of any uncertainty.

            
March 7, 2023 at 3:17 am
            
#4157501

            
            
                                                
        

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...

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...

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...

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...

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...

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...

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...

Hi,

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....

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...

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...

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 :-

Always exciting to see a new article from The Jeff Moden and a guarantee to learn something new.  Thanks for sharing!

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...