| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Best migration approach - Hi Colleagues, I am considering the across-the-wire migration method to SQL Server 2017. However, my source is an SQL Server 2014 Availability group with three nodes, one asynchronous. Is launching a new VM on the remote site and the same cluster to migrate this first node a good idea? Later, demote the old node, then […] |
| SQL Server 2017 - Development |
| Need help with a Query logic - I have a table which tracks of activity when users from one specific app login and logout. But I have seen some cases where let's say a user logins at 11:40 on March 24th and then logins again at 11:55 on the same day without logging out. The application doesn't allow that but I am […] |
| SQL Server 2016 - Development and T-SQL |
| MS SQL Query - JOIN mutiple tables but it duplicates results - MS SQL Query - JOIN multiple tables but it duplicate results; Good day! it duplicate results when i run this query below; - if i comment out "LEFT JOIN BBI$Barcodes AS BAR", the query results are correct. Thank you! |
| Administration - SQL Server 2014 |
| Database backups going to device - Hi Friends, How can I know the exact device where my backups are going on? I only see {67BAB2D0-A1DC-44F8-BF73-EBAFD5AE3220}16 as one device. However, I do not find out where are my backup files located. Some databases are going to a particular drive, but others are using that expression, Thank you, Best Regards, |
| SQL Server 2019 - Administration |
| Does Query Store persist data across an upgrade from SQL 2016 to SQL 2019 - This may be somewhere in the docs, but my Google-fu wasn't able to find it... We're testing an upgrade from SQL 2012 to SQL 2019, but tests indicate performance in SQL 2019 with compatibility level 110 is worse than native SQL 2012 for some critical queries and switching to compatibility level 150 (native 2019) is […] |
| adaptive memory grants - Hi we have a sql server we use as a data warehouse. It has 1TB of RAM but still suffers from memory pressure. Looking at the plans there are excessive memory grants. I changed the compatibility level to 150 to take advantage of the Adaptive Memory Grants. It's been in place for around a month […] |
| Upgrade to SQL2019 from 2012 and everything is slow - what to look for? - We have recently started a process of planning the upgrade of our four-node SQL2012 availability group to SQL2019. The main database is pretty large (a few TB) and we've spent years tuning the SQL to get the performance to where it needs to be such that huge complex procedures absolutely fly on SQL2012. We've had […] |
| SQL Server 2019 - Development |
| T-SQL Query Help - Hello, I am working on one of the SQL Logic, i need help to build core logic to do the rest, below is ddl, create table #x1 ( task varchar(100), subtask varchar(100), status varchar(100) ) insert into #x1 values ('a','x','completed') insert into #x1 values ('b','l','overdue') insert into #x1 values ('b','m','completed') insert into #x1 values ('b','n','not […] |
| SSIS package configuration connecting to design-time instance - I have an SSIS package which uses SQL Server Configurations. This uses an expression-based, project connection manager but is connecting to the instance at development time as opposed to the instance at run time. However the remainder of the package is using the run time version of the connection manager. The expression-based values come from […] |
| MSSQL STRING_AGG() Conversion failed when converting the varchar value to int. - Short story, I needed to convert a table insert/update trigger to a Service Broker task. That's not the issue but it might help explain the structures being used. The INSERTED table is used but is passed from the Trigger as XML variable to the SP and executed asynchronously under the Broker Service. Again this is […] |
| Query to Insert Data Based on CustomerID from one table to another - Hello All, Below is the my existing table structure from which I need to insert records to a new table I need a query to insert records into a new table for each customer for same date. For example considering above data structure query should insert records into a new table as below based on […] |
| SQL Azure - Administration |
| Scheduled Jobs in Azure SQL Databases Failing for Auto-Paused DB - Hello! I have somewhat similar kind of PowerShell script which executes the stored procedure on a schedule. Since the database is set to auto-pause, job is failing at times with the error message below: "Exception calling "Open" with "0" argument(s): on server is not currently available. Please retry the connection later. " How can I […] |
| Integration Services |
| Visual Studio 2019 Pro won't load my projects - HI all, For some reason I've been having issues with VS pro opening up my projects that are in my SIS Solution. I'm NOT having the same problem with my SSRS solution. That opens fine. I have both Solutions/projects under Azure Devops/Git. I had this issue about 2 weeks ago and I was able to […] |
| SQL Server 2022 - Administration |
| Allow only encrypted connections. - Hi In SQL22, Is there a way to allow only / force encrypted connections? I have 'force encryption' on and have cert installed: But when I connect via SSMS I can unselect ' Encrypt Connection' and it connects. My understanding is that means that it is allowing non-encrypted connections: How do I make my […] |
| SQL Server 2022 - Development |
| VNN and unique ports - Background TLDR: We are creating non-prod WFC clusters. Each node in the cluster will have a handful of sql instances and each instance will have many Always on groups separating logic database sets. The Issue: I did some testing and while the warning about 1433 on VNN creation with unique IP's per VNN is […] |
