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

Archives: September 2012

Nested Partitioned Views

A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we go into the details of this approach and if it could work, I want to give you an overview about the requirements, and why the customer wanted to have Nested… Read more

3 comments, 856 reads

Posted in Klaus Aschenbrenner on 27 September 2012

SQL Server 2012 AlwaysOn now officially supported by VMware

I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked here to include SQL Server 2012 AlwaysOn Failover Clusters. That’s fantastic news! I’ve known it works great for quite a while now, but it’s always nice icing on the… Read more

0 comments, 2,978 reads

Posted in Technobabble by Klee from @kleegeek on 27 September 2012

An Introduction to SQL Server

There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be presenting this coming December in London. Combine some great SQL Server training with the delights of Central London in the run up to Christmas or if you prefer to… Read more

0 comments, 738 reads

Posted in The SQL DBA in the UK on 27 September 2012

No more NebraSQL

After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?)  I have decided to give up on that attempt at being clever and just go to "Nebraska SQL from @DBA_ANDY" 

I have also updated the URL to nebraskasql.blogspot.com - the…

Read more

0 comments, 717 reads

Posted in Nebraska SQL from @DBA_ANDY on 27 September 2012

How BETWEEN is inclusive

This is a old and simple one, but an important subtlety that TSQL developers must be aware of.

Using the BETWEEN syntax is easy enough in a WHERE clause, and it's pretty obvious for numbers.

use testing

create table decbetweentesting
(      id int identity(1,1

Read more

5 comments, 2,648 reads

Posted in SQL Tact on 26 September 2012

OVER() clause two simple ways on two different days

I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because I’ve rarely had the need to use windowing functions because I primarily work with XML and relational data that doesn’t need to be aggregated that often or have ranking applied… Read more

0 comments, 1,015 reads

Posted in SQL Server Rocks! on 26 September 2012

Create and setup a SQL clustering on your Desktop or Laptop

How to create and setup a SQL clustering on your Desktop or Laptop


I thought to write this post after I discussed in a forum. SQL clustering is a bit complicated one. I mean most of the DBAs are not configured or tested it, because we don’t get… Read more

14 comments, 1,905 reads

Posted in SQL Server Blog Forum on 26 September 2012

SQL Server: Part 4 : Approaching Database Server Performance Issue

In the last three parts, we have discussed about different queries that can be used to list the current state of the database server. In this post let us discuss about listing execution stats from the plan cache.

The below query will help us to list the CPU intensive queries…

Read more

11 comments, 1,566 reads

Posted in PracticalSQLDba on 26 September 2012

DBMail on a cluster

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days debugging DBMail on an instance on a cluster.  To the best of my ability everything appeared set up correctly but when I tried a test email it wouldn’t send.  The… Read more

0 comments, 562 reads

Posted in SQLStudies on 26 September 2012

T-SQL Window Functions on LessThanDot and at SQL Saturday 149

I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions.  The enhancements to SQL Server 2012 in this area are phenomenal.  They solve a myriad of issues including calculating running totals with SQL.  Check it out if you want to learn more and get some simple…

Read more

0 comments, 835 reads

Posted in DataOnWheels on 26 September 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit.  To help promote women in technology, I’m declaring… Read more

0 comments, 1,031 reads

Posted in Cleveland DBA on 26 September 2012

Participate in the PASS Election Process

Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there are three seats available and five candidates vying for those seats. You can begin the process of learning about the candidates here:

PASS Elections Site

If you want to interact with… Read more

0 comments, 1,000 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 September 2012

One More Reason for Portable Applications

I bet most of us don’t think about installing software that we need/want to try. We’re either running as local admin or we can elevate to local admin as needed. It’s nice to be able to install a piece of freeware or open source that will elegantly solve a problem.… Read more

0 comments, 734 reads

Posted in SQLAndy on 26 September 2012

Come See Us at SQL Saturday #165 in Lincoln!

I will be speaking with several of my House of Brick Technologies colleagues at SQL Saturday #165 in Lincoln in a couple weeks (October 6th):

I am giving my solo presentation on the Ola Hallengren Maintenance Solution and also co-presenting "Virtualizing Business Critical SQL Servers" with our SQL…

Read more

0 comments, 535 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 September 2012

Log File Full–Availability Group Database

I run into an interesting issue with an Availability Group database recently. I was running a data load against a database in an Always On Availability group database in SQL Server 2012.  The load was SSIS package migrating data from staging database when the package fell over with the following… Read more

0 comments, 4,704 reads

Posted in The SQL DBA in the UK on 26 September 2012

SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?

Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He is sharing a problem with Sp_Helptext. He is considering it as a Bug.

Try to rename any procedure in your database by right click. Then modify it. SSMS will… Read more

0 comments, 717 reads

Posted in MSSQLFUN on 26 September 2012

Running a document database on Sql Server

Running a document database on Sql Server.

Since Microsoft is slow to come out with a product of their own to support the growing need for document databases (Yes,I know there are other good products on the market like RavenDB, CouchDB,  MongoDB from other venders). I want to show how…

Read more

1 comments, 13,104 reads

Posted in SQL Development Wizard on 26 September 2012

Excel 2013 – Trouble Installing Silverlight for Power View

Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared multiple times during the Q&A so I thought it would be worth post.

When using Power View in Excel 2013 the first thing you may notice is a screen like… Read more

0 comments, 1,219 reads

Posted in Devin Knight on 26 September 2012

2013 North American PowerShell Summit

The date has been set for the next North American PowerShell Summit.  It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond, Washington.  I’m already secured my spot and if you want to be there you better act fast!  As of… Read more

0 comments, 1,073 reads

Posted in SQLvariant on 25 September 2012

Transferring Table Types

An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move a table type between schemas?”

Suppose I had two schemas:


In one of them, I create a table type and… Read more

0 comments, 1,584 reads

Posted in The Voice of the DBA on 25 September 2012

Newer posts

Older posts