Blog Archives

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: , , , , , , ,

CTE to Split a String in a function SplitString

Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy

Posted in CTE Book Tagged with: , , , , , , ,

SQL Server – sysmaintplan_logdetail

The check for excessive sysmaintplan_logdetail has be added to the Database Health MonitorQuick Scan Report. If you haven’t had a maintenance plan to clean up maintenance plan history, it can grow excessively over time. I recently worked on a

Posted in Database Health Tagged with: , , , ,

SQL Server – Cost Threshold For Parallelism

The check for Cost Threshold for Parallelism check has be added to the Database Health MonitorQuick Scan Report. The Cost Threshold For Parallelism setting in SQL Server controls the level at which the query optimizer decides to have a query

Posted in Database Health 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