Tag Archives: microsoft sql server

  1. Two years!

    2

    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

  2. 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

  3. 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

  4. 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

  5. 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

  6. The clustered index columns are in all of the non clustered indexes.

    9

    July 30, 2014 by Kenneth Fisher

    Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
    Continue reading

  7. Why am I getting a primary/unique key violation?

    3

    July 23, 2014 by Kenneth Fisher

    This may seem like a question with a simple answer but there is a bit more to it than you …
    Continue reading

  8. Add them to ALL the roles!

    3

    July 21, 2014 by Kenneth Fisher

    I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
    Continue reading

  9. What does it mean that a value is NULL?

    11

    July 14, 2014 by Kenneth Fisher

    Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
    Continue reading

  10. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 333 other followers