timestamp issue with SQL server #13. Copy link. Description. apeesel. opened on Oct 28, 2014. Issue body actions. My table definition reads: CREATE foreign TABLE ...

As of 2023-11-10 it is not possible to conduct CDC on memory-optimised table. Accroding to microsoft docs. SQL Server 2017 CU15 and higher support enabling CDC on a database that has memory optimized ...

In Dynamics NAV 2016, you may have noticed that a new field has shown up in the development environment: Timestamp. We mentioned this in the What’s New topic in the MSDN Library, but here is a bit of ...

This article discusses how we can use Serilog to log structured data to a SQL Server database. To work with the code examples provided in this article, you should have Visual Studio 2019 installed ...

You can also use distributed transactions whenever there's SQL Server to SQL Server communication and changes will be made to data during the course of the transaction, often done via a linked server.

In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance. You should ...