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

Archives: March 2011

PASS Subcommittee

In February I posted this post about the need for Volunteers for SUMMIT 2011.  I submitted my application to volunteer.  This past week I got word back concerning that application.  I am pretty happy that I have the opportunity once again to serve on a subcommittee for the upcoming SUMMIT. Read more

0 comments, 1,529 reads

Posted in SQL RNNR on 31 March 2011


Do you use NULLIF?  For me, this command has been seldom used.  Because of that, I have been dabbling with it a bit lately to make sure I have a better understanding of it.

What is it?

This is a function that compares two values.  If the two values are… Read more

22 comments, 3,866 reads

Posted in SQL RNNR on 30 March 2011

Do You Solution?

Do you ever find yourself working on different scripts at once?  Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts you are working on, and possibly three or four scripts related to a project at work.  I find myself in a… Read more

3 comments, 899 reads

Posted in SQL RNNR on 29 March 2011

ShowPlan XML

I just ran into something that I hadn’t noticed in SQL Server.  It struck me as somewhat interesting but is really not too big of a deal.

While demonstrating that the XML plan can be generated when you dump data into a temp table, I happened onto this little ditty.… Read more

0 comments, 1,807 reads

Posted in SQL RNNR on 28 March 2011

Tools note

I was asked a few months ago to allow some advertising on my blog.  I hadn’t given the idea a whole lot of thought but was reminded again today about the request.  For now, I think I will just give the requester a mention and add the tool he wants… Read more

0 comments, 823 reads

Posted in SQL RNNR on 24 March 2011

SQL Server Startup

From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the database was used.  For the first question there is a pretty common answer that works for SQL 2000 and up.  In… Read more

5 comments, 1,505 reads

Posted in SQL RNNR on 23 March 2011

SQL Resource

By now, I am sure that you are well aware of the Resource Database.  Starting with SQL Server 2005, a new system database was made available – the Resource Database.  In SQL 2005 you could move the Resource Database – but in 2008 and beyond you cannot.  If you plan… Read more

0 comments, 826 reads

Posted in SQL RNNR on 22 March 2011

Dedupe Data CTE

As a DBA working with SQL Server, some data issues arise that need to be fixed.  One such data issue is the duplication of data.  Duplicate data can happen for a number of reasons.  One such reason is the absence of constraints such as Primary Keys.

Luckily, there are ways… Read more

1 comments, 1,301 reads

Posted in SQL RNNR on 21 March 2011

Database Tools Follow-up

After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered.  In thinking about this, I found myself trying to find a script that I knew I had seen and that I wanted to… Read more

0 comments, 596 reads

Posted in SQL RNNR on 18 March 2011

Database Tools

Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking.  Those posts work well in conjunction with a post several months back that you can read here.  These posts made me think a bit harder about the tools… Read more

16 comments, 4,377 reads

Posted in SQL RNNR on 17 March 2011

SQL Server Standard Reports Winforms

In SQL Server, there is a good set of preloaded reports to help you monitor the Instance.  These reports can be found under the Standard Reports and can be reached via context menu.  To find them, right click your Instance in Object Explorer from within SSMS.  Then navigate the context… Read more

3 comments, 2,741 reads

Posted in SQL RNNR on 16 March 2011

March 2011 S3OLV Meeting Recap

The Las Vegas SQL Server Users Group met on March 10, 2011.  The meeting was both virtual and in-person.  Good news – we had just about as many person attending online as we did in the meeting room.

As I had announced, we had the pleasure of listening to… Read more

1 comments, 707 reads

Posted in SQL RNNR on 15 March 2011

DB Benchmarking

As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance.  When benchmarking, it is preferable to get a baseline and then run the same benchmark tests on a periodic basis and compare those results to the baseline.

Recently I was reminded of… Read more

0 comments, 1,085 reads

Posted in SQL RNNR on 14 March 2011

SQL Bitwise Operations

How many DB professionals have never had to deal with bitwise operations in SQL Server?  Who has never had a single value in the database represent more than one data value?  Have you ever had one of these fields serve as the(implicit or explicit) foreign key to a source table? Read more

3 comments, 2,800 reads

Posted in SQL RNNR on 10 March 2011

Database Maintenance

I often see a request for some scripts to help with database maintenance.  Sometimes those questions come in the form of recommendation requests for maintenance plans.  As many already know, there are some really good recommended scripts by Ola Hallengren.  There is also the fantastic index defrag script by Michelle… Read more

4 comments, 1,025 reads

Posted in SQL RNNR on 9 March 2011

T-SQL Tuesday #016: Aggregates and Statistics

Data Size Collection and Analysis

By now you should be well acquainted with this phenomenon we call TSQL Tuesday.  This party is being hosted this month by Jes Schultz Borland (Twitter Blog).  She has challenged us to write something about aggregations and aggregation functions in SQL Server. Read more

0 comments, 669 reads

Posted in SQL RNNR on 8 March 2011

March SSSOLV Reminder

This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST.  You can find more information about the event from here.

I am looking forward to this presentation.  I think this presentation can be highly useful for both Production DBA as well… Read more

1 comments, 458 reads

Posted in SQL RNNR on 7 March 2011

Having Cake and Eating it Two

In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes.  There was a lot of good feedback from that.  You can go back and read it from here, if you like.  This is a short follow-up to that article.… Read more

0 comments, 507 reads

Posted in SQL RNNR on 4 March 2011

Re-purpose my TableSize Script

Last Year I introduced a couple of scripts that I worked on.  Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the retrieval of table sizes in SQL Server.

I pulled out one of those scripts recently… Read more

2 comments, 450 reads

Posted in SQL RNNR on 3 March 2011

S3OLV March 2011

The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server.  We have that opportunity because it is time for the monthly S3OLV User Group meeting.

This month, Glenn Berry of SQL Server MVP fame has volunteered to present… Read more

2 comments, 546 reads

Posted in SQL RNNR on 2 March 2011

Older posts