Not necessarily true. Indexes can also allow SQL to avoid a sort (and sorts are expensive operations).

For example:

Add a clustered index on id to the table.

Then this query should...

You'd have to use an INSERT trigger. It could be an INSTEAD OF INSERT or an AFTER INSERT trigger.

Yep. Save the system variables (@@) into local variables (@) after the relevant statement(s), then test the local variables instead of the system vars. Note that you need...

• This reply was modified 6 years, 9 months ago by ScottPletcher.

I didn't, and wouldn't, look at the links. But thanks for the heads-up on this poster.

You can have the db name in an ALTER, just not the server name (note the message says two prefixes, i.e., a total of 3 levels of object name). ...

• This reply was modified 6 years, 9 months ago by ScottPletcher.

You must add an ORDER BY clause to the query to get the rows to be in a specific order. But, the ORDER BY must also be in a...

For clarification, a SQL column does not have to be all the same type: SQL has a type of sql_variant that is designed to handle different data types in the...

You can only put columns in the OUTPUT clause from the INSERTED and DELETED table(s), if/when each is present.

Sadly, you can't use any column from any input in the query,...

• This reply was modified 6 years, 9 months ago by ScottPletcher.

;WITH
cteCalcBaseDates AS (
  SELECT DATEADD(MONTH, 7 - CASE WHEN MONTH(GETDATE()) < 8 THEN 12 ELSE 0 END,
  DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0)) AS Aug01,

The GROUP BY Entry Num should be enough:

SELECT H.Customs_Entry_Num,
  MAX(h.Total_MPF) AS Total_MPF,
  SUM(L.MPF) AS Line_Sum
FROM ADHOC.ATS_ESH H
INNER JOIN ADHOC.ATS_ESL...

Are your CPUs really busy on that server for some reason?

In my case, I have lots of free CPU, it's I/O that's restraining my system perf.

Wow, that seems way long for only 38 dbs.

Force SQL to not parallelize the query, and see how that runs:

SELECT
DB_NAME(database_id) AS db_name,
COUNT(*) / 128.0...