In-Memory OLTP introduces memory-optimized tables and natively compiled stored procedures in SQL Server. This article gives an overview of query processing for both memory-optimized tables and natively compiled stored procedures. The document explains how queries on memory-optimized ...
Temporal tables Create and manage Getting started Create Modify data Query data Security Change the schema Stop system-versioning Usage scenarios Consistency checks Partitioning Considerations & limitations Retention of historical data Metadata views & functions ...
System tables Transact-SQL (T-SQL) Reference Transact-SQL (T-SQL) Reference Date & time hierarchyid methods (database engine) Numeric String & binary Spatial geography & instances (geography Data Type) Spatial geometry & instances (geometry Data Type) Data types XML DBCC Functions Language element...
System tables Transact-SQL (T-SQL) Reference Transact-SQL (T-SQL) Reference Date & time hierarchyid methods (database engine) Numeric String & binary Vectors Spatial geography & instances (geography Data Type) Spatial geometry & ...
I need to know more about how SQL Server Agent Job history and the supporting queries. I need to access the applicable data stored in the MSDB database system tables. What T-SQL queries can I issue to access this data to improve decision making?
In-Memory OLTP introduces memory-optimized tables and natively compiled stored procedures in SQL Server. This article gives an overview of query processing for both memory-optimized tables and natively compiled stored procedures. The document explains how queries on memory-optimized tables are compiled ...
Force or disable scale-out execution of PolyBase queries that are using external tables inSQL Server 2019 Big Data Clusters. This hint is only honored by a query using the master instance of a SQL Big Data Cluster. The scale-out occurs across the compute pool of the big data cluster. ...
For example, a SQL Server data source supports both the graphical and text-based query designers. By query language variation. For example, a query language such as Transact-SQL can differ in syntax depending on the data source type. The Microsoft Transact-SQL language and the Oracle SQL langu...
It *is* possible to up the limit of 16 in SQL 6.5 by setting traceflag -T105. This is an undocumented and unsupported trace flag, so Microsoft may not support you with any problems on a system that is running this. However, it was allegedly put into the product to allow some of the...
Adding temporal system-versioning to tables that are frequently modified by your OLTP applications. In any of these scenarios apply the following workflow: Run your workload with the Query Store before the planned change to generate performance baseline. Apply application change at the controlled momen...