Blog Archives

Drop a trigger after a specific date

  The question of how to delete a trigger after a specific date came up.  Here is what could be done. If you want to trigger to disappear after a specific date or time, you can just drop the trigger

Posted in TSQL Tagged with: , , ,

How Many VLFs is Too Many?

Here is an error that popped up in the SQL Server error log today: 5/6/2016 10:10:10 AM spid22s Database [DatabaseName] has more than 10000 virtual log files which is excessive. Too many virtual log files can cause long startup and backup

Posted in Performance Tuning Tagged with:

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

RAID10 Saved The Day

Reliable DBA Services is one of the things I talk about on my business website at http://StedmanSolutions.com, but that can mean many things to different people. To me this has many meanings. Today the reliability of having RAID10 on my

Posted in Uncategorized 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: , , ,

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