Tag: Performance

Getting the read/write ratio for a database
By Art on December 3, 2013

Edit: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below by adding extra columns to give the data more context and general advice when interpreting this type of data. Edit (03-Apr-2017): Unfortunately comments have been lost when blog site was migrated to a new platform Just a quick post this […]

Read More
Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
By Art on September 20, 2012

This is a revised post of an original article that I first published in December. Even though I thought that I was very meticulous in my research, something was pointed out to me that I was totally unaware of – Unicode character expansions. So apologies to the community with regard the first article that I published as some of the […]

Read More
Script to analyse space usage by your Service Broker
By Art on April 16, 2012

I believe that service broker is one of the best features from SQL server 2005, well along with the xml data type, and I use service broker a lot for messaging between solutions. Over the years it has proven to be extremely reliable; only really stopping because of a poison message or other environment type issue outside the control of […]

Read More
Convert comma separated string to table and vice versa
By Art on October 27, 2011

I know that this subject has been blogged about numerous times but I thought I’d post an alternative way of shredding a comma separated string to a table that I come up with today, albeit with help from the very clever Itzik Ban-Gan cross join nested CTE that many of us use to generate large tally tables quickly. For sure, […]

Read More
Simple XML exist performance enhancement
By Art on October 13, 2011

I came across this really simple best practice from BOL for the xml method exist which when used will give you a much cleaner and faster query plan. If like me you commonly use the name of an element or attribute as part of an XQuery predicate, then you would benefit immediately from this. So lets create a table with […]

Read More