Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links


This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog


Post Categories

About me

SQL Server

Commentary and tips and tricks for the Microsoft SQL Server product
SQL Server Upgrade Technical Reference Guide

So, you are considering upgrading to SQL Server 200x from a previous version. What are some of the key issues that you need to consider, or at least be made aware of, prior to upgrading? Fortunately the heavy lifting of answering that question has already been done for you. It's available to you in the form of an Upgrade Technical Reference Guide. There's one available for upgrading to SQL Server 2008 and one for SQL Server 2005. SQL Server 2008 Upgrade Technical Reference Guide SQL Server 2005 Upgrade Technical Reference Guide Of course, you'll...

posted @ Monday, March 02, 2009 12:28 PM | Feedback (21) | Filed Under [ SQL Server ]

SQL Server Support in a Hardware Virtualization Environment

Early this morning, Bob Ward of Microsoft PSS SQL Support fame authored a post on the PSS Support blog entitled "SQL Server Support in a Hardware Virtualization Environment". As always, Bob's comments are helpful. In the post, he clarifies and elaborates on Microsoft's official position on support for a SQL Server system in a Virtualized environment. I normally just twitter interesting links such as this, however given all of the questions and uncertainty of virtualization recently, I thought this on warranted its own blog post, too. Here's the link - Cheers! Joe

posted @ Wednesday, October 08, 2008 6:59 AM | Feedback (3) | Filed Under [ SQL Server ]

Using Covering Indexes to Improve Query Performance

My latest Simple-Talk article is live. It's entitled Using Covering Indexes to Improve Query Performance. Let me know what you think and if you'd like to see more articles/postings on similar topics. Cheers! Joe

posted @ Tuesday, September 30, 2008 8:14 AM | Feedback (1) | Filed Under [ T-SQL SQL Server ]

The undocumented sp_MSforeachdb procedure

Late last year, I posted a blog that described the undocumented sp_MSforeachtable stored procedure in Microsoft SQL Server and how it could be used to execute commands on each table within a database. The examples I gave were executing DBCC CHECKTABLE and EXECUTE sp_spaceused() for each table in a given database. But there's another undocumented stored procedure designed for iteration. This one allows us to iterate through each database in a SQL Server instance. It's called sp_MSforeachdb. It's usage is very similar to that of sp_MSforeachtable; simply execute the stored procedure, passing it the command that you'd like to execute as...

posted @ Wednesday, August 27, 2008 5:28 PM | Feedback (14) | Filed Under [ T-SQL SQL Server ]

SQL Server locks: a sleeping process still holds them

Fellow SQL Server enthusiast and online friend of mine, Jonathan Kehayias is very active in the MSDN Forums. He frequently provides good, insightful information to those seeking advice. In response to a recent question in the Database Engine Forum, Jonathan provided a good example how a process marked as sleeping can still hold locks on a SQL Server resource. I'd like to share a slightly modified version of it with you; you can read his original postings here. Let's consider a very simple table in tempdb. Use SQL Server Management Studio to execute the following query: USE tempdb ; GO --create a table...

posted @ Thursday, August 14, 2008 7:59 AM | Feedback (11) | Filed Under [ T-SQL SQL Server ]

SQL Server Virtualization

Next week at the Nashville SQL Server User Group, John Rives of Amniox is going to speak about using SQL Server with clustered virtualization. Unfortunately, I'm not going  to be able to attend due to a prior commitment, however I have spoken with John about his presentation and it definitely sounds promising. If you're in the area, I'd encourage you to come on out. I certainly wish I could be there. I don't have any SQL Servers in a virtualized environment. In fact, I have only worked with one company that does, and that is on a very underutilized server with...

posted @ Sunday, August 10, 2008 1:18 PM | Feedback (11) | Filed Under [ SQL Server Current Events Community ]

Download SQL Server 2008

As Geoff and Derek have already posted, SQL Server 2008 was released to manufacturing (RTM'd) yesterday. Eager to get the bits? They're available from the MSDN download site. Cheers! Joe

posted @ Thursday, August 07, 2008 8:22 AM | Feedback (133) | Filed Under [ SQL Server Current Events ]

Microsoft SQL Server Reporting Services online resources

Thanks to everyone who attended my SSRS class in Charlotte this week. As promised, here is a list of online resources that may prove useful to you as you work with Reporting Services. Reporting Services Tutorials Reporting Services Samples on Codeplex Reporting Services Developer Info Center Beginning SQL Server 2005 Reporting Services Simple-Talk article series by Steve Joubert  Microsoft MSDN Reporting Services Forum TechNet SQL Server TechCenter MSBI Central Additionally, the following...

posted @ Wednesday, July 23, 2008 5:02 PM | Feedback (14) | Filed Under [ SQL Server Community Reporting Services ]

Working with tempdb

I was searching for something online the other day and stumbled upon this TechNet article - Working with tempdb in SQL Server 2005. It's a good little article and I wanted to share it with you. Enjoy! Joe

posted @ Thursday, June 19, 2008 6:11 AM | Feedback (3) | Filed Under [ SQL Server ]

The 33 languages of SQL Server

I was recently perusing the the MSDN SQL Server forums and noticed a question about localization of Microsoft SQL Server messages. I replied to the post with a mention of the sys.messages table - the table where SQL Server messages are stored. I blogged about this system table a few months ago. Afterward I started playing around some more with the sys.messages table. I started with the following basic query.   The first thing to notice is that each message_id has one or more languages associated with it. Message_id 21, for example, has a row for language_id 1033, 1031, 1036,...

posted @ Friday, May 30, 2008 3:54 PM | Feedback (6) | Filed Under [ T-SQL SQL Server ]

Full SQL Server Archive

Powered by:
Powered By Subtext Powered By ASP.NET