SELECT 
    SUM(CASE WHEN t.create_date BETWEEN @v_from_date AND @v_to_date THEN t.max_column_id_used ELSE 0 END) AS tables_created,
    SUM(CASE WHEN t.modify_date BETWEEN @v_from_date...

In certain cases or usage situations, SQL Server will require a primary key.  One reason is that a primary key is guaranteed to be unique and non-NULL (that is, by...

Can you explain further why you want to allow this user to enable/disable system versioning?  As far as I am aware - the only reasons to temporarily disable versioning...

No.  Performance-wise they are exactly the same.

To get durations beyond 12 hours, I think you can just do:

WHERE h.run_duration > 120000

If the proc as an appropriate "EXEC AS" clause, I would think it would work.

Yes, in theory you should be able to use just a WHERE clause and "HAVING COUNT(*) < 3", but I don't like to assume that there aren't duplicate description entries.

Also,...

SELECT ID
FROM ExampleTable
WHERE Description IN ('Apex', 'BILL', 'SIERRA')
GROUP BY ID
HAVING MAX(CASE WHEN Description = 'Apex' THEN 1 ELSE 0 END) = 0 OR
    MAX(CASE...

• This reply was modified 2 years, 6 months ago by ScottPletcher. Reason: Add WHERE clause to perhaps improve efficiency

I think adding the WeekDay and Hour columns to the main table make the most sense.  Computed columns will be more efficient than a trigger, but they do have some...

The current approach seems ok to me, as long as people are rigorous about changing the status to "Declined" or "Cancelled" if the day can't be taken as scheduled.

Acceptable, perhaps.  But can you name any major RDBMS...

It's possible that creating your own statistics would help SQL here, but without more details, it's impossible to say what stats to create.

;WITH cte_last_visits AS (
    SELECT client_id, 
        MAX(visit_date) AS last_visit,
       ...

For SQL 2017 (or SQL 2016, for that matter), only if for some odd reason you've set MIXED_PAGE_ALLOCATION ON and/or allowed...

Acceptable, perhaps.  But can you name any major RDBMS that uses...