Queue table issues with Availability Groups in SQL Server
I recently came across an issue in a SQL Server Availability Group scenario where queries against a heavily-used queue table were taking longer and longer over time.
2020-02-11
Additional Articles
The Dangers of using Float or Real Datatypes
Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
2020-02-11
Storage 101: The Language of Storage
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
2020-02-10
Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
2020-02-07
Performance Tuning Means 3 Things
Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.
2020-02-07
Efficient Solutions to Gaps and Islands Challenges
Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.
2020-02-06
Updates to the Deployment Suite for Oracle
Redgate has added new capabilities to the Deployment Suite for Oracle, so it now supports automated migrations-based and state-based Oracle deployments on both Linux and Windows. They've introduced Redgate Change Control, a new capability for understanding development changes, generating migration scripts for version control, and getting precise control over the migration path during automated deployments. Our Schema Compare and Data Compare for Oracle command line tools have been extended to Linux as well as Windows, and we’ve added static code analysis that encourages teams to follow good coding practices on Windows or Linux.
2020-02-06
Custom Deployments from Source Control using SQL Compare Command line
Giorgi Abashidze explains how his team use a 2-phase deployment process with SQL Compare Command line, and some SQL Synonyms, to automate custom deployments for each of their customers, while only needing to maintain one branch per release in source control.
2020-02-05
Load Time Series Data with SQL Server
In this article we look at how to load time series data into SQL Server both for an initial load as well as adding new data.
2020-02-05
Building SQL Server Indexes in Ascending vs Descending Order
In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.
2020-02-04
Blogs
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers