As far as I understand it, SQL compiles the plan before it executes.

When you use a variable, SQL compiles a plan for an unknown value.

When you use a fixed...

Ha! Thanks. I'll see if we can do it. We only had yesterday and today to play a little.

For something like this, assuming no other objects involved, it's not a view, you're not running some kind of monitoring, then, my suggestion is as follows. You have very little...

This could be so many different things it's going to be hard to give you an answer. First of all, you haven't stated what you're doing. Is this a SELECT...

I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub...

I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub...

Just so you know, the only people who will see this, and maybe provide some answers, are ones who already subscribe to this thread, or find it by accident. If...

This situation was quite the train wreck. First blush, I kind of felt bad for the organizers. I understand the struggle to get a diverse rost put together. Then, the...

Well, the first one is, I'm guessing, being worked on by someone, somewhere. I don't know of any though.

The second one, yeah, I can help. Redgate Software, my employer, is...

I'm a very firm believer in the least privilege principal. You should be barely have enough access to get the job done. However, you should have enough access to get...

Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking...

So, probably, most of your scripts for looking at queries and query behavior use DMVs. Which were released in 2005. That means, those scripts won't work. If you want to...

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs to...

Presumably, that means a lot of Extended Events sessions outputing to the ring_buffers. Probably not the best way to go. Output to file is generally better. But, it does depend...