What is the unique clustered index on that table?  If the table is never written to - how did the data get in the table in the first place?  A...

Thanks for the response, Jeffrey.  If you go to the first article I provided a link for and then search for "A/B", that 3 character link will take you...

Maybe I am reading a different article - but what you linked to is actually worse.  This article *recommends* REORGANIZE as the primary method to be used and then links...

Run the query: Select * From sys.endpoints

Look at the principal_id column - if that column is not a 1 (for the sa account) then the endpoint was configured to use...

You cannot upgrade a standard/enterprise edition with the Express SP3 download.  You need to download SP3 for standard/enterprise and run that against the other instances.

If you run the query that...

Change it to greater than or equal:

Where t.Date >= cast(dateadd(day, -5, getdate()) As date)

If the data type of t.Date is a datetime - then you would want...

You are adding the header row with the UNION - remove that and convert the actual select statement to include the separator designation.  You are then removing that header row...

When you run that code - there should be a message returned.  What is the message that is being returned?

It doesn't really make sense - there is no third row from your sample data and there could never be a gap on the first or last row in a...

Here is a basic template:

    Set Nocount On;

Declare @query nvarchar(max) = ''
      , @recipients varchar(max) = 'user1@domain.com'
  ...

Does it have to be an Excel file - or does it just need to be able to be opened in Excel?  If the latter - you can use sp_send_dbmail...

Although you cannot create additional indexes on the read-only secondary, you can create ETL/ELT type processes that extract data from that read-only secondary into a separate database.  This won't be...

This can be simplified to:

   With gapData
     As (
 Select *
      , NextBegNum = EndNum +...

What is the data type of the ship_date column?

You define the variables @sdate and @edate as date - but then set them to a datetime value.  If the column ship_date...

As pointed out - for these types of questions it is preferable that you post sample data.  I have put something together - assuming you really do have a BegNum...