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

Archives: July 2011

PowerPivot – Creating Hierarchies

Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies are useful because it allows a single click for a user to bring in all the fields that exist in a natural table hierarchy.  Normally the user would have to… Read more

7 comments, 4,824 reads

Posted in Devin Knight on 31 July 2011

Spoke at #sqlsat81

I presented two sessions this weekend in Birmingham AL at SQL Saturday 81.  I was in the first slot of the day with my “You Inherited a Database, Now What” session.  The room was pretty full so I was excited.  I had a great group that was very interactive.

My… Read more

0 comments, 1,447 reads

Posted in Tim Radney - Database Professional on 31 July 2011

The Good, the Bad and the Ugly SQL Cursor types

T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking and windowing functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE) and other tools, you have really few moments where cursor is better solution. On the other hand, there are still scenarios where cursor… Read more

0 comments, 1,912 reads

Posted in SQL Treeo on 30 July 2011

Lookup functions in SSRS 2008 R2 - III


This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already been discussed in my previous posts.


Multilookup(source_expression, destination_expression, result_expression, dataset)

source_expression – The field which will act as the key/lookup value for the destination. This will be…

Read more

1 comments, 11,177 reads

Posted in Juggling With SQL on 30 July 2011

SQL Saturday #85 Orlando

SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the area get ready for awesome because I am coming to town! Ok, that may have been a little over the top but all parts of that thought are in fact… Read more

0 comments, 2,045 reads

Posted in Bradley Schacht on 30 July 2011

SQL Azure – simple description, part I.

I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you clearly what it is, what it costs, what are limitations, what developers can and can’t do etc. There are so many marketing materials, business materials and even very technical materials… Read more

0 comments, 1,756 reads

Posted in SQL Treeo on 29 July 2011

SQL Server Hardware Book News and Reviews

Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very nice review of my book SQL Server Hardware.

That means a lot to me, since I respect Brent, both as a person and as a… Read more

0 comments, 1,475 reads

Posted in Glenn Berry's SQL Server Performance on 29 July 2011

Dual monitors, dual laptops, and the best way to manage them

Here is a tip that could make you much more productive:  At home, I have a desktop computer with dual-monitors (via a HDMI connection and a DVI connection with 1920×1080 resolution.  One monitor is 24-inch, the other 21-inch).  I also have a laptop that I travel with and on that… Read more

0 comments, 2,276 reads

Posted in James Serra's Blog on 29 July 2011

Big Numbers

What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find it) that talked about the Depository Trust and Clearing Corporation, which settles all the equity trades on American exchanges. According to the article the DTC settled 1.48 quadrillion dollars… Read more

0 comments, 1,490 reads

Posted in SQLAndy on 29 July 2011

Thank you PASS Community

This has been a great week for me.  I had a lot of new faces come out for the Columbus GA SQL Users Group meeting Tuesday night as well as being notified that I have been made a PASS Regional Mentor for South Central US. Mark Ginnebaugh sent out the… Read more

0 comments, 1,512 reads

Posted in Tim Radney - Database Professional on 29 July 2011

Modified Insert Unknown Row to Dimension Table

A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension.  This is a great script and i've used it dozens of time, but this week I made a few modifications to it that I thought I would share.

First… Read more

0 comments, 2,782 reads

Posted in Devin Knight on 29 July 2011

Roundup for Un-SQL Friday #005: Bad Interviews

It’s time for the Un-SQL Friday #005 roundup!

From managers…

First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got some excellent advice from the hiring manager’s point of view.   I particularly liked this:

When asked what your biggest weaknesses are, it’s a good…

Read more

1 comments, 1,769 reads

Posted in SQL Awesomesauce on 29 July 2011

Re-blog – July 22-July 28

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts of interest that you may want to check out are:

Read more

0 comments, 1,511 reads

Posted in StrateSQL on 29 July 2011

Calling SCOM in C#

Written by David Postlethwaite

I’m sure there are many out there using System Centre Operations Manager (or SCOM for short) it’s a great tool for monitoring the Windows estate.

One area where it is lacking is updating the subscribers list for a Notification Group – in other words changing the…

Read more

0 comments, 3,941 reads

Posted in The SQL DBA in the UK on 29 July 2011

Marking FK Constraints NOT FOR REPLICATION

When administering Merge Replication, sometimes we need to mark foreign key constraints NOT FOR REPLICATION.  In some cases, we might require replication agent activity to be treated differently from user activity since we cannot guarantee the order of changes that are replicated.  To be more specific, sometimes parent and child… Read more

1 comments, 5,848 reads

Posted in SQLREPL on 29 July 2011

Build a schedule for SQL Saturday

A new feature has been added to SQL Saturday.  Now when you register for an event you can build your schedule on the website.  I used it tonight to build my schedule for SQL Saturday 81.  This will be a huge help for attendees in preparing for their big… Read more

1 comments, 1,422 reads

Posted in Tim Radney - Database Professional on 29 July 2011

Activity Monitor and Profiler

Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain.  That script can be found here.  I was looking at the script and thought it looked pretty cool and also wondered why it… Read more

1 comments, 1,657 reads

Posted in SQL RNNR on 28 July 2011

T-SQL refactoring

Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are being splitted, then joined together again, entities are often renamed several times just because you have better name for them etc. For me, renaming is heart of T-SQL refactoring. But… Read more

1 comments, 2,720 reads

Posted in SQL Treeo on 28 July 2011

How to move Cluster MSDTC Drive

I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive.  Let’s just walk through the basic steps.

The first thing you need to do is… Read more

0 comments, 2,744 reads

Posted in Ryan Adams on 28 July 2011

When Did That Restore Finish?

I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the default trace, I was thinking msdb.dbo.restorehistory and decided to check.

First I hit Books Online. It notes that the restore_date column means: Date and time of the restore operation. Can… Read more

5 comments, 7,584 reads

Posted in The Voice of the DBA on 28 July 2011

Older posts