Backup speed is almost entirely limited by disc throughput speed so you need to uderstand the limits of your disc system. Some suggestions and places to look:

a) Backup always to...

There is no good reason can think of, and since the constraint names in your case appear to be system generate my bet would be that at some...

Not sure why you want a stored proc for something like this but here goes

What TABLE are you trying to uypdate - you select from one name, and then try...

You cannot create view with the same name as a table. You will have to choose a different name ofr the view, or create th eview in a different schema...

This is down to to language (and hence date format) options.

The OUTPUT of dates and assumptions as to valid INPUT forms are controllable separately.

"set dateformat" will allow youto...

No differences at all as far as I have ever found.

Mike

Making columns nullable actually costs you 1 bit per nullable column, so non_nullable will actually save you some space - albeit only a little - so your premise about making...

Sorry - No.

By defintion triggers in SQl Server fire once per statement, and by examining the virtual tables inserted and deleted should be written to process all rows affected by...

I would also consider checking what data can actually be entered in the table and review if you really need Nvarchar rather than varchar. If you have no need of...

I have never known a situation where any db file was deleted incorrectly by SQL Server. Most likely is someone deleted them manually either when the service was not running,...

If you re-read the BOL entry you will see it is behaving exactly as defined. I think you may be confusing a rollback of a named transaction (which is what...

The file is constantly open by the sql server process, even if no-one is actually using it at that moment (Unless you have enabled auto-close which I would NOT normally...

Windows event viewer is probably the easiest otion - Are you new to Windows as well as SQl Server? If so you may find you need to read up on...

While what you have may work at the momenet the statement:

SELECT @newrecflag=newRecFlag FROM stg_tempEmp

still worries me - what happens if there are many rows in stg_tempemp?

Mike...

I think you may have spotted it. The trigger will indeed fire when zero rows are retrived in the example you post. Triggers always fire once per statement and the...