Viewing 15 posts - 16 through 30 (of 9,630 total)
Awesome! Thanks for sharing the solution. I honestly never would have thought of this since I don't think I have ever used a configuration in an SSIS project.
May 30, 2018 at 12:37 pm
Sorry Brandie, I didn't get email notifications about your new posts until this morning because I would have replied had I seen your questions.
First, I still think you...
May 30, 2018 at 7:11 am
Sounds like a data issue in DEV where one of the functions you are using, likely FINDSTRING is not returning a value > 3 so the -3 is causing a...
May 25, 2018 at 1:53 pm
Are there multiple SSIS Projects in the solution? You might need to go to the project and set it at that level.
May 25, 2018 at 1:45 pm
You could do a DDL trigger on create database as Sue has mentioned, but be sure to test that thoroughly because if the trigger fails the create database will fail. ...
May 25, 2018 at 1:44 pm
With SQL Server 2014 Microsoft changed the way they do Cardinality Estimation and with a trace flag allowed the use of the previous Cardinality estimator, this would explain the differences...
May 25, 2018 at 1:33 pm
If it is running is likely isn't waiting on anything it is executing the task that it needs to do. You should only see a wait if the query isn't...
May 25, 2018 at 9:06 am
You can add teh Lock_acquired event to your trace, but that is going to be A TON of information because everything (unless using snapshot isolation) takes some kind of lock. ...
May 25, 2018 at 9:03 am
TABLOCK is an option on BULK INSERT so find out if they are using that option, if they are actually using the BULK INSERT statement. The other reason that they...
May 25, 2018 at 8:55 am
Encrypting a backup shouldn't impact memory at all as the same pages will need to be read into memory, there will be small hit in CPU use, probably < 5%,...
May 25, 2018 at 8:45 am
Lynn is correct. Those columns in msdb.dbo.backupset indicate if the backup itself was run with the Encryption option, not that the backup is of a database encrypted with...
May 25, 2018 at 8:39 am
Do you mean the server level "remote access" setting or the "allow remote connections" setting for the service? "allow remote connections" has to be on in order for you to...
May 25, 2018 at 8:32 am
If I understand correctly I think this will work:
update status_table SET Status = CASE OPEN_CLOSE ...
May 25, 2018 at 8:00 am
Take a deep breath, this won't be as hard as you think. If you are using SSIS and a data flow task to move the data, you'll just...
May 25, 2018 at 7:54 am
Can someone help me?
I want to display the last job execution time and date on...
February 12, 2018 at 6:44 am