Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • Reply To: GitHub Copilot - Our Best Ally for T-SQL

    I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub general advice,...

  • RE: The Danger of xp_cmdshell

    It's easy to go bananas over one single configuration item such as sp_xpcmdshell. Of course noone should enable it wo having a good and well documented case for it.

    And...

  • RE: Core T-SQL

    With risk to duplicate what Gaz mentinoned, we need to understand the basic processing/binding order (FROM, ON, JOIN and so on) and realize that the Query processor is the final...

  • RE: Central Management Server Daily Script

    ...and I guess it's

    SELECT * FROM #waitstats

    and not

    SELECT * FROM ..sysprocesses

    right? 🙂

  • RE: Central Management Server Daily Script

    Excellent script, just had to adjust the first row to:

    WITH Waits (servername, wait_type, wait_time_s, pct, rn) AS....

    to include the columns!

    Will use this in the daily reporting!

  • RE: Understanding INNER join in detail

    This article was written in a good form, but if the goal was clarifying the logic of inner join the content MUST be 100% correct. I can live with one...

Viewing 6 posts - 1 through 6 (of 6 total)