Best Practices for Database Schema Design (Beginners)

In this article, we will discuss a few common design decisions when defining a Schema. We’ll focus on the planning stage. There are many opinions about what is ‘best’. Here we discuss some basic guidelines which may or may not be best for your specific needs. There are two primary ways a database is used. One is Online Transaction Processing (OLTP) and the other is […]

DBCC loginfo, VLFs and SQL2000 and earlier.

I was reading Paul Randal and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL […]