Question I have a publisher with the distributor on the same server which is transactional replication. There is also an active subscriber using push method. I need to set a new subscriber up going to a different server using the same articles as the current … [Read More]
Question Is there a way to force all database and log backups run on the server to be encrypted? If encryption is not specified, the query will be terminated. asked 2021-09-12 by Avi Answer Not in SQL Server There is no option to force BACKUP … [Read More]
Question I have a table that consumes almost 1.2 TB of space and has lots of historical data which are mostly irrelevant. Since performing bulk DELETE is going to cause a lot of heavy-lifting, I’m trying to use the concept of horizontal partitioning to create … [Read More]
Question Our server where the Microsoft SQL Server 2016 Web Edition server is installed is running very slow. We are thinking of increasing the number of cores licensed on it. However, we need to check how many CPU cores the database is using currently. Our … [Read More]
Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties … [Read More]
Question I realize this is likely a simplistic question but my searches only return results for Drive Letters or Database names if I include SQL Server. Please feel free to point me to existing articles or answers, and my apologies in advance 🙂 I’ve inherited … [Read More]
Copyright © 2024 | Andy Mallon | am2.co