Tag Archives: Settings

  1. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    Continue reading

  2. Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

    4

    December 17, 2018 by Kenneth Fisher

    Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
    Continue reading

  3. SQL Homework – December 2018 – Configure SSMS

    Leave a comment

    December 3, 2018 by Kenneth Fisher

    I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
    Continue reading

  4. Copying formatted text out of a grid column.

    3

    August 27, 2018 by Kenneth Fisher

    I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
    Continue reading

  5. SSMS’s Dark Theme

    3

    April 4, 2018 by Kenneth Fisher

    There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
    Continue reading

  6. Saving and restoring session options settings

    4

    September 25, 2017 by Kenneth Fisher

    There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
    Continue reading

  7. Turning ANSI_PADDING off, and why you shouldn’t

    4

    June 15, 2017 by Kenneth Fisher

    I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,475 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013