GitHub

Derived tables and common table expressions.sql

Note: Views get saved in the database, and can be available to other queries and stored procedures. However, if this view is only used at this one place, it can be easily eliminated using other ...
Ars Technica

SQL Server 2000 T-SQL: Temp tables/derived tables - some basic help please

I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.<BR><BR>Now the resulting data set will be about 10,000 records taken from ~ 8 ...
TechRepublic

Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...
GitHub

Work around SQL Server's peculiar UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables - Merge [#16938]

lukaseder changed the title Work around SQL Server's buggy UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables - Merge [#16938] Work around SQL Server's peculiar UNION with ORDER ...
Microsoft

Hekaton: SQL Server’s Memory-Optimized OLTP Engine

Hekaton is a new database engine optimized for memory resident data and OLTP workloads. Hekaton is fully integrated into SQL Server; it is not a separate system. To take advantage of Hekaton, a user ...