Featured Post

LionGaze

10 Habits of Successful Senior DBAs that You Can Use Today

Senior Database Administrators (DBAs) through experience develop and practice a variety of habits that become key contributors to their success. Here are 10 habits of successful DBAs that you can begin to put to work for you right away. Habit #1: Use Free SQL Server Tools What if I told you that you can get [...]

Latest Posts

Santech Solutions - Affordable SQL Server services

SQL Server Memory Configuration, Determining MemToLeave Settings

Determining the appropriate memory configuration for a SQL Server platform is a task that all database administrators are required to perform. It is essential to ensuring that an appropriate level of performance can be provided. I am going to discuss some of … [Read More...]

SQL Server Stuff Discovered This Week

Virtualisation As you may already know, I am big fan of the work of Brent Ozar, a talented SQL Server professional and online author of excellent quality SQL Server content. I particularly enjoy his podcast series and think the clear, direct style of his … [Read More...]

Figure 1: Select Top query, with no index.

Performance Comparison of (SELECT TOP 1) Verses MAX()

I recently came across a post on Stackoverflow regarding the performance of using a SELECT TOP 1 query in comparison to using the MAX() function.My initial thoughts on this were that the MAX() function would provide the best performance however, in order … [Read More...]

Finding Bad Indexes Using SQL Server DMVs

Today I want to show you how to go about finding bad indexes. SQL Server indexes are often promoted as the answer to all of our performance optimisation needs. It may then surprise you to hear that indexes can also be bad for performance."What are you … [Read More...]

error_button1

What is your biggest SQL Server mistake?

You know the one I am talking about.We have all been there at some point. You get that awful feeling of dread as a chilling realisation sets in and you ask yourself, oh my god did that actually just happen.Sure you can laugh about it now though, right. … [Read More...]

New SQL Server Resources

   One of the joys of working with SQL Server technologies is that there are some truly great knowledge resources available for use. You just have to know where to look. With the volume of information available it can be difficult to sift out … [Read More...]

Disaster Recovery Planning – Getting Started

The starting point for a rock solid disaster recovery (DR) strategy is to establish what the true cost of server/platform downtime would be to the business. The project will require you to collaborate with your key business decision makers and you will need … [Read More...]

Stackoverflow addiction

Well I suppose it was both inevitable and only a matter of time before I became the next victim of Stackoverflow addiction! I hold BrentO fully responsible for this devourer of my valuable free time. For it was he who introduced me to what is quite … [Read More...]

Here is a Wordle for this site

Wordle seems to be doing the rounds on the SQL Server blogs and community resources at the moment so I thought I would knock one up for this site. … [Read More...]

TempDB configuration, optimal number of data files to use

Have you ever wondered what is the optimal configuration for your tempdb database within SQL Server?There is often significant debate surrounding this subject and so Paul S. Randal, discusses using multiple files for a user DB on a multi-core box in an … [Read More...]

Hidden RBAR: Triangular Joins

No matter how good a T-SQL programmer you think you are, it is always good to revisit the basics every once in a while and to ensure that you keep your high quality coding standards in check.One of my favourite series of articles regarding good T-SQL … [Read More...]

Performance Dashboard Report – Datatype Overflow Error

When you try to execute the Performance Dashboard Reports for the first time, you may be presented with an error of the form:"the difference of two datetime columns caused overflow at runtime"This is because the DATEDIFF function returns an int value … [Read More...]

What makes an exceptional DBA?

When attempting to define what makes a good Database Administrator, understandably the focus is often placed on the technical skills that are deemed to be required. There are plenty of great resources available on the net that can be used to research this … [Read More...]