New posts in T Sql

Alternatives to running query for rarely changed data everytime on large table

Bad performance using "NOT IN"

How to create Unicode parameter and variable names

ADD PERIOD FOR SYSTEM_TIME on table failed

SQL Server injection - how much damage in 26 chars?

what is the best practice for tempdb autogrowth?

WHERE vs. HAVING on non-aggregate columns. Advantages / Disadvantages / Irrelevant?

Is there any (hidden) built-in function on MS-SQL to unquote object names?

Using INSERT INTO...EXEC AT linked server into temp table fails with Msg 7391

How to pivot on multiple columns in SQL Server?