Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Which version of SSMS to connect to SSIS 2008 - I suspect that an SSIS package in source control is not the latest deployed version in production. I want to pull the current deployed package from the production server and check its logic. This package is deployed to an old SQL 2008R2 box that I'm currently working on moving all the SSIS packages off and […] |
SQL Server 2017 - Development |
DB Mail sysmail keeps stopping. sysmail_start_sp takes forever and never finshes - i use exec dbo.sysmail_start_sp to start DB Mail but it keeps running forever. When i check the status using EXEC dbo.sysmail_help_status_sp , it shows Started. But i automcatically goes in STOPPED mode and i have to restart DB Mail. None of the emails are going through and can be viewed in sysmail_mailitems table with status […] |
SSIS Rows per Batch and Max Insert Commit Size - I have an SSIS package which is copying 5 large tables daily. There is no WHERE logic in these data pulls, every record is selected and the source tables will only keep growing. Currently, we are now at the point where the SSIS package causes the Transaction Log on the target SQL Server to run […] |
SQL Server 2016 - Administration |
Truncate partition table failed due to index not partition. Help please. - I have 1 table which has a partition on Date column. However this table has a unique constraints on it's ID. Here's how the table creation script looks like. CREATE TABLE [TestDB].[dbo].[tblDS2]( [GSN_ID] [varchar](50) NOT NULL, [DS2_Lot_ID] [varchar](50) NULL, [DS2_SubLot_ID] [varchar](50) NULL, [DS2_X] [smallint] NULL, [DS2_Y] [smallint] NULL, [DS2_Bin] [varchar](10) NULL, [DS2_Date] [smalldatetime] NULL, [GsnBeforeFix] […] |
Can I retrieve T-SQL from Maintenance Plan without using GUI? - Can I retrieve T-SQL from Maintenance Plan steps by running a query ? (without using GUI in SSMS) |
Stored procedure able to be built over table that doesn't exist - SQL 2016 SP3 So we're updating some procedures to use a different table, it's the same name but different schema, neither one uses the dbo schema. The table under the old schema has been deleted. I found that I was able to successfully build the procedure even though I missed changing one of the references […] |
SQL Server 2016 - Development and T-SQL |
Read multiple files of same name and process in DB - Hi All, I have a requirement like, we will receive multiple csv files in a shared path and those files needs to be processed to the corresponding tables. Say for eg: if Employee file has 3 files like employee_2022_08_08_11_11 / employee_2022_08_07_12_00 / employee_2022_08_08_16_07 i need to process these three files to my employee table and […] |
Administration - SQL Server 2014 |
Sql Reconfigure - Hi Will the below script will stop services ot will execute without restarting services sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'max server memory', 65536; --64GB GO RECONFIGURE; GO WAITFOR DELAY '00:02:00'; GO sp_configure 'max server memory', 215040; --210 GB GO RECONFIGURE; GO Thanks |
Development - SQL Server 2014 |
Use 2 CTEs in a Single SQL Query - Hi , I'm trying to union 2 CTE queries into one. but must be missing something. as I get an issue after the union . I tried a few things but no luck. Im trying to select different Meshtypes as per query. The first CTE is sum_cte and the s2nd is sum_cte2 this is what […] |
SQL Server 2019 - Development |
Finding Special Characters in Email Address - Hi All, I have to find the special characters in email address apart from alphabets, numbers SELECT EmailAddress AS ValidEmail FROM Contacts WHERE EmailAddress LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', EmailAddress) = 0 GO Regards Sathish Kumar |
when check directory at shared path remotely it display not exist (false) althou - when check directory at shared path remotely it display not exist (false) although it exists I have shared path '\\192.168.7.9\Import\8' I face issue when try to check this directory path exist or not . when run script python on sql server 2019 it must return true because directory path exist but my issue is python script return […] |
SQL Server 2008 Administration |
How to restore a database with Full Text Search - HI, The SQL Server instance is 2008 R2. I have a database with a Full Recovery Model and Full Text Search. I need to make a copy of the database on the same server. I have used SSMS to make a backup of the database. I checked the box "Copy-only backup". I want to create […] |
Azure Data Factory |
Any good resource to learn Data Factory ? - I just joined a company and I'm new to Azure. It's a powerful tool but I don't like Data Factory because it reminds me of SSIS and I think it's just clumsy and quite difficult to create pipelines, let alone debug them. Although, I don't know of I hate it because I don't know how […] |
XML |
XML Query to return xml element as column for specific attribute value - Despite having read several articles/examples, I can't solve what seems like it should be a simple problem -- How do I return an xml element value as a column for a specified value of an attribute in that same element. e.g., 31 -- How I return this as LengthMinutes? […] |
Integration Services |
How to unzip the Updates files and avoid which are already unzipped? - Hi everyone, I recently started using WinSCP. I download some .zip files using it from a remote server on a daily basis. These files are basically updates that arrive on the server on a daily basis and save to my local folder: D:\Updates\ Named like these: UPDATE_20220805.zip, UPDATE_20220804.zip, UPDATE_20220803.zip, UPDATE_20220802.zip ..... I want to […] |