Greg Low

SQL Down Under

Dr. Greg Low is an internationally recognized consultant, trainer and author. He is a SQL Server MVP and a Microsoft Regional Director for Australia. Greg holds a PhD in computer science and is a Microsoft Certified Master for SQL Server. He is the author of a number of Microsoft white papers and is a sought-after presenter. Based in Melbourne, Dr. Low is the CEO of SQL Down Under and is well known for his SQL Down Under podcasts on SQL Server topics. Read his blog here.

DATA TALES #10: It’s a Matter of Existence

I regularly see code that calculates a count of a set of rows then makes a decision that’s based on the count, but only on whether or not the count is zero. Consider this (slightly contrived) example based on AdventureWorks:

Note the query plan that’s returned for the SELECT:

DATA TALES #9: The Case of the Database Diet (Part 4)
In this final article, I’ll look at two areas that consume a great deal of space within a database, and what you can do about it.
DATA TALES #8: The Case of the Database Diet (Part 3)

This is the 3rd article in a series on a database that needed to go on a diet for the new year.

Data Tales 7: The Case of the Database Diet Part 2
This month, we’ll start by looking at how ROW compression actually works, then look at the greater savings from PAGE compression. We’ll also look at how it works internally.
Data Tales: The Case of the Database Diet (Part 1)
DATA TALES #6: The Case of the Database Diet (Part 1) (in which Dr. Greg Low begins his plans of placing a VLDB on a diet...
Data Tales #5: The Case of the Rogue Index 2

It can be painful to see performance problems caused by poor or inappropriate indexing choices without the ability to make strategic indexing changes. In some cases you can though...

Data Tales #4: The Case of the Phantom Duplicate 1
Our intrepid DBA is attempting to enter a new value into a table and is getting an error due to violation of a unique constraint even though the value does not yet exist in the table. What could possibly be causing this?
Data Tales #3: The Case of the Stubborn Log File
The transaction log continues to grow despite regular backups. Diagnosing the issue and preventing it from happening again is what this case is all about.
Data Tales #2: The Case of the Exploding Table 1

I was recently at a customer site where the developers were very concerned about the impact of adding columns to a table. They told me that when they added a new column that their deployment code was timing out and the database was massively increasing in size. It had increased from around a small size to well over 50GB during the single operation. The deployment operation involved adding the column and writing one row to a deployment history table. Because they were only writing a single new row, they were blaming SQL Server for bloating the database size when a column was added.

Data Tales #1: The Case of the Auto-Truncating Table

I have a number of clients that I spend a day or two with each month. I like this style of engagement as I get to know the staff and their systems over a period of time, can see the improvements that we make over time. The staff members also know that if they have issues that aren't desperate, they can save them up for the days that I am onsite. When I arrived at one of these customer sites recently, several of the staff members had grins on their faces, and one told me that Terry (well let's call him Terry anyway) had really broken something.

Configuring SQL Server 2008’s Resource Governor 1
Prevent database performance problems by using Resource Governor to control the CPU and memory allocated to applications.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2016

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×