Do you mean you want to have all the PST values for each...

You will find you get much better performance if you split the merge into two separate statements (an update followed by an insert).

Performance Tip: The conditional behavior described for the MERGE...

Empty file by migrating the data to other files in the same filegroup

Migrate all data from the specified file. This option allows the file to be dropped using the ALTER...

If you are worried about shrinking the datafile then the standard advice is to create a new datafile and migrate the data into it.

It looks like the entire program could be changed to be a single SQL statement. If you are using SQL Server 2012 or higher you could use the LAG function....

SELECT sqltext.TEXT,
       req.session_id,
       req.status,
       req.command,
    ...

If you press F7 in SSMS you can select multiple tables and script the create for all of them, in one go.

You would then have to edit the script but...

Regarding @jonathan-ac-roberts 's test: you might want to include a GO between the two test queries. It might not make a difference, but I have found that quite...

Is it because you are looking up on a different column: ponum instead of po_num 

select po_num from poitem_all
where poitem_all.ponum not in (select po_num from preqitem)

It may or may not use the index. It depends on whether the optimiser thinks a full table scan will be more efficient than a seek with a key-lookup. An...

Well, I got to the first line of the article "Database UPPERCASE". I just wondered why you should have a database in uppercase? What if it consisted of 2 or...

The execution plan is recommending you create the following indexes:

CREATE INDEX IX_DM_NOTF_CHG_EVNT_1 ON [DNB_MDM_MON].[dbo].[DM_NOTF_CHG_EVNT_ATTR]
(
    [NOTF_CHG_EVNT]
)
INCLUDE
(
    [ELMNT_XPATH],
    [CHG_TYP_ID],
 ...

Change the query to this:

SELECT a.notf_chg_evnt AS notf_chg_evnt, 
       a.notf_btch_dtl_id AS notf_btch_dtl_id, 
       a.chg_detct_time AS...

45 minutes or more doesn't sound unreasonable for a table that big, but it also depends on the hardware, particularly the disk.

I use this to get active SQL statements.

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
CONCAT(req.total_elapsed_time/1000,' secs') elapsed_secs,
CONCAT(req.total_elapsed_time/1000/60,' mins') elapsed_mins
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS sqltext

It also gives the amount of CPU each statement...