Tag Archives: microsoft sql server

  1. A DBA horror story in database file extensions.

    4

    September 30, 2021 by Kenneth Fisher

  2. The sysname datatype defaults to not NULL.

    4

    August 26, 2021 by Kenneth Fisher

    The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
    Continue reading

  3. Experiment: Does sp_recompile on a table update associated views.

    2

    August 17, 2021 by Kenneth Fisher

    tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
    Continue reading

  4. Padding a string in SQL Server

    1

    July 15, 2021 by Kenneth Fisher

    I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
    Continue reading

  5. DDL Trigger to log database level security commands.

    4

    June 24, 2021 by Kenneth Fisher

    In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
    Continue reading

  6. CROSS vs OUTER APPLY

    2

    June 10, 2021 by Kenneth Fisher

    I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
    Continue reading

  7. Use BCP to create a CSV (comma delimited) file from a table.

    1

    June 3, 2021 by Kenneth Fisher

    This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one …
    Continue reading

  8. Creating a configurable SSMS script

    1

    May 18, 2021 by Kenneth Fisher

    Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
    Continue reading

  9. How do I test if a linked server works using T-SQL?

    4

    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    Continue reading

  10. T-SQL Formatters

    3

    August 6, 2018 by Kenneth Fisher

    The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, …
    Continue reading

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

Join 3,581 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013