Filegroup Restoring and Join Elimination
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
2017-08-10
934 reads
Bogdan SAHLEAN
Filegroup Restoring and Database Consistency
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
2017-06-27
1,406 reads
Blogs
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
Forums
Tell The Name OF Most Beautiful Places In The World
I am an experienced tourist and always plan for visiting the Most Beautiful Places...
Fastest way to load a CSV file in SQL Server Table
What is the fastest way to load a file in SQL Server Table ?...
Replication question
Im an Oracle DBA by trade and been tasked with setting up transaction replication...
Ask SSC