...to alert us if the backups failed. Is this possible?

No.  But you can alert yourself if a successful backup did not occur.  [There is a subtle distinction.]

For example, adjust the...

LEFT is for character data only.  You need to use SUBSTRING instead.

...
SUBSTRING(bp.sort_path, 1, DATALENGTH(@CurrentSortPath))
...

Did you try 'EXECUTE AS USER ='?  Would that help you here?

SQL itself will automatically update stats when it determines that it needs to.  By default, that will use sampling.

You can force SQL to stick with a FULLSCAN unless someone explicitly...

CREATE TABLE #data (
    col1 varchar(10) NOT NULL,
    replication_count int NOT NULL
    )
INSERT INTO #data VALUES('abc', 5),('defgh', 3),('xx',...

There's a technique callled "Tally table" that is perfect for doing that.  A tally table is simply a table with a single column containing 1, 2, 3, ....  The beauty...

Glad it helped out!  Thanks for the feedback.

Hmm, you need explicit code -- great, that's what we're here for -- but you didn't give us:

table DDL (this is what we really need, not just a table name...

I've always liked the idea of assigning a unique standard alias for every table and always using it.  You can add a 1, 2, etc., if you need...

• This reply was modified 4 years, 8 months ago by ScottPletcher.

For performance, first try converting it into an inline TVF; those get compiled directly into the code whereas a multi-line TVF does not.

SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF
GO
CREATE...

D'OH, sorry, didn't realize SQL wouldn't let you OFFLINE the db in that case.  But, one of the reasons I avoid SINGLE_USER like the plague is the issues it causes.

You need to make sure that TABLOCK is specified on the load so that you get minimal logging.  I'm not 100% sure how to do that via SSIS but look...

Again, I'd say create the clustered index before loading the table.  Use row compression, since that could save some I/O which would reduce the time needed.

Are other processes  using "SELECT...

What specifically do you mean by that?  What error message did you get?

CREATE TABLE ##temp_table_order#s ( id int NOT NULL PRIMARY KEY, data_field varchar(8000) );
INSERT INTO ##temp_table_order#s
SELECT id, data_field
FROM ##temp_table
WHERE data_field LIKE 'Order #%'

SELECT
    Order_No,
 ...