SQL Server with Mr. Denny:

December, 2008

December 15, 2008  9:00 AM

Back To Basics: Getting Data from an XML Document

Posted by: Denny Cherry
Back To Basics, T/SQL, XML

One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...

December 9, 2008  7:43 PM

SQL Quiz: Toughest Challenges

Posted by: Denny Cherry
Brent Ozar, Chris Shaw, Denis Gobo, Tom LaRock

Chris Shaw posted a new SQL Quiz where he asks: “What are the largest challenges that you have faced in your career and how did you overcome those?” I found this question rather tough to answer (as I have when I've...

December 9, 2008  7:17 AM

.NET User Group Slide Deck and Sample Code

Posted by: Denny Cherry
IE .NET User Group, In Person Events

Here is the sample code and slide decks which I'll be using at the .NET User Group tomorrow night. Query Tuning

December 8, 2008  8:42 PM

I’ve finely started using Twitter

Posted by: Denny Cherry

We'll I've finely broken down and started using Twitter. I decided to go all out. I've got TweetDeck for my PCs, and TinyTwitter for my BlackBerry.  I tried

December 8, 2008  1:06 PM

Just how awesome are table parameters in SQL Server 2008?

Posted by: Denny Cherry
CREATE PROCEDURE, SQL Server 2008, T/SQL, Table Variables

I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...

December 4, 2008  7:55 AM

Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)

Posted by: Denny Cherry
Instant File Initialization, Performance Problems, Storage

SQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files). While this is great when creating your database, or extending your database files there is a cost to...

December 3, 2008  8:31 AM

Ask your Exchange Server questions to the Exchange MVPs

Posted by: Denny Cherry

If you are like me you work with Exchange, and probably have to work with Exchange Server at least some times, and you may some all sorts of questions about it.  Well here is your chance to ask some of the top Microsoft Exchange MVPs all those questions.  Combined the MVPs on this chat have over...

December 1, 2008  11:00 AM

SQL Clustering Article in SQL Server Magazine

Posted by: Denny Cherry
Article, Clustering, SQL Server 2005, SQL Server 2008

For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven't already).  When you do be sure to check out the article which I have in the magazine about clustering your SQL Server. For those without a subscription you can sign up for...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: