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

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can’t Bring It Online

March 1, 2020 Andy 0

Question I can take databases offline (via GUI) but can’t bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A few months ago, I created a db instance on Amazon … [Read More]

How to store real-time data to database

February 23, 2020 Andy 0

Question Here is my situation: I have a WebSocket connection that feeds me data real-time I have an async callback function that gets the data and inserts into a queue I have another thread that reads from the queue and stores it into the Postgres … [Read More]

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

February 12, 2020 Andy 0

Question SQL Server System Databases, as far as I know, always have those same IDs and I have seen lots of maintenance scripts on the internet relying on the predicate WHERE database_id > 4 to exclude them from the actions of the script. Also, if … [Read More]

Fastest way to shrink LOB data in SQL Server

January 16, 2020 Andy 0

Question We have a database of total size of 3886 GB. Out of which 778 GB is free. So total 3108 GB worth of data is present. Out of which 2458 GB is “LOB Data” and 400 GB is worth “Regular”. Since the database is … [Read More]

Job waiting on CXCONSUMER

January 9, 2020 Andy 0

Question We have got a procedure on SQL Server agent jobs and this job started to hang on transaction for many hours with wait stats CXCONSUMER and never complete. The problem is after we noticed that it was hanging we kill the job and started … [Read More]

Do triggers start to degrade in performance (or sometimes fail) on highly transactional tables?

December 21, 2019 Andy 0

Question How many transactions per second can SQL Server table triggers handle? If I had a highly transactional table that was inserted into 1,000 times a second, are insert triggers on that table reliable to fire every single time? asked 2019-12-21 by J.D. Answer are … [Read More]

INSERT EXEC statement cannot be nested

December 13, 2019 Andy 0

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]

How to see restore history of a deleted database?

November 23, 2019 Andy 1

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]

Can’t use GitKraken on private repositories

November 8, 2019 Andy 0

Educorreia is using GitKraken with GitHub, and needs some help navigating the licensing & edition differences to make that combination work with private repos.

Cannot connect to my SQL Management studio after moving a tempDB

November 1, 2019 Andy 0

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]