Forum Replies Created

Viewing 15 posts - 106 through 120 (of 2,917 total)

  • Reply To: Comparing one record within a SELECT SUM()

    Pete Bishop wrote:

    Hi Brian; thanks for the response.

    Unfortunately, the [rn] is a pseudo-column from the ROW_NUMBER() window function so I'd have to store the output into a temporary table in order...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 25, 2025 at 5:21 pm

    #4627084

  • Reply To: Row Count task in data flow fails with "unspecified error"

    As a random guess - I'd say your CSV has some invalid data in it such as a row with an extra/missing comma. This can happen when your CSV allows...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 25, 2025 at 4:11 pm

    #4627066

  • Reply To: Comparing one record within a SELECT SUM()

    As far as I am aware, there is no way to update a record AND select in a single query, but you could do it all in one transaction or...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 25, 2025 at 2:48 pm

    #4627046

  • Reply To: Stored Procedure Generation Script

    Deepam Ghosh wrote:

    Thanks Phil for sharing the alternative to do. I never used VS database project for schema comparison. The idea of creating such script came as there was a requirement...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 24, 2025 at 2:48 pm

    #4626654

  • Reply To: How to push PowerQuery results into SQL Server

    pietlinden wrote:

    Why would I need enterprise grade for a one man show? For something he'd run every few weeks?  I'm not processing 100K files an hour.

    If you can point out...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 24, 2025 at 2:42 pm

    #4626653

  • Reply To: Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package

    That is very strange... If you have a diff tool (such as winmerge), it may help you look at the DTSX and/or DTPROJ files and try to figure out what's...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 24, 2025 at 2:28 pm

    #4626648

  • Reply To: Archiving data older than 5 years

    How about doing it a little differently and instead of:

    where  @Period < (select LEFT(CONVERT(varchar(6),DATEADD(yyyy,-5, getdate()),112),6))

    you first store the yyyymm in a variable with something like:

    The above is all just my opinion on what you should do. 
    
As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 23, 2025 at 4:41 pm

    #4626247

  • Reply To: Transactional DDL in SQL Server: In Oracle, It Does Not Compute

    I'd also like to point out that you should be careful with transactions that change large amounts of data OR are long running - if a query runs for 5...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 23, 2025 at 4:35 pm

    #4626245

  • Reply To: Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package

    Glad that wasn't a dumb question. I know with SSMS I've hit snags when my SSMS version doesn't match the SSIS version and it will happily push the dtsx to...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 23, 2025 at 3:33 pm

    #4626234

  • Reply To: How to fix transactional replication latency

    How many transactions are waiting to distribute and how fast is the distributer distributing them?

    And did you read the article I linked? If you scroll down to the section "Improving...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 23, 2025 at 3:16 pm

    #4626223

  • Reply To: How to fix transactional replication latency

    is that 20 minute latency from publisher to distributor or distributor to subscriber?

    If it is publisher to distributor, then how many transactions are waiting to distribute and how fast is...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 22, 2025 at 10:17 pm

    #4625903

  • Reply To: Cycle Logs (non-error log)

    Oof... I would almost bet real money it was set to default... BUT glad I didn't - it is set to 7 days. That makes me feel better.

    Now I just...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 22, 2025 at 2:36 pm

    #4625744

  • Reply To: Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package

    Possibly a dumb question, but what version of SSIS was your package targeting?

    This is in the SQL Server 2019 section of the forum, so I suspect it is SQL Server...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 22, 2025 at 2:31 pm

    #4625736

  • Reply To: Am I doing the right thing, and what does this mean?

    I half-second Perry Whittle's suggestion. I personally don't like maintenance plans as they don't scale well. You spin up a new instance, you have to re-deploy the maintenance plan. Change...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 22, 2025 at 2:28 pm

    #4625735

  • Reply To: How to fix transactional replication latency

    I have not used replication before, but quick google brought me to this:

    https://www.mssqltips.com/sqlservertip/3598/troubleshooting-transactional-replication-latency-issues-in-sql-server/

    So, I think it depends on where the latency is. Is it between publisher and distributor or distributor...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

    July 21, 2025 at 10:28 pm

    #4625460

    • Viewing 15 posts - 106 through 120 (of 2,917 total)