What I'd say about the backup approach is that it is better, but if you are changing this set of schema/data often, then this can be a pain point...

Shifting gears a bit, this is one of the many reasons why I'll make a call-to-arms when people say things like "Comments are not required... just read the code". ...

• This reply was modified 4 years, 11 months ago by Jeffrey Williams.

Also check the settings for the agent - the default doesn't keep a lot of data and just one job scheduled to run every few seconds can cause all other...

If your deployment requires data to exist as well as just the schema - then a base database as a backup file probably is easier to deploy.  Restore the database...

What is the reason you are concerned about those logical reads?  What issue are you trying to resolve - or is this just educational?

I doubt it has anything to do with user database transaction logs - and 400 VLF files on a 188GB transaction log isn't too many.  Unless my math is wrong...

As I stated before - there is something preventing the redo queue on the secondary from performing as expected.  It could be blocked by other processes running or there is...

If all you need to know is when the data changed - then adding a modified date column and possible a created date column (if you want to know when...

Where are you seeing logical reads?  How are you inserting data into the table?

If you are using a query - then that query must read the data, therefore you are...

As it's written, it returns either a NULL or and empty string.  I think someone forgot to complete the 2nd operand of the substring, which should probably equate to...

Well - this code is going to do something a bit different than what Steve outlined, depending on the actual data in the PortionKey column.  If there are leading blanks...

When do you see the redo queue size growing - and does it ever catch up?  When you have large transactions - such as index rebuilds - the amount of...

Jeff, one of the best things I ever heard about comments is this:

Comments don't exist to describe what the code is doing.    They exist to describe what...

Is there a reason you have 2 queries - both look to be updating the same table and updating all rows in that table.  Could be done using a single...

Okay - here is something for you to review:

Declare @xref Table (base_equip_address int, office_app_address int, x_pbase int, region int, port int, poll int);
 Insert Into @xref (base_equip_address,...