https://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx Forced Unit Access (FUA) Forced Unit Access (FUA) occurs when a file is opened (by using CreateFile) with the FILE_FLAG_WRITETHROUGH flag. SQL Server opens all database and log files with this flag. The flag in...
這可利用 Transact-SQL 陳述式或資料庫應用程式開發介面 (API) 函數來指定。 系統也必須能夠正確地處理交易完成之前便結束交易的錯誤。 如需詳細資訊,請參閱<Transaction 陳述式 (Transact-SQL)>、<ODBC 中的交易>和<SQL Server Native Client (OLEDB) 中的交易>。 依照預設,會在連接層級管理交易。 在連接上...
Index design basics General index design guidelines Metadata Clustered index design guidelines Show 7 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric Poorly designed indexes and a ...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. ...
You can download the whitepaper from the Download section of the SQL Server I/O Basics, Chapter 2 article. If you use advanced format disks that are physically formatted with 4,096 bytes, but expose a logical sector size of 512 bytes, you can read more about the behavior and...
SQL Copy CREATE INDEX IX_Document_Title ON Production.Document (Title, Revision) INCLUDE (FileName); GO If you're following along with the code examples, you can drop this index using this Transact-SQL statement:SQL Copy DROP INDEX IX_Document_Title ON Production.Document; GO ...
Index design basics General index design guidelines Metadata Clustered index design guidelines Show 7 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric Poorly designed indexes and a ...
Rolling upgrade basics for availability groups Rolling upgrade process AG with one remote secondary replica Show 5 more Applies to:SQL Server When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or ...
Locking and row versioning basics Locking in the Database Engine Lock granularity and hierarchies Show 13 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric In any database, mismana...
This QuickStart is for users new to Power Pivot in Excel or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data