Strange Issue of waittype – PREEMPTIVE_OS_GETPROCADDRESS
ISSUE : Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server...
2015-06-02
910 reads
ISSUE : Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server...
2015-06-02
910 reads
The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2015-05-25
688 reads
The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2015-05-25
967 reads
Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for...
2015-05-25
852 reads
Steps of Moving MSDB & Model SQL Server system Database to new locaation:-
1) Check current location of MSDB & Model Databases by...
2015-05-18
3,265 reads
Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure,...
2015-05-19 (first published: 2015-05-11)
5,619 reads
The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes...
2015-04-27
5 reads
The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes...
2015-04-27
3 reads
The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since...
2015-04-27
7 reads
The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2015-04-27
685 reads
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
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