DBA Stack Exchange

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 My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup transactional replication between on-premise server (publisher) and azure sql db. Then we … [Read More]

Question We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References. We need Project references, since Otherdatabase, can choose between two options at our company. Most of the time, its 90% … [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 have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server 2012 R2 hosted in a Hyper V … [Read More]

Question At what size should we consider applying Columnstore Index on a table? Is there a SQL Server storage or design guidance? Our Data Warehouse is 5TB total. Additionally, we have tables which are 100GB to 1TB which compose the database. Just curious if SQL … [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]