SQL Server with Mr. Denny


February 4, 2009  9:07 AM

Happy Birthday to Me

Denny Cherry Denny Cherry Profile: Denny Cherry

Today is my birthday, so no second technical post from me today.  I’m out with friends having a blast.

(I’m actually at home with my wife playing video games, as most of these blog posts are written well in advance, but it sounds good to say that I logged in to day and wrote this.)

Denny

February 3, 2009  2:47 AM

Rights to System Stored Procedures

Denny Cherry Denny Cherry Profile: Denny Cherry

Why on earth to people want to go changing the rights on the system objects. Continued »


February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?

Denny Cherry Denny Cherry Profile: Denny Cherry

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.

Continued »


January 29, 2009  11:10 PM

First Beta of Standalone SQL Agent released

Denny Cherry Denny Cherry Profile: Denny Cherry

It took me a little less time than I expected to get an acceptable build put together. Continued »


January 29, 2009  7:03 PM

Standalone SQL Agent Status Update (Jan 28, 2009)

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve made some good progress on the Standalone SQL Agent that I’ve been working on. Continued »


January 29, 2009  8:27 AM

SoCalCodeCamp Photos were posted

Denny Cherry Denny Cherry Profile: Denny Cherry

Marc Salsberry has posted some pictures from the SoCal Code Camp on his facebook page.

If you know of other pictures please post links here or on Twitter with the #socalcodecamp tag.

Denny


January 26, 2009  12:00 PM

Back To Basics: What are indexes and what are they used for?

Denny Cherry Denny Cherry Profile: Denny Cherry

A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.

Continued »


January 26, 2009  7:54 AM

How do you source control your database, in your environment?

Denny Cherry Denny Cherry Profile: Denny Cherry

I’m curious about how various people are handling source control in their environment for the database? SSIS, SSRS, etc are all easy. They plug directly into the normal source control providers. But how do you handle SQL object changes like table changes, and stored procedure changes?

Continued »


January 26, 2009  2:06 AM

#SoCalCodeCamp was a blast

Denny Cherry Denny Cherry Profile: Denny Cherry

This weekends SoCal Code Camp was great. Continued »


January 22, 2009  3:00 PM

Viewing SQL Server Plan Guides

Denny Cherry Denny Cherry Profile: Denny Cherry

So you’ve saved a plan guide into your SQL server, and you want to look at the plan.  You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there.  But if you have a full XML query plan that isn’t going to do you a lot of good since SSMS isn’t going to want to show you the all the XML as it is probably longer than it wants to display.

This little query should help you with that.  You may need adjust it slightly to account for extra spaces in your plan guide, I tried to account for double spaces, but if you have more than two spaces anywhere in the top part you’ll need to tweak it.

Continued »


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: