Monthly Archives: November 2014

  1. Who’s on call

    Leave a comment

    November 26, 2014 by Kenneth Fisher

    Originally posted on SQL Studies:
    Every morning we have a daily meeting and my manager asks who’s on call. And every…

    Category: Microsoft SQL Server

  2. Putting sp_ at the beginning of your stored procedure.

    1

    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, System Databases, System Functions and Stored Procedures, T-SQL | Tags: , , , , ,

  3. You don’t really need ORDER BY do you?

    8

    November 19, 2014 by Kenneth Fisher

    You see dozens of blog posts and articles about how the order of a result set is not guaranteed without …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , , ,

  4. Using T-SQL to populate a Central Management Server

    6

    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    Continue reading

    Category: Central Management Server, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , , , ,

  5. Adding a column to the primary key.

    13

    November 13, 2014 by Kenneth Fisher

    Every now and again you realize that the primary key for a table does not uniquely describe a row. Not …
    Continue reading

    Category: Index, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , ,

  6. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?

    6

    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

    Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL Tuesday | Tags: , , , , , , ,

  7. How to remove additional (unwanted) log files

    4

    November 5, 2014 by Kenneth Fisher

    Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a …
    Continue reading

    Category: Log File, Microsoft SQL Server, SQLServerPedia Syndication | Tags: ,

  8. My DTS Package won’t load with the error “here were errors loading package”

    Leave a comment

    November 3, 2014 by Kenneth Fisher

    You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error: …
    Continue reading

    Category: DTS, Microsoft SQL Server, SQLServerPedia Syndication | Tags: ,

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

Join 3,155 other followers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013