On SQL Server 2019, I enabled CDC on some tables about 2 days ago. The CDC cleanup job is scheduled to run every day and the retention period is 3 days. When I checked the job history of the cleanup job, I found nothing there. I ran the job manually and by the next day I found that even the manual job I ran was no longer there. How can I be sure that the cleanup job is running as it should, also could there be anything that is clearing the job history? The database is also part of always-on availability group. Please, help ..read more

We had to rebuild our SQL server instance over this week and have restored every database including Master and other system settings, but our database mail does not seem to be working. All of the queued emails are sitting in Unsent and the mail queue is listed as Inactive. I've tried restarting the queue as well, although some other posts make it sound like Inactive is the default state for when it is not in use at that moment. We are using version 15.0.2116.2 I've been unable to find anything in the error log and the only indicator that it is not working besides the obvious lack of an email i ..read more

I have multisubnet AOAG setup on AWS EC2 servers as below. Problem is that linked server won't work when failover happens or connecting through replica which is not in same subnet as linked server node Node1a (Primary replica) Node1b (Secondary replica) ListenerName : Listener1L (with multi-subnet IP address) Node2a (Primary replica) Node2b (Secondary replica) ListenerName: Listener2L (with multi-subnet IP address) Linked-server: LS_List1L (connecting using Listener name - Listener1L) Linked server works fine when Node 1a and Node2a acting as primary replica and are in same subnet Linked serve ..read more

We are using Power BI as our reporting and dashboard tool for our Snowflake data warehouse. WE have a need for a published report to use the credentials of the person calling the report rather than the person who created and published the report, and have been unable to determine a way of doing this. We have two data visibility restrictions that need to be enforced. First, based on the user's role, they are limited as to what columns of data they can see; we're enforcing this with a data masking policy in Snowflake. Second, we have a need to restrict which rows are visible to certain individua ..read more

we were in the process to migrate from Mysql to MariaDB, but we've encountered a performance issue with several of our queries. The same (already simplified) query select count(*) FROM vorgang,genehmigung,kontostand,konto WHERE mandant_vorgang_s_id IN (-999,99,268768,265382,257,102134,102144,106530,133309,146055,146494,253567,275073,279352,292605) and vorgang_genehmigung_s_id=vorgang.nr and mandant_vorgang_s_id=partner_konto_s_id and konto_type='vorfinanzierungskonto' and konto_kontostand_s_id=konto.nr; (using the exact same database dump in a freshly installed mariadb/mysql and equal ..read more

I have a database containing an unreasonably large full-text index. DBCC CHECKDB WITH PHYSICAL_ONLY takes about 25 minutes on this database, but DBCC CHECKDB WITH DATA_PURITY, EXTENDED_LOGICAL_CHECKS takes about 2 hours longer. This suggests to me that PHYSICAL_ONLY skips full-text indexes. Am I correct? What parameters need to be passed to CHECKDB to have it check full-text indexes ..read more

We have a database application that had a record changed in one table [RPI] that was referenced by another table [ERP] and now the entire application won't move forward or load anything from the RPI table related to the ERP table. Is editing the record directly in the table to reference the old record in the RPI the correct way to approach this, or is there a better way? I should mention that there is no dev environment to test anything and any changes are made directly to production tables ..read more

I have a database which has brackets in its name. (Don't ask! :-\ ) It shows in SSMS but not in Azure because it was canceled while creating. It does not show in the database listing in Azure. It shows in SSMS but it cannot be deleted by right-clicking. I'd like to drop it using SQL but I can't figure out the syntax to include the brackets as characters for the database name, as opposed to the escape/delimiter character. I've tried the following to no avail: drop database [xxx_2024-07-24] Msg 911, Level 16, State 1, Line 1 Database 'xxx_2024-07-24' does not exist. Make sure that the name is e ..read more

I have two servers. A garbage picked, slapped together with duct tape and bubble gum. It is a mix of Dell R620 and Gen 8 HPE parts with 40 cores / 1.5 TB ram. Running ubuntu 22.04 and sql server 2022 Dev Version. Raid 10 3.7 TB SSD's. MDOP is set to 16. The other is a VM hosted on a triple head cluster Xenon Gold's with ssd Nas the whole 9 yards. Server 2019, sql server standard 2022. 128 gigs / 16 cores allocated. MDOP is also set to 16. Database was a backup / restore from the test server. The main table houses live streamed data averaging 100-200 mil new records a day, currently approaching ..read more

I have two temporal tables joined by a view, and when I alter the second table, and call sp_refreshview, it generates the error: View or function 'ViewTest' has more column names specified than columns defined. I noticed that after calling sp_refreshview, the select * on the second table is now incorporating the hidden datetime columns meant for system versioning. Below is the test code that I have written to demonstrate the issue. USE Test; ALTER TABLE Department SET ( SYSTEM_VERSIONING = OFF) GO ALTER TABLE DepartmentTwo SET ( SYSTEM_VERSIONING = OFF) GO DROP TABLE IF EXISTS DepartmentT ..read more