Then, as I stated before, you would need to put an UPDATE trigger on that table.

One trigger could handle all of the numeric, date, etc. columns in a table.

The triggers...

(1) Does the original table have an IDENTITY column?  Or a added_date column?

(2) Is the original table compressed (page or row compressed)?

(3) Have you checked to see if compression would...

Best guess, without any other details, is to cluster the dbo.BCPDailybalmasterydaily table on ( processdate, acctno ).  If those columns are not unique and there's an identity column on that...

This depends on your use of the sequence.  If you use the sequence often, you will want a larger cache.  If less often, a smaller cache makes more sense.

Also, be...

If, for example, you're trying to determine that, say, an int value is nearing 2,147,483,647, then you could use an UPDATE trigger for that.

If not along those lines, then, as...

It's likely safer to use sp_cycle_errorlog rather than running DBCC ERRORLOG directly.  The user must have sysadmin authority for using sp_cycle_errorlog.

IIRC, typically that error means that the file is locked,...

...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, 9 months ago by ScottPletcher.