DBA Stack Exchange

Question In quite a bad position here. This afternoon on my tempDB I ran the query: sp_helpfile to locate where my MDF and LOG file were. My MDF was on my C: drive and my LOG file was on a D: drive so I’ve run … [Read More]

Question For example, if I hit the sys dynamic views to select a specific query plan, am I able to insert that query plan into another database’s plan cache, that runs the same exact query? (I know the query is hashed and compared to determine … [Read More]

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 We are planing to migrate an on-premises SQL Server db to AWS RDS SQL Server. My only concern is how can I create a linked server from AWS RDS SQL Server to on-premises SQL Server db? Is it possible? I am checking it because … [Read More]

Question I have came across several articles that mentioned that advise on not to store monetary value as decimal, but use integer instead. The reasoning that it does not store actual value and will cause some rounding difference/errors. But i have yet ever participate in … [Read More]

Question How do I go about pausing transactional replication on the subscriber end. We have a publisher on Server A, a distributor on Server B and a subscriber on Server C. All are in the same network. Some background, we have quite a busy BizTalk … [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]