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]
Question I’m breaking some new ground and trying to get into Azure Data Studio. I’m having a problem with intellisense that seems to be a bug with Azure Data Studio but I’m not sure. I have issues with basic queries. Foreign keys, select statements and … [Read More]
Question I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns and 2 varchar(MAX) columns, all nullable. The table has no … [Read More]
Question Diving on dba.stackexchange.com I found a nice answer that teach me how to open a .bacpac file with File Explorer. I gave it a try with the database AdventureWorks2008R2 and all I did was: Save the database as .bacpac file Rename the file extension … [Read More]
Question We have a job which imports data daily from a remote SQL Server every night, I’ll call it Import-Job. Most of the time this job runs through in about 15 minutes and everything is fine but due to a rather unstable VPN connection sometimes … [Read More]
Question I have seen on this site how to get the the third Friday of the month: How would I get the first Monday after this third Friday? asked 2021-08-12 by Ivan Answer "The first Monday after the third Friday" could be rewritten as "Three … [Read More]
Copyright © 2024 | Andy Mallon | am2.co