SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2010

SQL Server Instance Checklist

This is my third in a series of checklists that I am putting together for a new book designed for DBAs to help audit their SQL Server instances. Previously I blogged about my SQL Server Hardware Checklist and my SQL Server Operating System Checklist. The goal of this checklist… Read more

2 comments, 2,670 reads

Posted in SQL Aloha on 29 June 2010

ASK SQLServerCentral - The New Community Model

We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange (SE) to an alternative, OSQA.net, without informing any of the people that work on the site. Needless to say this wasn’t a seamless transition, but it was fairly smooth. The… Read more

3 comments, 887 reads

Posted in The Voice of the DBA on 29 June 2010

Function Calls are Evil Incarnate

The following queries look extremely innocent. However, they are all application killers once the target table grows to more than a couple thousand rows:

Select Count(*) From Person_Data Where Upper(Name_Last) = ‘SMITH’

Select Avg(Collar_Size) From Person_Data Where dbo.MyFunc(Person_Data_ID) > 500

For each of these statements, a table scan will be… Read more

7 comments, 1,247 reads

Posted in SQL Coach on 28 June 2010

AWOL: DBA Turned Gardener Temporarily, but Still Obsessed with Transaction Log Files

After 10 Years, a Move Closer to School and Work
Wow, how moving house interrupts life. I can appreciate we have not had to move about more frequently! Background: Starting at the beginning of May, a month prior to moving, my sage wife Victoria insisted we start the packing…
Read more

0 comments, 479 reads

Posted in The Database Hive for SQL Server DBAs on 28 June 2010

PASS Update #35

It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS related items and probably 60+ hours for the month:

  • Reviewing the annual budget
  • A call on SQLSaturday to work on plans for 2011
  • Tons of time on the Spring Event

Read more

0 comments, 661 reads

Posted in SQLAndy on 28 June 2010

First Performance Virtual Chapter Webcast

Thanks to the outstanding efforts of Tim Edwards (twitter | blog), our fearless leader, and the rest of the crew, the PASS Performance Virtual Chapter is rolling and we've started to make ourselves known through various on-line media. It gives me great pleasure to pass on that we're having… Read more

In-Memory Databases (IMDBs)

Moore’s Law tells us that CPU’s get a LOT faster over time.  Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time.  Overall, the main methods of storing data since the 1960’s, magnetic tape and hard disks, have improved… Read more

0 comments, 552 reads

Posted in Kevin E. Kline on 28 June 2010

DB2 Editions

This is a little bit off topic for me but on Friday I was asked to look at a DB2 instance and sort out some issues with the CPU maxing out. Make no mistake I’m no DB2 expert, but I have done some small pieces of work on it previously,… Read more

2 comments, 631 reads

Posted in The SQL DBA in the UK on 28 June 2010

Kent Sql Server UserGroup

One of my back burner projects is to setup a local user group.  I'm delighted to now say that this is up and running.  Over the next few months, I hope to provide some great quality sessions and also provide some ‘virgin’ speakers, myself included, with an environment to practice.  If… Read more

0 comments, 360 reads

Posted in Dave Ballantynes blog on 28 June 2010

Time to Stop Settling

“...And the world is filled with people who can't go to high school, never mind college, and who certainly can't spend their time focused on whether or not they get the good parking space at work.

And so, the obligation: don't settle.
To have all these advantages, all this momentum,…

Read more

4 comments, 602 reads

Posted in Wise Man or Wise Guy on 28 June 2010

Making a Little Effort at Networking - Part 1

I’m not a big networking person. I know that it’s good for my career, but I’ve been lucky enough to get myself fairly well known, my picture is on daily emails from SQLServerCentral, and so a lot of people know of me. As a result, I don’t have to… Read more

0 comments, 696 reads

Posted in The Voice of the DBA on 28 June 2010

MDX Puzzle #1 Solution

OK, are you ready to start the MDX journey.  In MDX Puzzle #1 posting I presented you with the challenge of writing an MDX query based on the requirements that I outlined in that posting.  In this solution and all subsequent solutions I will walk you through the process of… Read more

1 comments, 800 reads

Posted in SQLDownSouth on 28 June 2010

SQL 101 : Without “ORDER BY”, order is not guaranteed.

It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not guaranteed. Oh sure , there may be situations where the data looks like it is being returned ordered, but this is not really the case. So, for example :


Read more

0 comments, 656 reads

Posted in Dave Ballantynes blog on 26 June 2010

Error Configuring DataCollector: A collection set cannot start without a schedule

Data Collection, Puppy Style

Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some more details which hopefully make the situation clearer.


When setting up data collection using the GUI, configuration failed halfway through setup. At the point  of failure I… Read more

2 comments, 1,442 reads

Posted in LittleKendra on 26 June 2010

The ‘addicted to data’ decade is still in its infancy

“Content is king” is the golden rule of the SEO. The semantic web is all about data.  Any web or traditional application has no value without data. Few people have discussed the future of Data, Pat Halland being one of the most prolific ones. Data is and will be everything: Read more

0 comments, 635 reads

Posted in The Future Computing Appliances and SQL Server on 26 June 2010

Don't Do This

In working on applications at client sites you tend to come across code that makes you think "what were they thinking"? This week I found one that just made me do the "facepalm": select top 1 @_StateTrueKey = OverEngineeredKey from OverEngineered where...(read more)

Read more

0 comments, 860 reads

Posted in Allen White on 25 June 2010

Powershell Fundamentals

I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell 2.0 TFM (makes me laugh, each and every time). I’m not even going to attempt to try to teach you some of the amazing information Don has… Read more

0 comments, 1,985 reads

Posted in The Scary DBA on 25 June 2010

How much memory is each SQL Server database using?

Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify how much memory is being used by SQL Server on a per database level.

As you know SQL Server stores database data and index pages in memory in an area… Read more

0 comments, 509 reads

Posted in John Sansom - SQL Server DBA in the UK on 25 June 2010

What Has Jack Been Up to?

It has been awhile since my last post mainly because I was on a working vacation in northern New England with limited internet access, but also because I wasn’t sure what I wanted to write about. 

Working Vacation

You may be wondering how a technical professional can have a working… Read more

2 comments, 430 reads

Posted in Wise Man or Wise Guy on 25 June 2010

Lock Pages in Memory

It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging out SQL Server memory.

how do you do this?

Well, the answer is straight forward...If you have SQL Server Enterprise Edition:

You allocate the service account running SQL Server the… Read more

5 comments, 9,238 reads

Posted in The SQL DBA in the UK on 25 June 2010

Newer posts

Older posts