| Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Does a Query Lock to the Table_Name or Table_ID - SQL 2017 ENT SCENARIO: Table_1 has a Sch-M lock on during an intended updating process. A QUERY is executed against Table_1 and is queued up, waiting for the Sch-M lock to release. While the QUERY is queued up on Table_1, Table_1 is renamed to Table_1_OLD A newly designed Table_2 is then renamed to Table_1 QUESTION: […] |
| SQL Server 2016 - Development and T-SQL |
| Help with to generate Data pattern Sql help - Need to generate a from and to From to 50 -99 100 -299 300 -- I tried to do the logic ,but its working as 1-50 51-100 101 - FinalCTE AS ( Select ,FROMQUANTITY AS S_FROMQUANTITY ,ROW_NUMBER() OVER(PARTITION BY C.po_line_id ORDER BY C.FROMQUANTITY ASC) AS A ,CASE WHEN CAST(C.FROMQUANTITY AS NUMERIC(18,7)) >= 1.0 THEN […] |
| Losing Saved Connections in SSMS 2016 - Microsoft SQL Server Management Studio 13.0.16106.4 Hi , I am used to having saved connections in the Connect to Server popup. For some reason my SQL Server management studio 2016 is not saving them anymore. Please help me get saved connections back or get the connections to save again. |
| SQL Server 2019 - Administration |
| SQL Server Availability Group Database Backup Missing Data - I have a production SQL2019 Enterprise SQL Server which hosts an Availability Group with 12 small to medium databases in it. This is an OLTP server and there is no database over 200gb. The AG only has 2 nodes and is used for H/A when patching. Both nodes are onPrem so the Availability Mode is […] |
| SQL Server 2019 - Development |
| ssis dashboard suddenly missing from reports option under catalog/ssisdb - hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the dashboard option under my regular id. my id has sa. so i connected with my admin which also has sa and did see it. losing permissions would have occurred in the last 24 hrs. i saw in one […] |
| checking on some restrictions related to functions - hi i'm helping a friend on his creation of a function. here are the issues... he's getting an error setting nocount on. i told him that is only a proc thing as far as i know. is that correct? 2. he's getting an error setting xact abort on. i was a little surprised by this. […] |
| SQL Azure - Development |
| Hybrid Cloud Server Integration with SQLServerCentral’s SQL Server 2022 - Hello everyone, I’m currently exploring the use of hybrid cloud servers and am focusing on integrating them with SQLServerCentral’s SQL Server 2022. While hybrid cloud environments offer flexibility, managing and optimizing them with SQL Server 2022 presents several challenges. Here are some specific areas where I’m seeking advice: Integration Best Practices: What are the best […] |
| Powershell |
| dump to csv -- image column - If there is an Image Column in mssql table and I wanted to use export-csv to dump this info to file how do you handle that column to be able to import that csv to another DB. Thanks. |
| SQL Server 2022 - Administration |
| Alias woes on SQL Server 2022 - Our company is moving to the cloud. I have SQL Developer Edition 2022 on Windows Server 2022 Datacenter setting up our QA SharePoint Farm.. I've created a named instance running over port 55055 using TCP/IP. THis is what I have in my on premises SQL server that we set up about 10 years ago. The […] |
| Db level user is not having execute permission no db_owner - Dear all, we have a strange situation Db level [ user ]is not having execute permission also not having db_owner , having ddl read and write but in audit logs it is showing the same user had action_id/EX permission in audit logs how can this is possible. |
| SQL Server 2022 Memory Consumption - I have migrated to SQL Server 2022 from SQL Server 2014 and after migration I have observed that it is consuming more memory than before. Memory is going almost 80-90%. We have same configuration, there is not memory caping on SQL Server 2022 and there was no caping on SQL Server 2014. We have same […] |
| SQL Server 2022 - Development |
| SSIS package project connections don't work on upgrade - We're upgrading from SQL Server 2016 to 2022. The SSIS package project level connections don't work as expected. One queries the server as an anonymous logon instead of the domain account associated with the SQL Server Agent. One even affects both the original server and the new one to which it is pointed. I have […] |
| 2022 azure vm cant run same ssis pkg we run on prem - Hi, we set up an environment on our new azure 2022 vm with a cloned "prod target warehouse", ssis project clone from prod, cloned sql agent etc etc. amongst other things the ssis points at a new erp's sales data we are testing with in just one agent step/ssis project execution for that 2019 std […] |
| ssis 32 bit vs 64, debug and non debug - Hi i am looking in vs2022 at my imported 2022 dev azure vm based ssis project. And vs2022 at my 2019 non azure non vm (i think) based production ssis project. The idea is to compare their bittages after i got an error on the dev box basically saying the 64 bit connector wasnt installed […] |
| Strange(?) performance problems - I am debugging an NHibernate generated SQL_query for performance problem and came up with something strange. The query is a SELECT statement that reads from a view. I've tracked the problem to this part of the query: AND (myView.A LIKE (@p7+'%') OR myView.B=@p8 OR myView.C=@p9) If I run the query with only condition at a […] |
