Stack Exchange Archives - Page 4 of 17 - Andy M Mallon

Database Sizes error; Arithmetic overflow error converting expression to data type int

October 1, 2021 Andy 0

Question I am using the below query to pull back database sizes for our SQL instances. This cannot pull data larger than 2TB back because of the maximum number the int data type can pull back. How do I go about altering the query to … [Read More]

SQL Server replication additional subscriber

September 15, 2021 Andy 0

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]

Always backup database with encryption

September 12, 2021 Andy 0

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]

Partitioning and existing Indexes

September 12, 2021 Andy 0

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]

Identify how many CPUs our database server is using

September 9, 2021 Andy 0

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]

Function to create SQL TABLE does not works well using Powershell

September 2, 2021 Andy 0

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]

Is it ok to change drive names/labels (NOT Drive Letters!)

September 1, 2021 Andy 0

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]

Azure Data Studio – Intellisense does not detect tables, yet queries work

August 23, 2021 Andy 0

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]

insert on table being unnaturally slow

August 16, 2021 Andy 0

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]

What are the .BCP files inside a .bacpak file?

August 16, 2021 Andy 0

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]