/explore
|
You are here 
|
kendralittle.com | ||
| | | | |
www.purplefrogsystems.com
Query Store is a fantastic feature of both SQL Server and Azure SQL DB. It allows you to monitor how queries execute against the database which is invaluable for troubleshooting performance issues. More than that though, it gives you the option to force an erratic query to use a particular execution plan, this helps avoid queries from running with inefficient plans and provides predictability and stability on the server. Here we can see an example of a query that hasn't been forced and the engine is free to execute it however it sees fit, as you can see, the variation... |
|
| | | | | ||
| | | | |
littlekendra.com
Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps. |
|
| | | | | ||
| | | | |
curatedsql.com
[AI summary] The article discusses the new PRODUCT() function in SQL Server 2025, which multiplies values in datasets rather than adding them, similar to other functions but with distinct operations. |
|
| | | | | ||
| | | | |
kendralittle.com
Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps. |
|
| | | |||
