I'm guessing the value in Negozi.fk_responsabile points to the primary key in StrutturaOrganizzativa (StrutturaOrganizzativa.pk_id)

'pk' in relational databases often stands for 'Primary Key', and 'fk' often means 'Foreign Key'.

A Primary Key...

The OVER clause can be used on any aggregate function (sum(), avg(), etc.), and fits in well here:

SELECT PR.PRID, PR.PRSName, PR.PRLName, T.PID, T.SID, T.MDate, T.RType, T.PRT, T.Sec,...

The audit times are UTC.

The SQL Server log is in the server's time zone. Times will only match if the server's clock is UTC as well.

If I had to solve that problem, I would use partitioning much like you propose. Your approach uses two of the benefits available with partitioning - fast loading and fast...

Adding:

While there is no normal correlation between duration and cpu_time, the ratio between them measured and compared over time for a given query may establish a correlation if a query...

You can look up the description for the columns in an XE trace in the sys.dm_xe_object_columns view. For example, to view the column defs for the sp_statement_completed event:

            
October 23, 2019 at 1:15 am
            
#3691171

            
            
                                                
        

A row with no children means a row to which no other rows point (That row's ID is not stored in any other row's 'Parent ID'). If you're only after...

Set NEXT USED *before* doing the SPLIT.

-- The database name 'My SQLDB' has a space in it, so you must wrap the name in [brackets]
SELECT @SQL = 'BACKUP DATABASE ['+@DBNAME+'] TO DISK =...

SELECT db_name(database_id), * 
  FROM sys.database_mirroring 
 WHERE mirroring_state IS NOT NULL;

From the online documentation for sys.database_mirroring:

Contains one row for each database in the instance...

You need to shred the XML into a resultset of nodes using the XQuery .nodes method. Then you can address each <ST> block as a single unit.

Note: I added an...

Scheduling refers to how the operating system handles running threads from multiple separate processes on each CPU core. A CPU Core can only do one thing at a time. If...

From a fragmentation point of view, there's no difference. If you run a shrinkfile after either dropping or truncating those tables, you will have fragmentation, and the same fragmentation either...

You have a few options.

Before considering them, I highly advise restoring a recent backup to the target 2016 system WITH NORECOVERY, then execute RESTORE WITH RECOVERY so you can see...

• This reply was modified 5 years, 2 months ago by  Eddie Wuerch.

You can connect to Heroku PostGres from an external client: "...except for private and shield tier databases, they are accessible from anywhere and may be used from any application using...