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

Archives: October 2011

I’m a winner!

Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog posted here recently about running totals performance in Denali CTP3 SQL Server 2012, I happened to run across this T-SQL Challenge for doing running totals. On a lark, I posted… Read more

2 comments, 728 reads

Posted in A Discussion of SQL Server-Related Topics on 26 October 2011

Troubleshooting THREADPOOL Waits

Today I want to talk about a specified wait type that can be sometimes very hard to troubleshoot: the THREADPOOL wait type. This wait type is specific to the internal thread scheduling mechanism inside SQL Server.

As you might know SQL Server internally uses its own "operating system" to implement… Read more

3 comments, 10,679 reads

Posted in Klaus Aschenbrenner on 25 October 2011

Import MS Best Practice Policies

Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server.  You can also import policies that you have exported from other servers.  The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by… Read more

0 comments, 948 reads

Posted in Ryan Adams on 25 October 2011

The Basics of Joins – Skill #4

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011.

Databases are built to store data. That’s the primary purpose, and in SQL Server, we store data in a relational form. That means that… Read more

1 comments, 1,196 reads

Posted in The Voice of the DBA on 25 October 2011

Seeing Yourself as Others Do

As life skills go one of the hardest is to see yourself as others do – they apply all kinds of filters and interpretations, and of course we’re often reluctant to let go of our own biases that filter our own vision. It’s easy to get hung up on the… Read more

0 comments, 801 reads

Posted in SQLAndy on 25 October 2011

SQL Server XQuery Against Execution Plans

One of the greatest things about all the DMOs is how you can combine the information they present to you with execution plans. It allows you to see what a query is doing, even as it’s executing, because the plan is created first. I couldn’t possibly emphasize enough how important… Read more

2 comments, 1,956 reads

Posted in The Scary DBA on 25 October 2011

Multiple query plans for the same query?

A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from… Read more

10 comments, 12,557 reads

Posted in SQL Server Notes from the Field on 25 October 2011

Tuesday Hardware Tidbits

There have been a few interesting developments on the hardware front over the past week that I want to cover today. First, Intel has released the new Core i7-2700K processor, which is their new top of the line desktop CPU. It is basically identical to the older Core i7-2600K,… Read more

0 comments, 1,002 reads

Posted in Glenn Berry's SQL Server Performance on 25 October 2011

It’s Your Career

It’s your career. It’s something you have to take ownership of and work on. I know that life is busy, and training budgets are tight. That’s one reason we started SQL Saturday; it’s a way to bring a training event and a conference experience to many people.

I posted this… Read more

6 comments, 1,077 reads

Posted in The Voice of the DBA on 24 October 2011

What is Microsoft TAP and RDP?

Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product updates as well as give important customers a heads-up on what Microsoft is up to.  Participation is by invitation only (usually by someone in Microsoft’s field sales force),… Read more

2 comments, 2,120 reads

Posted in James Serra's Blog on 24 October 2011

Brad or Spot?

Today we have another guest post from Steve Jones.

I’m no expert on animals, but I have a little experience out on the ranch in Colorado. Brad appears to be acting very strangely in the latest episode of DBA in Space. The way he’s drinking water is more reminiscent… Read more

0 comments, 572 reads

Posted in SQL Aloha on 24 October 2011


When completing an installation I saw the following error – which stopped the installation .

The error occurred during the creation of  Indexed View

[2011-10-24 18:21:34.193 02944 error 'App'] A database error occurred: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options… Read more

0 comments, 1,826 reads

Posted in SQLServer-DBA on 24 October 2011

I Can’t Go To Space

If I could win the DBA In Space contest, I’d be all over it like white on rice. But I can’t win (and yes, that grinding sound you hear is my teeth, not tectonic plates). But, one of my friends might. I already know several of them that have entered. Read more

0 comments, 1,374 reads

Posted in The Scary DBA on 24 October 2011

SQL Server 2012 Developers Training Kit

Microsoft has recently released the SQL Server Developer Training kit for SQL Server 2012. The developers kit includes fantastic resources to learning SQL Server. Download it here.

Marc Beacom  ...

Read more

0 comments, 1,716 reads

Posted in Marc Beacom on 24 October 2011

PASS Update #66 (All Good Things)

Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term one year early. It’s a decision I’ve been thinking about since May and explaining it could well consume several posts – though I’m not sure it would be that interesting! Read more

3 comments, 573 reads

Posted in SQLAndy on 24 October 2011


Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. “dbo”  can be changed to whatever schema name required

USE myDb
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name 
FROM sys.Procedures p INNER…

Read more

0 comments, 1,729 reads

Posted in SQLServer-DBA on 24 October 2011

SSIS 2012: Project Reference

One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task.  Open the Execute Package Task Editor and select Package from the left window.  Select Project Reference for the ReferenceType property.

Now you can reference any package…

Read more

1 comments, 2,953 reads

Posted in SQLDownSouth on 24 October 2011

GiveCamp Tampa 2011

This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by Microsoft and other partners. Per GiveCamp’s website:

GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and web strategists…

Read more

0 comments, 941 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 24 October 2011

Deploying SSIS Packages with BIxPress

Same functionality but obvious differences

If you’ve worked with SSIS for any amount of time, you may quickly come to find that the native way of deploying packages can be…cumbersome. The native tools, while helpful, aren’t exactly the most intuitive to setup or use. This post will show you how… Read more

1 comments, 1,260 reads

Posted in SQL Chicken on 24 October 2011

Gaining SQL Server SysAdmin Access

I’ve seen this come a few times at work and I’m sure most you have experienced something similar.

Someone or an application installs SQL Server, doesn’t grant access to the DBA group and asks for DBA support.

In SQL Server 2008 and higher the built-in local administrators group is no… Read more

2 comments, 3,728 reads

Posted in Chad Miller on 22 October 2011

Newer posts

Older posts