Performance issue querying Linked Servers in SQL Server

When querying a linked server in SQL server there are basically two different ways to do it. Four Part Naming There is the four part naming method which calls the object directly while tacking on the linked server name to the table you are querying.

And this method is nice and simple, but it works by passing the full … Read More

Mike GriffithPerformance issue querying Linked Servers in SQL Server

Setting up a Message Queue in SQL Server

Over the years I’ve had a few instances where I’ve had to set up a message queue with the broker in SQL Server and every time I come back to set up another queue I find the documentation to be very confusing. So here is my attempt to make the setup easier to follow. Please take note this has been … Read More

Mike GriffithSetting up a Message Queue in SQL Server

Using table valued parameters to efficiently pass lists into SQL Server stored procedures

While optimizing some code, I came across this very comprehensive article on the most efficient way to pass a list of items into a SQL Server stored procedure. To summarize the article the fastest way to pass in a list is to use table valued parameters, but the ORM tool that we are currently using Mindscape Lightspeed has no support … Read More

Mike GriffithUsing table valued parameters to efficiently pass lists into SQL Server stored procedures

Free and Useful tools for SQL Server and .Net development

At a lot of the places I’ve worked at over the years, money has usually been an object. As a result I’ve had to find quality tools that cost a little bit less. Below are a list of those applications that I use on a fairly regular basis.

Mike GriffithFree and Useful tools for SQL Server and .Net development