Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
SQL2017 CU21 CHECKDB WITH EXTENDED_LOGICAL_CHECKS - I have a problem running CHECKDB WITH EXTENDED_LOGICAL_CHECKS using dynamic SQL since upgrading SQL2017 standard edition to CU21. The problem occurs with msdb on all seven instances and on two out of 63 user databases. The problem does not occur with CU20. If I run the following static SQL from SSMS: DBCC CHECKDB ([msdb]) WITH […] |
SQL Server 2017 - Development |
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […] |
Out of memory error when I try to export an SSIS project in SSMS to an ispac - Hey guys, when I go into ssms and open the integration Services Catalog folder, navigate to a project, right click it and left click on export it runs for some time but then I get an error saying out of memory. How can I correct this? |
SQL Server 2016 - Administration |
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […] |
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […] |
Cannot connect after Availability Group automatic failover - Hi We have a SQL Server setup with Availaibility Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarially on one of the four nodes, with one other node in the same datacenter for syncronous HA and the […] |
SQL Server 2016 - Development and T-SQL |
Calculate aging between two date fields excluding weekends and holidays in SQL - Hi Friends, I have a table which has DateTime, IsWeekend, IsHoliday fields in my DB. I have another table which has the list of tickets logged with columns like Select TicketID, Status,CreatedDate,ResolvedDate, etc., From Table_A How can I calculate the aging of these tickets excluding the weekends and holidays. I have read so many posts […] |
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […] |
Is it possible to optimize this SQL to get rid of 2 highlighted subqueries? - Is it possible to optimize this statement to get rid of the case named [aging]? specifically, the two highlighted statements that cause 90% of all waits in the entire select statement. 4 attachments: entire SP, the CULPRIT SQL, and the full Stored Proc where it is called +screenshot that shows fully confirmed problem statements that […] |
SQL Server 2012 - T-SQL |
'Too many parameters..' error - Hi Friends, I am a Database-Design architect trying to write some stored procedures. I created an SP with one IN parameter and many OUT parameters....I called it from the below calling-code carefully having carefully declared the parameters but still I get this error.. Will be very thankful if somebody can point to the issue and […] |
SQL Server 2019 - Development |
SQL Collation to match IBMi - In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03 INVB04 INV175 INV190 Is there a SQL Collation I can use in a query to make a SQL Select ORDER BY match the IBM Sort ? EDIT: I found this in an old post, which seems […] |
Understanding the Expression Service - avoiding expression limits - Hi Sql Experts, At my company, we have authored a piece of software that allows users to examine data by viewing it in a grid, and authoring expressions against that data. Our software ultimately distills those expressions authored in the application to sql expressions used in a SELECT. These expressions are all linear (no aggregations/grouping), […] |
SSDT |
Use a variable for a file connection manager - How do I tell a file connection manager that the file in question is not a static name and will change daily? I have a string variable that builds the daily expected filename but can't see how to use this. SSDT wants me to enter the name of an existing file... which I can do […] |
Integration Services |
csv load exact format using ssis - i have one doube in ssis how to load double codes data from sql server to csv filesusing ssis pacakge . source : emp table CREATE TABLE [dbo].[empcsvfile]( [eid] [varchar](50) NULL, [empstring] [varchar](8000) NULL, [details] [varchar](500) NULL ) GO INSERT [dbo].[empcsvfile] ([eid], [empstring], [details]) VALUES (N'1', N'''1'',''yt'',''1te'',''1d''', N'{"test":"ed","eDate":"1990-01-16","isflag":null,"Type":"te","Number":null,"std":null,"mark":null,"Code":"22","cty":"r","state":"tn","country":"IN","isPermanent":null,"Lines":{"Street2":"street2","Street1":"street2","Taluka":"street2","District":"street2"},"Proof":null},{"Type":"PHONE","Date":"2017-05-28","Verified":null,"Type":"BSNSS","Code":null,"Code":null,"Number":"954457565","ette') destination : Test.csv file eid |empstring |details […] |
SQLServerCentral.com Website Issues |
Ask SSC TLS Error - Posted also over on AskSSC but posting here in case people can't get to the site due to this. https://ask.sqlservercentral.com/questions/156338/tls10-tls-11-error-when-browsing-from-secured-hard.html Getting an issue when browsing ASK from a CIS hardened desktop with the latest version of Edge or Chrome. This is due to Ask using TLS1.0 or TLS.1.1 which it will not support any […] |