Tag Archives: microsoft sql server

  1. What are trace flags?

    Leave a comment

    September 11, 2014 by Kenneth Fisher

    Trace flags are one of those things that I’ve heard about more and more over the last five or six …
    Continue reading

  2. T-SQL Tuesday #58: Passwords

    1

    September 9, 2014 by Kenneth Fisher

    It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
    Continue reading

  3. Pausing an MSSQL Instance

    7

    September 4, 2014 by Kenneth Fisher

    I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop …
    Continue reading

  4. Two simple commands that can be a big help in performance tuning.

    4

    September 2, 2014 by Kenneth Fisher

    The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
    Continue reading

  5. The amazing never shrinking heap

    Leave a comment

    August 25, 2014 by Kenneth Fisher

    This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
    Continue reading

  6. Two years!

    6

    August 20, 2014 by Kenneth Fisher

    Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the …
    Continue reading

  7. Generating a restore script

    3

    August 18, 2014 by Kenneth Fisher

    In order to speed up our backups on a large database our team decided to stripe the backup files. In …
    Continue reading

  8. More than sp_help

    1

    August 14, 2014 by Kenneth Fisher

    If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
    Continue reading

  9. SchemaBinding – What & Why

    5

    August 6, 2014 by Kenneth Fisher

    What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
    Continue reading

  10. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 370 other followers