Try a space, not a -, between dd and hh.

Run!

Code first is great for rapid prototyping but it gets to the point where some traditional OO analysis and database schema design needs to be done.

Baselining is a large topic so you might want to look at third party tools. This may get you started:

https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

https://www.sqlservercentral.com/articles/perfmon-using-sql-server-performance-counters

To get a log backup there must have been at least one full backup...

I would be interested to see how you do that. I suspect it would require...

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

This is not possible. You will need a bak...

RTFI

Denies a permission to a principal. Prevents that principal from inheriting the permission through its group or role memberships. DENY takes precedence over all permissions, except that DENY does...

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

Maybe:

WITH Lags
AS
(
    SELECT P.Code, X.DataPassaggio, P.idServizio, P.up
        ,LAG(idServizio) OVER (PARTITION BY P.Code, X.DataPassaggio ORDER BY P.DataPassaggio) AS...

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

DDL? Test Data? You have enough points to know this.

You did some calculations...

You should explicitly cast the results to the type you want - presumably not float.

It depends!

Your other options are Hierarchyid or nested sets.

https://learn.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-ver16

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-1-convert-an-adjacency-list-to-nested-sets

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

Security can also be done in SQL Server with RLS.

I am not a SSIS expert but with regards to authentication methods:

1. Windows Authentication will be more secure especially if you can use Managed Service Accounts. The downside can...

2. Sign a SP for permissions in another Database.

/* Only works with DML */
USE <main_db, sysname,>;
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
CREATE OR ALTER PROCEDURE <schema_name, sysname, dbo>.<proc_name, sysname,>
AS
SET NOCOUNT,...

1. Sign a SP for permissions within the same database.

USE <Main DB, sysname,>;
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
CREATE OR ALTER PROCEDURE <schema_name, sysname, dbo>.<proc_name, sysname,>
AS
SET NOCOUNT, XACT_ABORT ON;

RETURN;
GO

GRANT [rights]...