Stack Exchange

Question I need to let MySQL to check the uniqueness of a VARCHAR column which is 5000 max length and is not the primary key. I can use an index of length 500 on the column to speed up query, but how to create an … [Read More]

Question This is a hypothetical question, that flows from the answer by sepupic where they explain that 2TB is the physical limit for SQL log file. if you need it more than 2Tb you add the second log file. I have long held the belief … [Read More]

Question I have SQL server 2017. I have one 3 TB size database there. Somehow due to long running transaction the database got stuck ‘IN Recovery’ mode after SQL server Restarted. When I checked the sql error logs it says 2 189 255 seconds remaining … [Read More]

Question Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are all grayed out, so that’s really. It an option. Any thoughts? Thanks… asked 2019-01-05 by Kevin Wilkie Answer You don’t restart Managed Instance. The beauty of … [Read More]

Question What is the most efficient way to determine whether row or page or columnstore compression (or none) would be most effective for each index in an Azure SQL Database (standard or premium tier) used for OLTP, where sp_estimate_data_compression_savings is not supported? I realize that … [Read More]

Question I want to install Microsoft SQL Server LocalDB 2017 on my system. I downloaded SQL Server Express Setup (about 5.1 MB). Then I opened it and chose ‘Download Media’ option and then chose LocalDB. Then it downloaded SqlLocalDB.msi setup (about 45.9 MB). I ran … [Read More]

Question We’re working on migrating some SQL Server VMs to Azure SQL Managed Instances. We did an initial backup/restore without a problem: After doing testing, we now need to do a fresh restore from our SQL VMs. We started doing the same process we initially … [Read More]