Blog Archives

Updating SQL Server Statistics

Updating SQL Server statistics may not be as obvious as it may sound. Imagine this scenario. I invite you over for dinner and a game of Scrabble. After dinner, I start to do the dishes, while you set up the

Posted in Performance Tuning Tagged with: , , , , , , ,

Is enabling xp_cmdshell a security risk?

After listening to a podcast from Carlos L Chacon (twitter) at SQL Data Partners interviewing Sean McCown (twitter) and some lively discussion on xp_cmdshell, I decided it would be a worthy enough discussion to create a blog post. At a

Posted in SQL Server Tagged with: ,

Database Corruption Webcast – May 3rd

Please join Carlos L Chacon and I for our first Database Corruption webcast on May 3rd. I have teamed up with Carlos and we will be presenting some thoughts on database corruption with an extended Q&A session. Carlos is with SqlDataPartners, and

Posted in Corruption Tagged with: , , ,

DBCC ShrinkDatabase – I want to shrink my database.

TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different

Posted in DBCC Commands Tagged with: , , , , , , ,

GE Centricity EMR Performance Tuning.

I have been doing work with multiple clients using the GE Centricity EMR product which makes extensive use of Microsoft SQL Server. The performance issues that you run into with Centricity are very similar to what I see working with

Posted in Performance Tuning Tagged with: , , , , ,

SQL Server 2005 End of Life – End of Support Today

Today marks the end of life of SQL Server 2005, originally release in November of 2005, this product has finally come to its end of life point. One of my favorite features that was introduced in SQL Server 2005 was

Posted in SQL Server Tagged with: , , ,

Visualizing Log File VLF Sizing

One of my favorite queries this week is the following query that creates a text based bar chart to quickly help visualize the VLF files on any database log file. In the last month I have given the “TempDB Do

Posted in Performance Tagged with: , , , , , , ,

TempDB – Do This and Don’t Do That

Today I am presenting my “TempDB – Do This and Don’t Do That” session at SQL Saturday Redmond. Here is the download of the presentation and samples. StedmanTempDbPresentation.zip   Some of the sample code from the session:   I hope

Posted in SSIS Performance Tagged with: , , , , ,

A year in review – The first year of Stedman Solutions, LLC.

The TL;DR summary: Life is good, business is good, and I am loving it. Ready to roll with Year 2 of Stedman Solutions, LLC. The Details It has been an interesting year.  I officially formed the business about 3 years

Posted in Uncategorized Tagged with: , , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives