I'd say this is one of the few cases where EAV is actually a reasonable normalised design. You aren't using it for the things the system itself is likely to...

Given that Microsoft seem to have taken to recommending the equi-join style when using graph tables and the MATCH operator, I think it's highly unlikely they're going away any time...

It rather depends on how your tool is attempting to list SQL servers. Often they attempt to connect to the SQL Server Browser service, which means it needs to be...

If you're going to be following a course I'd install SQL Developer Edition (it's free for non-production use) and Visual Studio 2017 Community Edition (also free for these kinds of...

You can wrap calls to ParseExact in If statements to exclude cases you don't want to try and check. What have you tried that isn't working?

Both will work, though I personally prefer the explicit BEGIN/END pair on any IF statement, if only because somebody will come along later and ask the same question about whether...

TVFs are definitely the preferable option, INSERT-EXEC is something of an anti-pattern and has a bunch of drawbacks aside from the nesting one you're experiencing here. You can't always avoid...

It's worth bearing in mind that the shrinking currently is probably only harming your database. You delete a month of data and then reload it - that reloading will be...

If you're just trying to refresh the summary data and don't want the calculation times to impact queries, consider building the new summaries in a separate table and then using...

I think this will do it:

with X as
(
select id, max(R) over (order by id, R) as maxR
from #Data
),
Y as
(
select...

It can be done with sys.database_permissions, athough I'd be inclined to fail a code review for any developer that drops and creates an object without having a script to correctly...