What do you do when a developer comes to you and asks, “Where did the database go? The database was there one minute, and the next it was not.” Only one thing could be worse than the feeling of losing a database on your watch, and that would be losing a production database. It’s like […]
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor and may or may not […]
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling it a directive* and not a hint) is loved and idolized by vendors, applications, developers, and upper management alike. The reasons for this vary from one […]
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking when the data file(s) grow(s). Many will argue that there is nothing worse than not knowing when a database-related file changed in size except maybe when […]
One of the things that would be nice to know is around the trace flags that can be enabled in SQL Server. There are trace flags (or knobs) for so many different things within SQL Server that it would be nice to get a handle on them if they do happen to be enabled or […]
A mystery staring arithabort.
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous clients. The code was pretty straightforward and addressed a concern for the client. Having used it for several previous clients, I felt pretty confident in the code. The main purpose was […]
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.
Today I want to share a couple of examples. We will take a look at examples of […]