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

Archives: December 2010

A Collection of Good Information About Controlling VLFs in SQL Server

Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log files inside the transaction log file.

Even though I have… Read more

0 comments, 527 reads

Posted in Glenn Berry's SQL Server Performance on 27 December 2010

MCM Live Blog – Week December 27

Watching videos?! Su-ure!

Time for the third week of blogging about the things that I’m doing to study for the MCM exam. Last week wasn’t too spectacular – with the holidays and all I was pretty lazy on the studying.  The formatting issues did get fixed, so if you see… Read more

1 comments, 509 reads

Posted in StrateSQL on 27 December 2010

Meet a New Blogger: Malathi Mahadevan

My friend Malathi (Mala) Mahadevan has chaired the Louisville PASS Chapter for the past couple years, and will be heading up their second SQLSaturday in January 2011. She’s started a blog at http://beyondrelational.com/blogs/diligentdba/default.aspx that I wanted to share. Getting started and finding your voice takes time, hope you’ll follow along… Read more

1 comments, 864 reads

Posted in SQLAndy on 27 December 2010

Why I’m All For 24HOP Showcasing 24 Women Speakers

This is not the HOP you are looking for.

I’ve been thinking about the upcoming 24HOP event planned for March 15 and 16 which will showcase 24 women speakers. Karen Lopez (post | twitter), Jenn Stirrup (post | twitter), and Jen McCown (post | twitter Read more

0 comments, 879 reads

Posted in LittleKendra on 27 December 2010

Rebuilding my laptop

I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive with an SSD. Now he hard part: rebuilding the machine.

In order to use the 16GB, and get VMs to run more smoothly, I need 64 bit Windows 7. I…

Read more

2 comments, 737 reads

Posted in The Voice of the DBA on 27 December 2010

MVP Program

There is one thing that have been bothering me for quite some time. I thought I would blog about it. (And make some enemies in the process :-))

The thing that bothers me is the working of the MVP Program or the lack of it. I have noticed at least… Read more

12 comments, 1,153 reads

Posted in RumblingDBA on 27 December 2010

The Twelve Days of (SQL) Christmas

Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.

On the twelfth day of Christmas Stuart… Read more

2 comments, 1,822 reads

Posted in The Voice of the DBA on 27 December 2010

Script Drop all tables of a database

Hi people, following a script that deletes all tables in a database. Enjoy.


(    Seq INT,
    Id INT,
    Name sysname);


-- While there ForeignKey exclude objects that are not referenced recursively


0 comments, 2,006 reads

Posted in Adeilson Brito on 27 December 2010

The MCM Journey

I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some… Read more

7 comments, 776 reads

Posted in The Voice of the DBA on 27 December 2010

SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages

In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise , newbies need to understand concepts on Index architecture before moving on to see what is there inside index pages.

So, before going see internals of Clustered and NonClustered index pages, lets quickly recap some… Read more

11 comments, 9,071 reads

Posted in LivingForSqlServer on 27 December 2010

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to automate many of the traditional daily (or more frequent) checklists*. Although PBM is useable out-of-box there are several key features missing:

  • Unable to capture results of policy evaluations…

Read more

4 comments, 2,172 reads

Posted in Chad Miller on 25 December 2010

Merry Christmas

This is just a short post for a Friday and not just any old Friday either, Santa is on his way :-)



I would just like to wish everybody a very Merry Christmas.

Read more

2 comments, 517 reads

Posted in The SQL DBA in the UK on 24 December 2010

Server Side trace

Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using a server side trace.

Whats special about server side trace?

1) Server Side trace uses much less resources than SQL Profiler.

2) Server side trace runs within the server which…

Read more

0 comments, 413 reads

Posted in SQL and SQL Only on 24 December 2010

Get SQL Scripts Manager for Free

Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes 25 scripts written by many well-known DBAs, such as Ola Hallengren, Louis Davidson, Glenn Berry, Tim Ford, and many more, that can help you to automate common troubleshooting, diagnostic,… Read more

0 comments, 674 reads

Posted in SQL Aloha on 23 December 2010

PASS Summit 2010 Session Eval Results

Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the 2010 PASS Summit arrive in my inbox this week. First I'll show the results, then I'll share some thoughts about them.

Eval Format
Eval forms had 6 questions with a… Read more

0 comments, 971 reads

Posted in Kendal Van Dyke on 23 December 2010

SQL Bits 8

It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th 2011.

Location: The Grand Hotel, Brighton

Read more

2 comments, 463 reads

Posted in The SQL DBA in the UK on 23 December 2010

PASS Summit Speaker Evals – THE ANALYSIS

Rule: No Sushi with Adam within 24 hours of session

I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended… Read more

2 comments, 690 reads

Posted in SQL Awesomesauce on 23 December 2010

PASS Summit 2010 Survey Results

As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit. Feedback is a gift. I received a great many gifts this year and I’m extremely happy about all of them.

There are a set of questions with ratings, the… Read more

2 comments, 714 reads

Posted in The Scary DBA on 23 December 2010

Filling in Data Potholes with Recursive CTEs

Data: it can break your foot.

Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.

In… Read more

0 comments, 1,060 reads

Posted in LittleKendra on 23 December 2010

Spreading the DBA Gospel (from Old English, god spell "good news")


There are times when I wonder why I get so few comments on this blog, however there are assumptions I have made which were confirmed to me recently again by those who wrote to me directly, or spoke with. Some told me that fewer comments are a good thing… Read more

0 comments, 718 reads

Posted in The Database Hive for SQL Server DBAs on 23 December 2010

Newer posts

Older posts