If parse and compile time is 20 ms, how long time takes recompile?

In Azure, we also have limited resources!

No, the plan for a procedures, functions, ... when then  execution cache is not big enough to hold all the plans - do you have a server that can keep...

No, it is NOT right! The function is created, so the comparison is only between execution of the 2 queries! If the  function don't have a execution-plan in the execution...

I do not agree with you. We have discussed it before and your focus is on IO. Your solution is much more cpu heavy if the statement is only rarely...

CREATE TABLE dbo.t
(
    TxtVARCHAR(8000)
);

INSERT dbo.t (Txt) VALUES
('A[CL]'),
('B[HQUW]'),
('C[1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ]'),
('D2'),
('E[1]');
GO
WITH Result
AS
(
SELECTLEFT(Txt, 1) AS Constant,-- all strings with [...]
SUBSTRING(Txt, 3, 1) AS Variable,
SUBSTRING(Txt, 4, LEN(Txt) - 4) AS...

Yes, it is not possible. But you can combine a clustered columnstore index with a nonclustered unique rowstore index or a nonclustered 'primary key'-index (an index create by specifying PRIMARY...

It's not that simple. There are a number of pitfalls that are dangerous. PRIMARY KEY or UNIQUE cannot be defined for the table. Foreign Key has some limitations. All some...

USE master;

GO

DROP DATABASE IF EXISTS TestDB;

GO

CREATE DATABASE TestDB;

GO

USE TestDB;

CREATE TABLE dbo.tblWeather

(

WeatherID   INT IDENTITY(1,1)  NOT NULL

CONSTRAINT PK_tblWeather PRIMARY KEY,

FK_BaseUnitID  INT      NOT NULL,

PrecipitationAmount DECIMAL(6, 2)   NULL,

DataTime   DATETIME    NOT NULL

);

GO

INSERT INTO dbo.tblWeather (FK_BaseUnitID, PrecipitationAmount, DataTime) VALUES

(27, 0.72, '17-Mar-2020 12:02:30'),

(27, 0.48,...

A possible solution!

"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. Justification of "easy" poor programming methods due to a low rowcount is a bad habit...

Yes I'm claiming low row counts and will never use Tally-solution with a problem with low row count. But tally is the right solution with high row count! I use different...

Yes I'm claiming low row counts and will never use Tally-solution with a problem with low row count. But tally is the right solution with high row count! I use different...