Category Archives: SQL Server

Relating to MS SQL Server

MSSQLSERVER Service Failed To Start, TDSSNIClient initialization failed with error 0x34, SQL Server could not spawn FRunCM thread

A recent client had this error on their MS SQL Server out of the blue. After much investigation and trial/error to correct. The following solution saved the day: Login as “Administrator”. Go to “Start > Programs > Microsoft SQL Server … Continue reading

Posted in SQL Server | Leave a comment

Using Red-Gate’s SQL Search

If you work with SQL Server databases and have not yet tried Red-Gate’s SQL Search, you are making your life unnecessarily harder. SQL Search is a FREE tool (as of the time of this post) provided by Red-Gate and the … Continue reading

Posted in SQL Server, Toolkit | Tagged , , | Leave a comment

FK Constraint error but primary table data exists

Takeaway: Solution is “ORDER BY 1” This is a very deceptive error and spent a few hours working it out. Hopefully this will save some of you some pain. While maintaining and improving performance on some stored procedures, I came … Continue reading

Posted in SQL Server | Leave a comment

Service Broker Message Types

Again, no original thoughts on my end here, but this short and sweet article gives a nice high level overview from “SQL Server with Mr. Denny” Back to Basics Service Broker Message Types Robert Wallace No Slogans, Just Results

Posted in Service Broker, SQL Server | Leave a comment

Implementing a custom enumerator for SQL Server TVP

Helpful article by Lenni Lobel. http://lennilobel.wordpress.com/2009/07/29/sql-server-2008-table-valued-parameters-and-c-custom-iterators-a-match-made-in-heaven/

Posted in SQL Server, Table Value Parameter | Leave a comment

How to Size Fill Factor on an Index

Great start and process for determining fill factor by anuchaw. http://blogs.msdn.com/windchillonsql/archive/2010/04/09/more-about-how-to-size-fill-factor-on-an-index.aspx

Posted in SQL Server | Leave a comment

How to Avoid Some Common Developer and DBA Mistakes

Great article by Brad M. McGehee, Director of DBA Education, Red Gate Software Read more: http://www.bradmcgehee.com/2010/04/how-to-avoid-some-common-developer-and-dba-mistakes/#ixzz0lYUIKydM

Posted in SQL Server | Tagged | Leave a comment