Viewing 15 posts - 1,126 through 1,140 (of 6,676 total)
Probably SAN replication.
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
May 5, 2021 at 6:32 pm
We just do a Windows Cluster (I say "we"... I mean our infrastructure group). It's worked well for us over the last decade and has advantages over things...
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
May 5, 2021 at 6:12 pm
Thank you for replying.
@Jeffrey Williams -
So the datetime data in transactional DB system is always stored in UTC. This datetime data is then converted in whatever timezone 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
May 5, 2021 at 6:01 pm
I wasn't actually the one who pushed the SSIS packages to this particular server. I'm not sure if it was just imported straight from 2012 to 2019 or...
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
May 5, 2021 at 5:52 pm
Just identifying the table here doesn't help - there are columns in the select and where the table isn't identified. Use table aliases - and use the table alias when...
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
May 5, 2021 at 5:37 pm
Despite the above reply, if anyone has ever seen this behavior before or has any ideas (aside from telling me to change how I run the package), please...
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
May 4, 2021 at 10:13 pm
Well just looking at the location_id in the result set these are not duplicate records.
There is one duplicate - location_id = 19...my guess is there are multiple projects,...
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
May 4, 2021 at 8:49 pm
I am curious - why do you need to convert the data in SSIS? What is the format of the data - and what is the desired result? Depending on...
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
May 4, 2021 at 8:30 pm
Did you upgrade the package in Visual Studio? How did you move the package from one instance to the other - was it done through VS?
If this is really stored...
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
May 4, 2021 at 8:22 pm
The first problem is your files - since Excel has a limitation of 1 million rows, opening any of those files that exceed that number of rows in Excel just...
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
May 4, 2021 at 5:11 pm
This is a bug in SSMS - and has been around forever. The value that you see is 2097152 MB - which is 2048 GB - which is 2 TB...and...
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
May 4, 2021 at 4:56 pm
Barring the questions @JeffModen has - why not just grant execute to the local service account one time and be done?
GRANT EXECUTE ON schema::xyz TO [localSQLAccount];
Any new procedures created -...
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
May 4, 2021 at 4:43 pm
Sorry - I don't follow...how are you passing results of one job step to another job step when using xp_CmdShell?
That's just it... I'm not. 😀 I...
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
April 30, 2021 at 5:55 pm
True dat! Things like a Cmd Task, etc, work fine... well, kind of. With the understanding that I've not recently spent much time (I'm thinking precisely zero in 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
April 30, 2021 at 4:50 pm
Thanks Jeffery. The problem here is identifying queries hitting server using bcp or freebcp to copy data without our notice.
Not sure you can audit for that - I...
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
April 29, 2021 at 9:42 pm
Viewing 15 posts - 1,126 through 1,140 (of 6,676 total)