You can't - no concept of "order" in the data - unless there is some other column, in the table, that you...

Ditto ... so I'll bring my Billy...

What about if majority of messages are small enough to fit in-row? (I...

Tape Backup? (which has an "Agent" to backup SQL databases)

Update any rows that already exist, Insert any that are new.

Kristen-173977 (9/17/2015)

---

P.S. We have a "Lookup View" on each (main) table. This is basically all the regular columns from the table, and then any simple Code Lookup Descriptions etc. ...

P.S. We have a "Lookup View" on each (main) table. This is basically all the regular columns from the table, and then any simple Code Lookup Descriptions etc. just...

thinking_machine (9/17/2015)

---

Do you offer the ability to add text comments as to why an error cannot be fixed? If so, is that pushed out into a separate table, or as...

Worth looking looking at Brent Ozar's sp_Blitz, if you haven't already.

Good point. Worth double checking nothing else has changed? Fill Factor for example.

Sounds fine to me, we do something similar, only thing I feel strongly about is:

We don't do that. We have Create and Update date/time...

Luis Cazares (9/17/2015)

---

... so long as Personal Preference doesn't include the, 7x slower, MS provided one!!!

Lynn Pettis (9/17/2015)

---

Riddle me this, why do you refuse to answer the questions I have asked you? Are you afraid of the answers that you may to give? Are...

As Phil said, but here's a test if you want to try it:

USE tempdb

GO

PRINT 'Start: ' + db_name()

EXEC ('PRINT ''EXEC1: '' + db_name(); USE master; PRINT ''EXEC2: '' + db_name()')

PRINT...

Robert klimes (9/17/2015)

---

If you are referring to your logs growing during index maintenance, that is probably due to reorganization and not rebuild. A rebuild create a new index and reorganization...