"What happens if the DB is already part of AG and I enable TDE on the DB on primary? How does TDE work in that situation?"

SQL Server encrypts the database...

Define the column names of the derived table when specifying the derived table's alias:

SELECT * INTO #TEMP_Entry 
  FROM (SELECT DISTINCT 
    ...

Synology NAS devices support creating and exposing iSCSI LUNs, allowing you to map a local drive or mount a folder to the storage on the device. I have a little...

Open transactions at the time of an AG failover experience the same thing as they would when you force the database offline or the server crashes: those transactions will be...

You can only encrypt a database that exists and is fully recovered. Restore only re-paints the disk pages as it copied them from the source database.

Either encrypt the database before...

You can't reference Action values in the predicate. Here are the values on which you can filter:

-- What Predicates (fields on which we can filter) are available?
SELECT...

• This reply was modified 6 years, 6 months ago by Eddie Wuerch. Reason: Changed all JOINs in the final query to LEFT JOIN due to ALTER DATABASE commands being captured by the trace

You can solve this problem in the JOIN clause, by JOINing the tables #minmaxvals and tablea on a range:

/* matches original query, rows that match MinVal and...

String manipulation (such as concatenating lots of small strings into a big one) is messy under the covers; avoid when possible.

SQL Server treats carriage returns and line feeds as text...

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:

Eddie Wuerch
MCM: SQL