Compression Performance with Low Key Selectivity
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
8 reads
Mr Fox SQL
- Interests: Databases, DW, BI, AI, ML, SQL, Visualisation, Streaming, Architecture, Security, Automation
- Skills: Anything Data, AI, ML or Analytics in the Cloud (Azure or AWS)
- LinkedIn: https://www.linkedin.com/in/rolftesmer/
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog]
I had a question at work recently where there was some confusion around how SQL...
2016-03-02 (first published: 2016-02-24)
2,642 reads
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...
2016-02-24
7 reads
A “Business Intelligence” (BI) Definition
[read this post on Mr. Fox SQL blog]
Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions...
2016-01-19 (first published: 2016-01-11)
2,770 reads
SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.
SQL Saturday is an excellent free learning...
2016-01-18
685 reads
SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016. SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are...
2016-01-18
4 reads
A “Business Intelligence” (BI) Definition
[read this post on Mr. Fox SQL blog] Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions using the Microsoft BI solutions stack. In all of...
2016-01-11
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...
2015-11-30 (first published: 2015-11-23)
1,470 reads
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...
2015-11-23
3 reads
Implementing Partition Aware Index Optimisation Procedures
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major...
2015-11-09
1,160 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL...
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers