SQL Server 2016

  1. indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type ...
  2. Indexed views are supported only in the Enterprise Edition of Microsoft SQL Server 2000 or later. You have published one ...
  3. INDEXKEY_PROPERTY will be removed in a future version of SQL Server. Avoid using this feature in new development work, and ...
  4. Indicates a poison message was detected because there were five transaction rollbacks in a row on a Service Broker queue. ...
  5. Indicates an object has been altered (for example, by ALTER INDEX, ALTER TABLE, or ALTER DATABASE statements). Each DDL operation ...
  6. Indicates if the partition is a DirectQuery partition and, if so, whether the partition data can also be stored in the VertiPaq ...
  7. Indicates properties of existing user connections when trace was started. Server fires one ExistingConnection event per user ...
  8. Indicates sort operations that do not fit into memory. Does not include sort operations involving the creation of indexes, ...
  9. Indicates that a BEGIN TRANSACTION request has been completed. The request was sent from the client through Transaction Management ...
  10. Indicates that a BEGIN TRANSACTION request is starting. The request was sent from the client through Transaction Management ...
  11. Indicates that a cancel operation, client-interrupt request, or broken client connection has occurred. Be aware that cancel ...
  12. Indicates that a COMMIT TRANSACTION request completed. The request was sent from the client through Transaction Management ...
  13. Indicates that a COMMIT TRANSACTION request is starting. The request was sent from the client through Transaction Management ...
  14. Indicates that a full-text crawl (population) has started. Use this event class to check if a crawl request is actually being ...
  15. Indicates that a full-text crawl (population) has stopped. The stop could due to a successfully completed crawl or a fatal ...
  16. Indicates that a lock on a resource, such as a data page, has been released. The Lock:Acquired and Lock:Released event classes ...
  17. Indicates that a predicate joining two tables is not present. This can potentially result in long-running queries or inaccurate ...
  18. Indicates that a predicate joining two tables is not present. This can potentially result in long-running queries or inaccurate ...
  19. Indicates that a PROMOTE TRANSACTION request has completed. The request was sent from the client through Transaction Management ...
  20. Indicates that a PROMOTE TRANSACTION request is starting. The request was sent from the client through Transaction Management ...
  21. Indicates that a request for a lock on a resource, such as a page, has timed out due to another transaction holding a blocking ...
  22. Indicates that a request for a lock on a resource, such as a page, has timed out due to another transaction holding a blocking ...
  23. Indicates that a ROLLBACK TRANSACTION request completed. The request was sent from the client through Transaction Management ...
  24. Indicates that a ROLLBACK TRANSACTION request is starting. The request was sent from the client through Transaction Management ...
  25. Indicates that a SAVE TRANSACTION request has completed. The request was sent from the client through Transaction Management ...
  26. Indicates that a SAVE TRANSACTION request is starting. The request was sent from the client through Transaction Management ...
  27. Indicates that a task has been blocked for more than a specified amount of time. This event class does not include system ...
  28. Indicates that acquisition of a lock on a resource, such as a data page, has been achieved. The Lock:Acquired and Lock:Released ...
  29. Indicates that all legend items are shown in reversed order. This property only affects legend items automatically added ...
  30. Indicates that an exception has been encountered during a full-text crawl. The error will usually cause the full-text crawl ...
  31. Indicates that column statistics which would have been useful to the query optimizer are not present. This can cause the ...
  32. Indicates that errors have occurred in the Service Broker Transport layer. The error number and state values indicate the ...
  33. Indicates that report should be written to a file. If a file name is supplied, the reports will be written to that destination, ...
  34. Indicates that SQL Server could not produce an execution plan for a query or batch that contained a plan guide. SQL Server ...
  35. Indicates that the change in IP address resource dependency type for the SQL Server multi-subnet failover cluster is accepted. ...
  36. Indicates that the data file grew automatically. This event does not get triggered if the data file is grown explicitly through ...
  37. Indicates that the data file grew automatically. This event does not get triggered if the data file is grown explicitly through ...
  38. Indicates that the log file grows automatically. This event does not get triggered if the log file is grown explicitly through ...
  39. Indicates that the log file grows automatically. This event does not get triggered if the log file is grown explicitly through ...
  40. Indicates that the SqlClient, ODBC, OLE DB, or DB-Library has unprepared (deleted) a prepared Transact-SQL statement or statements. ...
  41. Indicates that Transact-SQL script with recommendations should be written to a file. If a file name is supplied, the recommendations ...
  42. Indicates that transactions for the subreport are merged with transactions for the parent report if the data sources for ...
  43. Indicates that two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources ...
  44. Indicates that two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources ...
  45. Indicates that values along this axis are scalar values and each data point should be positioned according to the X value. ...
  46. Indicates the GUID for the plan handle. This GUID can be used by sys.dm_exec_query_plan function for retrieving the execution ...
  47. Indicates the initial state, False for collapsed (+) or True for expanded (-), of the toggle image. The state can also be ...
  48. Indicates the level of compatibility for the string stores of the dimension which is used now or going to be used from the ...
  49. Indicates the level of compatibility for the string stores of the partition which is used now or going to be used from the ...
  50. Indicates the maximum number of rows to load in the map in the design environment. Decrease this setting to make the design ...
  51. Indicates the maximum resolution of this layer in the design environment. Increase this setting to make the design map more ...
  52. Indicates the number of retry attempts before the job is ended. This applies only when the job_failure_type field equals ...
  53. Indicates the number of seconds that the provider will wait for new data arriving from the package. The provider will return ...
  54. Indicates the number of statistics that were affected by the operation. This field is populated only when the status field ...
  55. Indicates the progress of an online index build operation. In most situations, the online index build process is a long running ...
  56. Indicates the severity of the error that caused the job to end. This applies only when the job_failure_type field equals ...
  57. Indicates when a cursor on an SQL statement has been recompiled either intentionally or due to a schema change or other event. ...
  58. Indicates when a prepared Transact-SQL statement or statements have been executed by SqlClient, ODBC, OLE DB or DB-Library. ...
  59. Indicates when SQL Server memory usage increases or decreases by 1 megabyte or 5% of the maximum server memory, whichever ...
  60. Indicates whether a connected state has changed between the principal, mirror, or witness in a database mirroring partnership. ...
  61. Indicates whether a margin is displayed between the first and last data point and the plotting area on the category axis. ...
  62. Indicates whether a static member appears on the same page with the closest non-hidden instance of the previous or following ...
  63. Indicates whether a static member is hidden when the data region contains no rows of data. The property overrides other visibility ...
  64. Indicates whether a static member is repeated on every page on which at least one complete instance of the dynamic member ...
  65. Indicates whether an attribute hierarchy is enabled for this attribute. If the attribute hierarchy is not enabled, then the ...
  66. Indicates whether changes made to individual columns by UPDATE operations will be tracked, and also indicates that the row ...
  67. Indicates whether dimensions that are unrelated to the measure group are forced to their top level when their members are ...
  68. Indicates whether existing objects on the destination server are dropped before the transfer. Integration Services applies ...
  69. Indicates whether minimum white space in containers is consumed or preserved when contents in containers grow. Only white ...
  70. Indicates whether processed data is available after all aggregations have been computed (Regular) or immediately after data ...
  71. Indicates whether processed data is available after all aggregations have been computed (Regular) or immediately after the ...
  72. Indicates whether processed data is available after all aggregations have been computed (Regular) or immediately after the ...
  73. Indicates whether processed data is available after all cached calculations have been computed (Regular) or immediately after ...
  74. Indicates whether the attribute can be aggregated in a hierarchy. The attribute hierarchy has an (All) level if is this is ...
  75. Indicates whether the attribute hierarchy is enabled on this cube dimension. This allows hierarchies to be disabled on specific ...