DBA Stack Exchange

These posts were previously published on the DBA Stack Exchange site, and have been cross-posted here for ad-free posterity. I’m no longer active with responding to questions on the Stack Exchange Network, and consider these to be the canonical links for my answers. If I update any of my responses to correspond to changing technology, they will only be updated on my own site, and not on the Database Administrators Stack Exchange site.

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]

Job to stop other job at specific time

August 13, 2021 Andy 0

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]

Identify all tables with an identity column

July 2, 2021 Andy 0

Question Is there a query I can run that will show me all tables with an identity column? Trying to figure out if there are any identity based tables whose current identity is nearing upper bound of int32 or int64. asked 2021-07-02 by user2368632 Answer … [Read More]