Category: Microsoft SQL Server

  • SQL Server Impact Analysis Query

    Ugh. Impact analysis is one my least favorite tasks. And despite the fact it’s gotten easier over the years with the addition of being able to check object dependencies natively within SQL Server Management Studio, I still find myself resorting to wildcard searches of object definitions for various reasons. (For example: dependencies on objects accessed […]

  • SQL Query: To Find Which Columns An Index Is On

    Do you need to write a SQL Server query to find out which columns an index is on? Do you have an index name but need to use T-SQL to determine the column names? Not a problem! The query below will qive you exactly what you want. The example uses an AdventureWorks index as the […]

  • SQL Query: List All Indexes And Their Columns

    Looking to write a SQL query which will list out all the indexes in your database as well as the columns in the index? Well my friend you’ve come to the right place. The query below will give list out the following information: Schema Table Name (or view) Index Name Is Primary Key Is Unique […]

  • Escaping From An Underscore In A SQL Server Wildcard / LIKE Search

    There are two different ways to perform a wildcard (aka LIKE) search in SQL Server to find a word with an “_” underscore. Both options are outlined at the end of the article after a reference to the cult classic Mystery Science Theater 3000: Escape From The Bronx.

  • SSRS: A Hidden Tablix That Won’t Hide And Wham!

    Here’s a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said “wham”. That obviously leads me to “Wham!”. I had my mom […]

  • Formatting MDX and DAX: Free Online Tool From Microsoft

    Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn’t know how to use the “tab” key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from “Microsoft Labs” and have been using it for the last few days to clean […]

  • Parse and sort SET STATISTICS IO output with Excel

    I wish I could say this was my idea. Somebody posted it on twitter awhile back and I did the classic “facepalm”. I have no idea how many times I manually picked apart the results of SQL Server’s SET STATISTICS IO ON without considering creating a formula to handle it for me. So, somebody came […]

  • Set DATA_COMPRESSION for all tables

    Working on a quick little project to sync up two databases and I realized the data compression was set differently between the two of them. Apparently, my Google fu was not up to snuff because it took quite a bit of stumbling around to find a forum post matching what I wanted to do.  There […]

  • SQL Server DELETE FROM: The World’s Scariest DELETE statement

    It’s out there. Waiting for you. While you sleep, it’s awake. It’s coming for you. It’s the Jason Voorhees of SQL Server and you’re the teenager headed into the woods on a dark night… How can you stay safe?  Well my friend, knowledge is power.  (For example, if you’re a teenager don’t go to Crystal […]

  • Create a MessageBox in SSIS with C#

    What is wrong with me?!?  Or rather what is wrong with everyone else on the internet?  Why won’t anyone post a little article on how to create a message box in an SSIS package so I can easily google it?  Must I do everything around here? Confession: I don’t know jack about C#.  Creating a […]