| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| Administration - SQL Server 2014 |
| Strange Deadlock Graph showing multiple DB but isolated - Hi Experts, I am observing strange deadlock behaviour where one deadlock graph have 2 isolated databases involved. Can any experts here shed some light on this? Regards |
| SQL Server 2019 - Administration |
| How can we enhance statistics information collection - Currently we are collecting database statistics information using select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED') For some larger databases this statement takes more than 23 minutes to complete. Is there anything we can do to speed up this process and collect the same data? |
| when dc is down can we remove database in dr out of always on secondary replica - HI All, primary server is in always on secondary is a replica when primary DC is down due to unexpected power off , can we make the secondary database online by removing them from availability group when dc is down can we remove database in dr out of always on secondary replica thanks naga.rohitkumar |
| SQL server 2019 alwayson problem - Hi, I've SQL server 2019 STD always on set up with 2 nodes and file share witness (located on third server). yesterday we had an network issue that the main switch was down for 15 minutes. after the network is back i see that the whole SQL server alwayson cluster was deleted from the computers […] |
| Rebuilding/Reorganizing in a very transactional table - Hello masters, It's been quite some time since i last posted here but i encountered a really hard opponent. We've got this table, this table has around 50-60m rows of transactions and this is only in one month, we've got this daily process that moves the transactions from the main to the historic one (basically […] |
| Database Ownership - Does it Matter ? - From a practical standpoint, does it matter who is shown as the owner of a database ? What if it's a network user, and their account is deleted when they leave the company? |
| SSRS 2019 Migration - Hello everyone, i have been trying to migrate SSRS 2012 to 2019 using powershell script which i found here [ microsoft/ReportingServicesTools: Reporting Services Powershell Tools (github.com) ] Unfortunately the samples mentioned in the script is not helping as well. Pls find the options i have tried with it & their respective exception Can anyone pls help […] |
| SQL Server 2019 - Development |
| EXEC (@SQL) AT QASERVERNAME; Fails with read-only database error. - All, Need a linked server guru. Trying the following in a stored procedure: SET @SQL = 'DROP TABLE IF EXISTS DB_NAM.SCHMA_NAME.TBL_NAME'; IF @@SERVERNAME = 'QASERVERNAME' BEGIN; SET @HUBServerName = '[QAHUBSERVERNAME]'; EXEC (@SQL) AT QAHUBSERVERNAME; END; Then I get this: Msg 3906, Level 16, State 2, Line 10 Failed to update database "DB_NAM" because the database […] |
| ACCIDENTAL DUPLICATE... - Accidental Duplicate... my bad... |
| nested subqueries vs separate queries performance difference - Hi everyone I am looking at improving the performance of my queries. There is an approach I am considering but I don't know if it will actually improve things or not. I won't know until I try (which I will) but I am interested in getting some feedback from the community. Query 1 select * […] |
| Reporting Services |
| pagename property for my tablix doesnt show fields - Hi , i went to set page name on a tablix mostly for naming worksheets when report is saved to excel. From what i can see, ssrs is saying no dataset is attached to the tablix. Which isnt true. Can someone help? at the moment that total line is hidden and i'd have to ask […] |
| Using Parameter and Booksmarks together? - Hello, I have a SSRS 2016 Report with multiple tables on every pages. User should select a particular table and jump to the page of this table. Is it possible to do? I did not find any way to do it. Try: I create a textbox with a Action to Bookmark and the expression of […] |
| SQL Server 2022 - Administration |
| Log shipping setup failing with error - Access is denied - We are setting up a log shipping from the Dev to the Reporting Server. However, the GUI process is failing with the below error. Source VM: XXX-SQL-D Target VM: XXX-RPT-D-DB Error from Log File: Cannot open backup device '\\XXX-SQL-D\i$\MSSQL\Backup\LSTONY\LOG\LSTONY.bak'. Operating system error 5(Access is denied.). RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3201) […] |
| SQL Server 2022 - Development |
| very slow performance using WHERE on Oracle linked server - I have a linked server pointing to an Oracle instance using OraOLEDB.Oracle. The table contains about 40K rows. My issue is that while I can get fine performance doing a SELECT or DELETE with no WHERE clause, the moment I add a WHERE it is just horrible. Even selecting a single row takes 20+ minutes. […] |
| Grouping Count - Hi All, I have domain in Column A. Here I need to count how many domain and need them to flag 1, 2, 3 and so on till maximum. How could I do them in SQL Server. Please find the attachment excel file for reference. Thanks |
