A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).
Always on\Database...
2017-03-21
1,523 reads
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
485 reads
Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...
2017-03-06
2,598 reads
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,846 reads
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can...
2017-02-07
561 reads
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,477 reads
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,042 reads
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...
2017-01-16
566 reads
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
475 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
401 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