DBA Stack Exchange

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]

Question I’m stuck in a way that how to do sum on a column let’s say first column of a table (result from another query) without knowing the column name with something like column position id. it’s something like this Or if it’s in single … [Read More]

Question I’m noticing this wait stat on my Azure SQL database, and I’ve never seen it before. I’ve tried Googling this wait stat but haven’t been able to come up with any good information on what this is, although I saw a couple mentions of … [Read More]

Question I have a SQL database that is hosted on Azure. The problem is that the size is getting out of control, I can see up to 99% fragmentation in the Primary Key clustered indexes. I’m able to rebuild all other indexes with online=on option … [Read More]

Question Is there a simple way to reconnect a query window that is “not connected” to the original connection that was used by that query without manually picking the server name needed? If I click the Connect button on the SQL Editor toolbar or right … [Read More]