Browse the archive
Question That's a weird scenario. The transaction log is full. It waits on AG. AG is all good. No latency, last commit/hardened time is almost real-time on all the nodes. The Estimated Recovery Time is zero. I checked this from the primary node and …
Continue readingQuestion I have an application that uses PostgreSQL as RDBMS. There is a table containing orders placed by customers. The table has an id as primary key, an order_number (integer) and a created_at field (timestamp). id and created_at are assigned …
Continue readingQuestion I have a query that pulls information for a database from the following tables sys.master_files sys.databases sys.filegroups Currently, the context set is the specific database which I want to query about. But if the database is in a mode such that …
Continue readingQuestion doing some work with the SQL Perfmon counters and banging my head against the wall trying to work out how to translate the instance_name column to a database name. So if I run a query like the following
Continue readingQuestion This is a weird one, and I've run out of ideas for how to go about troubleshooting this. Here's the issue, best as I can sum it up. The SQL Server engine and Agent services are not started when the server first boots when they're set to Automatic. …
Continue readingQuestion We have a few Basic Availability groups in production and I've been reading about the limitations of them. I'm concerned about the following limitations: No backups on secondary replica. No integrity checks on secondary replicas.
Continue readingQuestion I am converting the times of some datetimeoffset columns from UTC to Eastern. I am doing this via the command UPDATE MyTable SET MyColumn = MyColumn AT TIME ZONE 'Eastern Standard Time' This seemed to be working correctly (times were shifted 4 hours …
Continue readingQuestion I have created a stored procedure which takes as inputs a schema name and a table name and outputs an INT containing the largest value in the id column of the table. I have also created a view containing all the schema names, table names, and primary …
Continue readingQuestion Inherited a database server to maintain and found that the transaction log is 92 GB. My plan is to do the backup of that and get it brought back down to a regular size, then fix it. The problem is I don't have enough disk space on the machine to do …
Continue readingQuestion Good Morning, I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes. Will there be any issues or snafu’s I should be aware of? …
Continue reading
