Forum Replies Created

Viewing 15 posts - 151 through 165 (of 1,419 total)

  • Reply To: Finding strings with invalid characters

    Phil Parkin wrote:

    Try this, maybe?

    https://www.sqlservercentral.com/scripts/patexclude8k

    That old function could use an updating imo.  As this is the 2022 topic GENERATE_SERIES and STRING_AGG are available.  Also, not to say it's incorrect but...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 29, 2024 at 4:13 pm

    #4369636

  • Reply To: Combine rows into pivoted output

    To make the selection criteria specific to each column you could try a conditional aggregation approach to pivoting the data

    select TestID,
          ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 27, 2024 at 4:24 am

    #4368488

  • Reply To: Has AI Changed Software Development?

    This question still has me thinking.  How has development changed because of AI?  There's more than one trend happening at once imo.  For SQL the impact for me has been...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 22, 2024 at 4:03 pm

    #4365856

  • Reply To: Inconsistent query execution times

    MrBen wrote:

    Thanks alot guys, I think I've taken a bit from each of the 3 posts and have made progress. I've posted the new execution plan below. Seems to be...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 14, 2024 at 9:08 pm

    #4361763

  • Reply To: Inconsistent query execution times

    Disclaimer: this contains speculation and opinions

    In broad terms, when considering performance, imo it makes sense to overlay the FROM clause with the execution plan.  The FROM clause is read left-to-right...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 14, 2024 at 4:36 pm

    #4361690

  • Reply To: Get count from previous month

    This query looks for the minimum previous appropriate enter_date for each row and then calculates the DATEDIFF.  The sample was expanded to include a greater than 12 month gap

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 11, 2024 at 4:25 pm

    #4360334

  • Reply To: Has AI Changed Software Development?

    "Gpt-4-1106-preview has training cutoff of 4/2022 and the context size is 16K (double the standard Gpt4)"  Oops that was not correct.  The cutoff for Gpt4-Turbo is 4/2023 and the context...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 9, 2024 at 3:17 am

    #4358841

  • Reply To: Has AI Changed Software Development?

    Jonathan AC Roberts wrote:

    The company I work for has implemented ChatGPT 4 on its internal servers, actively promoting its usage among all employees. Given its deployment on company servers, there is also...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 8, 2024 at 3:36 pm

    #4358587

  • Reply To: Parse out filed as date time ???

    So you're ok with the loss of information assuming GMTOFFSET means what it appears to mean?  In SQL Server if you need to preserve the same information then you'd be...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 3, 2024 at 11:49 pm

    #4356378

  • Reply To: Fixing Poor Programming Practices

    Once a few years ago, at a prior job, I went on a sales engagement with one of our sales people.  At one point I got called into a meeting...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 3, 2024 at 6:06 pm

    #4356263

  • Reply To: Visual studio 2019 hangs when open excel data source

    There's a huge disclaimer and warning associated with each of the items above.  Of course backup everything first.  There are also reasons NOT to do those things:

    1. .vs is a...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 3, 2024 at 4:24 pm

    #4356206

  • Reply To: Visual studio 2019 hangs when open excel data source

    VS does seem to get its signals crossed from time to time.  When things like this happen I close VS entirely and try the following:

    1. delete the *.vs file in...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    January 3, 2024 at 4:09 pm

    #4356204

  • Reply To: Last value in a row containing..

    Nice one Drew.  CASE exits the expression once a true condition is found

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    December 21, 2023 at 9:28 pm

    #4350421

  • Reply To: AI In the Nov 2023 Enterprise

    I've used AI mostly for things outside of SQL development.  Like git and C# and Powershell.  It seems like it saves time (not always tho) and I go to Google...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    December 21, 2023 at 7:43 pm

    #4350393

  • Reply To: Cant extract values from JSON Array

    Jeff Moden wrote:

    If they just made ...

    Yes the current situation of set based development is quite conditional/permissional.  We're not at the final end state tho

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    December 15, 2023 at 2:36 pm

    #4346633

    • Viewing 15 posts - 151 through 165 (of 1,419 total)