Browse the archive
Changing a column from int to bigint has gotten a lot easier since I started working on SQL Server back at the turn of the century. SQL Server 2016 introduced the ability to do ALTER TABLE...ALTER COLUMN as an online operation using the WITH (ONLINE=ON) …
Continue readingQuestion For example, I had a database and I want to see which physical backup file was used to restore into it. The problem is that the database was deleted. How can I see the record? Asked2019-11-23bysql-noob Answer Depending on how the database was …
Continue readingEducorreia is using GitKraken with GitHub, and needs some help navigating the licensing & edition differences to make that combination work with private repos.
Continue readingQuestion 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 the following query to move this Log file from …
Continue readingQuestion 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 when to …
Continue readingTobias asks if it matters where Windows places its page file on a SQL Server server.
Continue readingUserSteve is having trouble restoring an encrypted database backup to a new server. I try to walk him though the steps of getting the necessary encryption keys on the destination server.
Continue readingI was fiddling around with some data, looking at making a quick aging report. I probably should have reached for Power BI Desktop, but sometimes I can be stubborn, and I wanted to get my T-SQL to work–if nothing else to figure out how to make it work.
Continue readingHussain Akbar is creating a custom app, and is wondering if he can run both his production Web & SQL Server instances on the same Windows 10 machine to save on licensing. I don't like the sound of running the database on a web server.
Continue readingQuestion 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 unique key that works?
Continue reading
