Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.
iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.
Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]
In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance
DevOps continues to improve the way we build software and Steve has a good example in today's editorial.
Learn how to get started using a container to run PostgreSQL, or really any other RDBMS, including a gotcha to watch out for.
In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.
I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the reboot to ensure they were up. I verified all SQL Services and […]
A recent issue with malware and SQL Servers has Steve wondering if you would detect a new, and unapproved, login added to an instance.
You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.
Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
I’m excited to announce the release of a new open-source project that fully automates...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Change Tracking Data Retention Options
Comments posted to this topic are about the item Requiring Technical Debt Payments
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers