Forum Replies Created

Viewing 15 posts - 601 through 615 (of 7,499 total)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data and code to get the best help

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Who am I ? Sometimes this is me but most of the time this is me

June 23, 2022 at 1:05 pm

#4053859

  • Reply To: Performance of same query slower for a different user

    Replace the Scalar Value function with a (in-line) Table Value Function and you will have a stable running potentially fast query !

    ...
    outer apply dbo.tvf_GenerateCostCode(CC.Code, SU.Code,...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 22, 2022 at 2:08 pm

    #4053320

  • Reply To: explicite alternative to FORMAT() concerning DATE

    Jeff Moden wrote:

    @Johan ... Do you have the code where you created and populated the #TallyDate table so that newbies can run your test?

    Also, your good code doesn't need the DATEADD/DATEDIFF...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 22, 2022 at 6:37 am

    #4053125

  • Reply To: explicite alternative to FORMAT() concerning DATE

    The test is simple and straight forward

    set statistics time , io on
    go

    select FORMAT(datecol, 'yyyy-MM-dd') as Datetext
    from #TallyDate
    --order by DateCol

    /*
    (10000 rows affected)
    Table '#TallyDate__________________________________________________________________________________________________________000000000008'. Scan count 1, logical reads...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 21, 2022 at 11:05 am

    #4052664

  • Reply To: Availability Groups

    just to add to Jeffrey's hints:

    Keep in mind your secondaries will also need the same size available !

    Don't forget your LDF files ! (these do not benefit from IFI !...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 21, 2022 at 8:06 am

    #4052583

  • Reply To: Connecting Cloud Run to cloud sql

    Which cloud(s) are you using?

    how did you configure your connections?

    how does your routing work?

    did you configure the needed firewall rules?

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 21, 2022 at 8:01 am

    #4052570

  • Reply To: UNION from many linked servers

    If possible, avoid linked servers.

    your code may block others ( local to the linked server ) !

    Maybe your process is even better off doing its stuff using e.g. SSIS (...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 21, 2022 at 7:59 am

    #4052569

  • Reply To: How to put a variable content as attachment file saida.txt ?

    You could put it all in a table ( non-# and non-## ), kind of a key-value pair thing.

    Then have the query selecting your stored row from the table

     

    Johan
    

    
Learn to play, play to learn !
    

    Dont drive faster than your guardian angel can fly ...
    
but keeping both feet on the ground wont get you anywhere  :w00t:  
    

    - How to post Performance Problems
    
- How to post data and code to get the best help
    

    

    - How to prevent a sore throat after hours of presenting ppt 
    

    press F1 for solution, press shift+F1 for urgent solution 😀
    

    Who am I ?   Sometimes this is me   but   most of the time this is me

    June 15, 2022 at 12:59 pm

    #4049881

  • Reply To: How to put a variable content as attachment file saida.txt ?

    Best is to have sp_send_dbmail execute the query and store the result in a given filename to be added to the email

    e.g:

    declare @subject varchar(1000)
    set @subject = @@servername...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    June 15, 2022 at 12:25 pm

    #4049832

    • Viewing 15 posts - 601 through 615 (of 7,499 total)