Stack Exchange

Question 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 automatically when the row is … [Read More]

Question 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 USE DB_NAME doesn’t … [Read More]

Question 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 I get a resultset like Log … [Read More]

Question 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 … [Read More]

Question 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. Suppose that we haven’t failed over in months. In … [Read More]

Question I am converting the times of some datetimeoffset columns from UTC to Eastern. I am doing this via the command This seemed to be working correctly (times were shifted 4 hours earlier and now have a -04:00 offset, exactly what I wanted), but then … [Read More]

Question 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 … [Read More]