Bestest
If we want to start this post in the right place, we have to go back to 2009. That was the first time a (much) young(er) Erik Darling wrote dynamic SQL that didn’t suck.
There was a terrible piece …
SQL Server Consulting, Education, and Training
If we want to start this post in the right place, we have to go back to 2009. That was the first time a (much) young(er) Erik Darling wrote dynamic SQL that didn’t suck.
There was a terrible piece …
You know and I know and everyone knows that stored procedures are wonderful things that let you tune queries in magickal ways that stupid ORMs and ad hoc queries don’t really allow for.
Sorry about your incessant need …
Parameters get a bad name. It seems everything that gets sniffed does, whether it’s a stored procedure, a piece of anatomy, or an illicit substance.
Once you stop worshipping memes, you’ll find that things aren’t always …
Some events:
event_name memory_grant_feedback_percentile_grant memory_grant_feedback_persistence_update parameter_sensitive_plan_optimization process_killed query_optimizer_nullable_scalar_agg_iv_update spinlock_backoff sql_exit_invoked tsql_feature_usage_tracking
A bunch of stuff:
package_name | event_name | description | ||
---|---|---|---|---|
qds | automatic_tuning_query_check_ignored | Fired when APRC decides to not track a query that is marked as ignored | ||
qds | automatic_tuning_wtest_details |
Here are new lines from the query transformation stats view in SQL Server 2022:
+--------------------------------+ | name | +--------------------------------+ | BuildDataExportPut | | BuildRemotePut | | EnforceDistribution | | FetchXcs | | GetToFetchXcs | | ImplementDistribution | |…
Here are new sys.configuration entries in SQL Server 2022:
+------------------------------------+-------------------------------------------------------------------------------------+ | name | description | +------------------------------------+-------------------------------------------------------------------------------------+ | Data processed daily limit in TB | SQL On-demand data processed daily limit in TB | | Data processed weekly limit…
Here’s a list of new error messages in SQL Server 2022:
text The external policy action '%.*ls' was denied on the requested resource. The user does not have the external policy action '%ls' or permission '%.*ls' to perform…
What does it all mean? We’ll have to find out!
+--------------------------------------------------------+-------------------------------------+ | object_name | column_name | +--------------------------------------------------------+-------------------------------------+ | backup_metadata_store | backup_finish_date | | backup_metadata_store | backup_metadata_uuid | | backup_metadata_store | backup_path | | backup_metadata_store | backup_size | |…
Here’s a list of new system object columns in SQL Server 2022!
+----------------------------------------+------------------------------------------------+ | object_name | column_name | +----------------------------------------+------------------------------------------------+ | all_columns | is_data_deletion_filter_column | | all_columns | is_dropped_ledger_column | | all_columns | ledger_view_column_type | | all_columns | ledger_view_column_type_desc…
SQL Server 2022 was released today, so I’m digging around looking for new stuff. I’ll provide what details I can as I go, but it’s brand new so 🤷♂️
Here’s a list of new system objects for you to …