While not clear, it seems as though you have a database in FULL recovery which has not had a log back in 3 or 4 years. The log file must...

• This reply was modified 1 year, 6 months ago by Ken McKelvey.

I would look at dynamic sql as well.

DECLARE @FilterId int = 4;
WITH CityTypes
AS
(
    SELECT City, [State], CityType
    FROM dbo.SampleData S
 ...

-- Create a login with a strong password
CREATE LOGIN [NewUser] WITH PASSWORD = 'StR0nG_p@ssW0rd!';

I am not sure SQL Server authentication represents best practice but I suspect it...

We had a cyber incident (sic) late last year and it was actually our ISP who picked up the problem. I doubt AI was involved as I think they found...

If your databases are only being backed up to Veeam, I presume you are automating test restores from Veeam and running DBCC CHECKDB...

FROM OPENJSON (@JSON, '$.acc_div')

SELECT n_type
,COUNT(1) AS Total
,SUM(IIF(d_type = 'a_type', 1, 0)) AS a_type
,SUM(IIF(d_type = 'b_type', 1, 0)) AS b_type
,SUM(IIF(d_type = 'x_type', 1, 0)) AS x_type
FROM @temp
GROUP BY n_type
ORDER BY n_type;

Ken's code is nice, but theoretically I believe it could yield a false positive if the previous month happened to be 13 months prior to the current month.  For...

WITH MonthCheck
AS
(
    SELECT mainhost, enter_date
        ,IIF(MONTH(enter_date) - 1
         ...

• This reply was modified 1 year, 8 months ago by Ken McKelvey.

Looking at this again the following is probably better:

WITH cte_Employee (EmployeeId, EmploymentTypeId, DateId)
AS
(
    SELECT EmployeeId, EmploymentTypeId, DateId
    FROM
   ...

You would make your life easier if you stored dates as dates. This is an Islands and Gaps problem. One solution:

WITH cte_Employee (EmployeeId, EmploymentTypeId, DateId)
AS
(
  ...

https://www.sqlservercentral.com/forums/topic/a-brief-explanation-and-solution-for-the-double-hop-problem

Run Ed B's code.

In future, provide a test rig and test answers before answering. If you do not know how...

I prefer migrations but have used in-place upgrades to buy time until there are the resources to look at a more managed upgrade. The trick is to have lots of...

I'll try to answer the questions all in one post here.

1. I'm not posting the full DDL of objects because there are only 2 views that are joined.  However,...