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 …
Tag: Performance
SQL Server IF Branches And Query Performance Part 4: Do Stored Procedures Work?
Sub Sub
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 …
SQL Server IF Branches And Query Performance Part 3: Local Variables Still Suck
Blip In The Wall
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 …
New Extended Events Stuff In SQL Server 2022
I am a heading
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 |
New Query Transformation Rules In SQL Server 2022
Brand New
Here are new lines from the query transformation stats view in SQL Server 2022:
+--------------------------------+ | name | +--------------------------------+ | BuildDataExportPut | | BuildRemotePut | | EnforceDistribution | | FetchXcs | | GetToFetchXcs | | ImplementDistribution | |…
New System Configurations In SQL Server 2022
Brand New
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…
New Error Messages In SQL Server 2022
Brand New
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…
New System Object Column Names In SQL Server 2022
Brand New
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 | |…
New System Object Columns In SQL Server 2022
Brand New
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…
New System Objects In SQL Server 2022
Today!
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 …