SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
11,935 reads
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
11,935 reads
A while back, I was building the database schema for a web application which had some reporting functionality and among other things, I had do implement logic in the...
2017-04-19
6 reads
When it comes to a choice between data types for a field in a SQL Server database's table, an issue...
2017-02-06
2,090 reads
When it comes to a choice between data types for a field in a SQL Server database's table, an issue that is frequently discussed in popular forums is a...
2017-02-06
10 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
211 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard Atom or RSS feeds containing any data that you...
2017-01-18
5 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
178 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
1 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
9 reads
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
812 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