Ooh, right.  I tired to change the sort because you formatted BatchDatte to mm/dd/yyyy which will not sort correctly.

SELECT DISTINCT 
    BatchID, EDIProviderSort,
    CONVERT(varchar(10), BatchDateConv, 101) AS BatchDatte,
    DName

FROM UPSBatchInvNo

CROSS APPLY (
    SELECT...

SQL Server doesn't store, and thus doesn't know, the "last accessed date" for each db.

After SQL starts, when any index is accessed, an entry for that db and index is...

The first two are not full but don't have room to expand by the specified amount.

Alter the first two files to have a maxsize of their current size.  That will...

with testCostTable([Period], [Category], [Value]) as (

Also, the column names used are all SQL Server reserved words.  That's something many SQL developers find annoying :).  In my...

What's the best way to know which index statistics need to be updated on a daily basis?  I currently update stats on Friday, but I've noticed SQL is...

That seems about right.  I'd say also consider doing tables every day that get a manual update in 2 days' time; they're close enough to once-a-day anyway to me.  "Better...

SELECT ca.name, ca.nentry
FROM (
    SELECT
        SUM(CASE WHEN '.' + contents + '.' LIKE '%[^A-Za-z]bull[^A-Za-z]%' THEN 1 ELSE...

The Windowing functions tend to be extraordinarily efficient, so I'd do the request this way:

SELECT DISTINCT f.[Id] AS [FormId], ver.[FormVersion]
FROM @forms f
LEFT OUTER JOIN (
  ...

In a CASE <condition> THEN <result>, the <result> must be a single value (technically called a "scalar" value).  Not allowed are SQL keywords or operators (>=, <) as part of...

"Tell" SQL to always use a full table scan for those indexes that need it.  Do that by running this one time at your convenience:

-- index_name is optional, of course

UPDATE...

If necessary, you could even add a DDL trigger as a failsafe to make absolutely sure that user doesn't create (or drop) any tables in that db.

Grant the user the db_datareader and db_datawriter roles, etc., using the commands below.  You can ignore any errors except those dealing with the user's name:

ALTER ROLE db_datareader ADD MEMBER [your_user_name_here];

ALTER...

1. No.  You simply cannot restore a backup created in a later version of SQL to an earlier version.  You'd have to use some other method of moving the db...

Exactly.  I used a CASE in a SUM but not instead of a PIVOT, so...