Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]
2019-11-18
2,635 reads
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
932 reads
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,262 reads
By Steve Jones
One of the newer features in Data Masker for SQL Server is the ability...
Yesterday in this post I described a method to correct permissions when upgrading a...
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Comments posted to this topic are about the item Numeric and Decimal, which is...
For some reason I'm unable to create another log file. Ideas? ALTER DATABASE [DBNAME]...
One of our machines is not able to connect to sql server It gives...
Ask SSC