Viewing 15 posts - 676 through 690 (of 6,676 total)
Still no notification emails - at least I have not received any.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 14, 2022 at 6:06 pm
If you include the column in the insert and don't specify the default keyword - then the value will be inserted as you sent it. That is - if...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 12, 2022 at 4:15 pm
Personally, I'm not a huge fan of that "fix". My approach would be to change the SQL Server Service and SQL Agent Service to run as an AD...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 11, 2022 at 7:06 pm
Just for your own sake - every script that you run should be saved in the file system, preferably a shared location. Include identifying information in the file name,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 10, 2022 at 9:38 pm
I tried both Edge and Chrome - no luck. Missing the menu items - assume there was a recent update?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 10, 2022 at 9:32 pm
My guess is that it is probably some type of Julian date - having the year (first 4 digits) and day of year. If that is the case - then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 9, 2022 at 5:54 pm
Before going much further - you need to understand the issues with .AddWithValue. There are some serious drawbacks to using that - and it will cause you issues that are...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 9, 2022 at 5:40 pm
You can pull down the project into VS using the 'Integration Services Import Project Wizard'. This will prompt you for the server where the IS catalog is located and then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2022 at 10:31 pm
I would add a check in the agent job - and then schedule the agent job to run every xx time. The check looks at the table - if the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2022 at 8:23 pm
How are you identifying the issue as disk IO latency? This is important - because most tend to look at the wrong counters when working with SQL Server to determine...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 4, 2022 at 7:59 pm
Here is one article I found: https://www.sisense.com/blog/spline-interpolation-in-sql/
Not sure if that is the most efficient though. It might be more efficient to create the function in Python - and call that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2021 at 9:30 pm
I would review that query - it is forcing a MERGE join which may not be the best option now for those temp tables. You should also review how those...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2021 at 9:10 pm
Neither method is going to be any faster - the code is updating every row in the table ExtractReports.dbo.FinalComplanceDataDelivery. If you want to improve performance, or more likely - reduce...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2021 at 8:53 pm
Yes - I understood your question. There is a difference between the name of a textbox - and the column name coming from the dataset. In your tablix - right-click...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2021 at 7:48 pm
Not sure I follow why you are doing this - you stated you are trying to automate what columns to include in a view?
Why would that even matter? If the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 25, 2021 at 4:54 pm
Viewing 15 posts - 676 through 690 (of 6,676 total)