New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,364 reads
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,364 reads
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...
2018-02-27
16,650 reads
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
737 reads
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...
2018-03-07 (first published: 2018-02-23)
2,079 reads
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...
2018-03-05 (first published: 2018-02-20)
10,636 reads
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...
2018-01-25
497 reads
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
2,174 reads
This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered...
2017-12-11
39,212 reads
“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of...
2017-12-21 (first published: 2017-12-09)
33,862 reads
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
738 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
Comments posted to this topic are about the item What is Delayed Durability in...
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