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

Archives: June 2011

Understanding Benchmarks

That Means What?

Inigo Montoya: You keep using that word. I do not think it means what you think it means.
- Princess Bride

If you are like me, you are constantly reading up on the latest hardware. Each site has it’s own… Read more

0 comments, 1,987 reads

Posted in SQL Man of Mystery on 29 June 2011

Energy Efficient Offices

I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation was nicely done, and as part of that they put in some effort to make it energy efficient. Compact fluorescent bulbs in the hallways, some new windows for natural light,… Read more

0 comments, 846 reads

Posted in SQLAndy on 29 June 2011

New Connect Item – TDE

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the TDE backup.

However the documentation doesn’t mention this, and I… Read more

1 comments, 1,116 reads

Posted in The Voice of the DBA on 29 June 2011

Cleaner T-SQL with Table Value Constructors

Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one INSERT statement.

“Standard” option to insert more records is following:

INSERT INTO Continents (Name) VALUES ('Asia')
INSERT INTO Continents (Name) VALUES ('Africa')

With Table Value Constructors… Read more

3 comments, 897 reads

Posted in SQL Treeo on 29 June 2011

A Lost Day

I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night in the wee hours of Monday with cramps in my stomach or intestines and feeling miserable. Slightly better at 7:30am, I got up and tried to work. Even made some… Read more

0 comments, 814 reads

Posted in The Voice of the DBA on 28 June 2011

Getting Ahead and Getting Involved

I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com).  Quite often the question “Where do I start learning more about SQL” will come up where someone has just taken on the role of DBA within his or her organization.  Or possibly it is… Read more

1 comments, 816 reads

Posted in Tim Radney - Database Professional on 28 June 2011

Pain of the Week: Understanding Your Indexes

Want to take a few minutes out of your day on to learn a bit more about indexes?  On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast.  The session will be Understanding Your Indexes: Operational Stats.

There’s a lot that goes on under the covers of…

Read more

1 comments, 824 reads

Posted in StrateSQL on 28 June 2011

Miss SQLBits 8? No problem, all videos are online

OK, since this conference in is England, it’s a little harder to get to compared to TechEd.  No matter, all the videos for this conference are online (65 of them).  Take a look at the recorded sessions at http://sqlbits.com/content/Event8.  All are free to watch!  Included are some excellent sessions… Read more

4 comments, 819 reads

Posted in James Serra's Blog on 28 June 2011

SQLDIY: Database Space Detail

Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure compiles both data and log file usage. This is a fundamental aspect of tracking growth over time and being proactive about growing your databases yourself instead of letting the auto… Read more

1 comments, 514 reads

Posted in SQL Man of Mystery on 28 June 2011

Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!

Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into the fun and chaos setting up the schedule. As always we’re going to try to give everyone one presentation and we’re friendly to first time speakers too!

Reasons to speak… Read more

0 comments, 586 reads

Posted in SQLAndy on 28 June 2011

Let’s Get Registered! Registered!

The PASS Summit is only a few short months away.  But before that happens there is an important deadline fast approaching… the end of the pre-June 30th discount.  For the last few months, you could save $600 off the cost of the regular entry fee.  But on Thursday it all… Read more

1 comments, 634 reads

Posted in StrateSQL on 28 June 2011


Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.. I wish I had a good reference for the function, but the best one I had on SQLServerCentral was this piece on using it to load a data warehouse.… Read more

6 comments, 14,667 reads

Posted in The Voice of the DBA on 28 June 2011

Instead Of Trigger and OUTPUT clause headache

It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead of trigger on it. I would like to offer another workaround I was used recently.
I am talking about fact that you will not succeed with this:

    -- inserting records…

Read more

1 comments, 1,437 reads

Posted in SQL Treeo on 28 June 2011

Which database is using all my CPU

We all know how easy it is to see how much CPU power is consumed by the SQL Server process, tools like Performance Monitor or Task Manager will give you this information very easy.

But have you, like I have, ever wondered which one of your many databases is consuming… Read more

0 comments, 1,610 reads

Posted in SQL Server Notes from the Field on 28 June 2011

My Favourite SQL Server Myths and Realities

It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management topics for last couple of months (just a side effect of my new project lead position).
In parallel, I have started giving session on Performance tuning and Storage internals for my Organization…
Read more

10 comments, 3,505 reads

Posted in LivingForSqlServer on 28 June 2011

Counting Licenses for VMs

This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought I’d put together a post.

In June 2009, Microsoft released an update to SQL Server licensing which can significantly lower TCO for SQL Server instances running under VMs for  not… Read more

13 comments, 2,835 reads

Posted in Chad Miller on 28 June 2011

Why Two Devices

I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and a laptop. The iPad doesn’t double as a backup, but it does let me do things like take notes at events or conferences with an extremely long battery life. My… Read more

1 comments, 860 reads

Posted in The Voice of the DBA on 27 June 2011

MCITP: 3 Down 1 To Go

Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed me down considerably.  It was only today that I realized that it has been one month since the last exam that… Read more

4 comments, 719 reads

Posted in SQL RNNR on 27 June 2011

CPU-Z 1.58 Released

Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging rights in the PC hardware enthusiast community for proving how much you had been able to overclock a particular processor, it is actually very relevant in a professional I.T.… Read more

1 comments, 726 reads

Posted in Glenn Berry's SQL Server Performance on 27 June 2011

Where Do You Go for Authoritative SQL Server Best Practices?

Reprinted from my editorial in Database Weekly.

In early 2000, I started a new DBA job with a large organization, as their first full-time SQL Server DBA. My first job was to clean up the mess left by several accidental DBAs who had gone before me, and who had… Read more

2 comments, 893 reads

Posted in SQL Aloha on 27 June 2011

Newer posts

Older posts