Tag Archives: microsoft sql server

  1. Creating a list of random numbers

    Leave a comment

    March 22, 2017 by Kenneth Fisher

    I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
    Continue reading

  2. The parts of an object’s name

    Leave a comment

    March 20, 2017 by Kenneth Fisher

    Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
    Continue reading

  3. Compressed backup errors and TF 3042

    4

    March 16, 2017 by Kenneth Fisher

    Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
    Continue reading

  4. Limits vs Goals

    Leave a comment

    March 14, 2017 by Kenneth Fisher

    It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us. …
    Continue reading

  5. Using GROUP BY instead of DISTINCT

    6

    March 6, 2017 by Kenneth Fisher

    Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
    Continue reading

  6. Queries with optional parameters

    10

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

  7. What’s in my backup file?

    Leave a comment

    February 22, 2017 by Kenneth Fisher

    Restoring a backup file is pretty easy right? Ok, but what if more than one database backup is stored in …
    Continue reading

  8. Deadlock on ALTER DATABASE

    3

    February 16, 2017 by Kenneth Fisher

    I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
    Continue reading

  9. Server level database permissions

    4

    February 14, 2017 by Kenneth Fisher

    Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a …
    Continue reading

  10. Deadlock priority

    5

    February 8, 2017 by Kenneth Fisher

    Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
    Continue reading

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

Join 1,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013