As stated, we really need a query plan.  But this is always true: instead of "(select count(...) ...) > 0" you can just do an EXISTS check.  You don't really...

If you can count on the values being the same length and/or there are only a very limited number of length variations, you could just SUBSTRING the data from the...

I do know that trick, and have used it myself,...

Here's an alternative method, just for the heck of it:

SELECT 
    begin_time, end_time,
    LEFT(end_time, ISNULL(NULLIF(LEN(end_time) - 2, -1), 0)) * 60...

SUM(Revenue) OVER( PARTITION BY Region, Year, Month )

Oops, seems not to be the case.  You just need to set max mem.  Maybe I'm remembering from an earlier version of SQL?!

I thought SQL only locked SQL pages in memory if the max and...

If you do create a tally table, page compress it at 100 fillfactor.  That will save significantly on the overhead of reading the table.  And, since that table is static,...

In SQL Server, the CASE WHEN/THEN results are scalar (single) values only: keywords, operators, etc. are not allowed.  Thus, you need something more like below.

Edit: That said, the expressions within...

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

SQL works based on tables.  By definition, a SQL Server table must have a name.

To look at my own version of this:

SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)

The VALUES clause is...

Nvm, OOPS, I posted this same code earlier.

SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
GO
ALTER FUNCTION [DP].[GetYears] ( @StartYear AS INT )
RETURNS TABLE
AS
RETURN
WITH
tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
tally1000 AS (
 ...

• This reply was modified 4 years, 11 months ago by ScottPletcher. Reason: Added SETs before function code

I have always found this to...

After the 30 days, move them to some type of historical table.  Personally I would never permanently delete such data.  Compress it to the max and it will take very...

DECLARE @StartYear SMALLINT = 2017;

SELECT  DATETIMEFROMPARTS(@StartYear + number, 1, 1, 0, 0, 0, 0) AS StartDate,
        @StartYear +...