A lot to unpack here and not entirely sure what you are trying to achieve, but will do my best to answer.

First, if you are deleting 30 million rows, you...

The third one is a fun one - open source dependencies. We have a tool that often has "free" plugins available for it but after a few years those free...

Just to confirm, you get that error when trying to PREVIEW the report on your local computer, correct? If so, are you using the correct VS version for the SSDT...

I've personally never used between and it is because of this exact QOTD - I can never remember for certain if it is inclusive, exclusive, or a mix and I'd...

I have also used heaps when the data has no real business value but someone requested the data to be captured because it may be needed one day by someone....

My big takeaway from your article was this bit:

But perhaps the most valuable insight was this: before touching MAXDOP, fix the query. In our case, adding a missing index and...

With the ad hoc queries as needed, a good monitoring tool should be able to capture some of those too. RedGate Monitor (formerly SQL Monitor) allows you to capture custom...

My advice - don't trust random people on a forum - trust the source. Check the Microsoft Docs:

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver17

Upgrading to 2022 requires a min version of 2012 SP4.

Now, that being said,...

Multiple tools means more systems to administer and more tools to patch which also means more man-hours to keep your environment up to date.

I much prefer to get all of...

Merge is generally a slow operation. I think if you are wanting fastest performance, your best bet is to grab all of the delta's that are going to be INSERTs...

You say that he doesn't have cases where he would have 3 or more values needed for calculating the average, but that is current state. What happens in 5 years?...

• This reply was modified 5 months, 1 weeks ago by Mr. Brian Gale.

Without seeing your data (or sample or DDL or DML), I'm just guessing here but I see this as a multiple problem thing.

First you want to know if you need...

My advice - sanitize the data before import. Use Excel to get the dates into one standard format (manual approach) if it isn't too time consuming. If it is too...

Just want to add that even with 1 big server, I still like to have a minimum of 2. That way you get failover. If the server/VM needs a reboot,...

Possibly a silly question Grant, but could you do that without the CTE? What I mean is something like:

SELECT (DATEPART(hh, sod.ModifiedDate) + 
DATEPART(mi, sod.ModifiedDate) + 
DATEPART(ss, sod.ModifiedDate)...