Just was looking at that really long single line SQL and was trying to make it more pretty and there is some goofy stuff happening in your query. I see...

My opinion - that REALLY depends on the company. For example, if you have a license for SQL Prompt, I would recommend grabbing that.

But as a bare minimum, for a...

It is not likely you are going to find someone who will download a random zip file from someone to help with something like this. A better solution is to...

True... Could you have the page break in as an expression that depends on how many rows are in the main report? What I mean is if the main report...

Offhand I am not certain, but is it possible in the parent report (the one that will contain the sub-report) to put a page break before the sub-report?

I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it...

My opinion - a developer shouldn't need to run a trace. That's a thing a DBA should be doing. If the developer needs a trace run, the DBA should initiate...

Just to reply to both Jeff Moden and Seketon567 - I do agree that Fox was ONE of the places reporting on it, but I heard about it elsewhere. A...

Weird question but did you upgrade from a previous version of SQL (2017 or older) to 2019? If so, your maintenance plan MAY be in a previous version format that...

one thing you could try is to change @json table variable to a permanent table. That way you can read the response from the WEB API call.

Now, that being said,...

Have you checked the official docs:

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16

From there you can see what User Scans is showing you - Number of scans by user queries that did not use 'seek' predicate. So...

I would start by not following the news from Fox, but that's just a personal bias against Fox News. I would check tech news sites like the register (for example)...

The other thing that helps is once you do the presentation at least once, you get a feel for what parts engaged the audience and what parts were boring and...

The way things are set up in my environment, IT doesn't let me auto-generate my SPN's. I can't even make the SPN's. I need to put in a support request...

Have you tried googling the error? There are a lot of pages on google with similar errors such as this one:

https://dba.stackexchange.com/questions/188833/sql-linked-server-returning-error-suddenly-upon-query

In that scenario, the problem was a faulty NIC.

I recommend...