On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base tables in that article. Today, I want to dive into these tables a little bit […]
Tag: SQL Internals
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if there was a correlation. As a […]
Seize the Moment
Today I had a bit of regret slap me in the face. That face slap came from participation in a SQL Quiz on twitter that was hosted by Paul Randal (Blog | Twitter). The questions […]
Physical Row Location
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this evidenced in many ways in the product. A couple of the things that make me […]
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the database was used. For the first […]
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource Database. In SQL 2005 you could […]