System-Versioned Temporal Tables - A Case Study
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
1,846 reads
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
1,846 reads
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
1,850 reads
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
22,636 reads
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-03-03 (first published: 2009-10-07)
46,864 reads
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,541 reads
2009-05-19
12,783 reads
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Columnstore Index Limits in SQL...
Comments posted to this topic are about the item How to use Images in...
I work on sql server 2017 i have table data as below i need...