As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):
Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...
2016-10-13
3 reads
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
297 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
225 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...
2016-10-12
5 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those tables that stored the history of row changes (sometimes...
2016-10-11
7 reads
If you've ever designed a database you've most certainly run into the need for what we called history tables, those...
2016-10-11
429 reads
Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data Compare v7.0.0 – v9.0.0
Description: Using xSQL Schema Compare and xSQL Data...
2016-10-06
417 reads
Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data
Compare v7.0.0 – v9.0.0
Description: Using
xSQL Schema Compare and xSQL Data Compare to keep the tables of two databases
in sync...
2016-10-06
8 reads
Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0
Summary: When adding databases to the workspace both in xSQL Schema Compare...
2016-09-21
10 reads
Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0
Summary: When adding...
2016-09-21
331 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers