Category: General

• Determine the Uptime of a SQL Server Instance

  

  2010-12-17 - General

  Every once in a while it is helpful to know the time that has passed since a SQL Server instance was last restarted. This information is particularly helpful when dealing with accumulating dynamic management views like sys.dm_db_index_usage_stats. If you do [more…]

• Identifying Test Cases #3

  

  2010-10-04 - General

  ReviewIn the previous two posts, we discussed some ways to look at code and pick out the test cases. These included finding the boundary test cases, input and output classes and special value testing. This time we’re going to take [more…]

• Identifying Test Cases #2

  

  2010-06-15 - General

  Last time, in Identifying Test Cases #1, we looked at some simple examples of identifying test cases for SQL statements. This time, we’re going to look at a more complex example in the form of a database view. Our ExampleSuppose [more…]

• Identifying Test Cases #1

  

  2010-06-08 - General

  It takes a lot of practice to write test cases for SQL code, and much of that practice happens on the job. One of the most important aspects in writing test cases is simply identifying what test cases to write. [more…]

• Index Views: IndexPhysical

  

  2010-02-26 - General

  With this post I am going to start a series about queries that I find helpful while researching indexes and index issues. In fact, because I use them often, I encapsulated them in views. The first one is SATools.IndexPhysical: CREATE [more…]