If you’re working with compressed indexes, SQL Server provides a system stored procedure to help test the space savings of implementing data compression: sp_estimate_data_compression_savings. Starting in SQL Server 2019, it can even be used to estimate savings with columnstore. I really don’t like sp_estimate_data_compression_savings. In … [Read More]
Question I have a stored proc spGetSites that returns three columns for SiteName, SiteId and UnitCount. The stored proc runs perfectly fine. I’m trying to store the results of the stored proc to a temp table @Site to use for my report with below syntax. … [Read More]
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) … [Read More]
Question 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? asked 2019-11-23 by sql-noob Answer Depending on how the … [Read More]
Educorreia is using GitKraken with GitHub, and needs some help navigating the licensing & edition differences to make that combination work with private repos.
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]
Tobias asks if it matters where Windows places its page file on a SQL Server server.
UserSteve 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.
I 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 … [Read More]
Copyright © 2025 | Andy Mallon | am2.co