SimonS' SQL Server Stuff : Saturday, June 03, 2006

Saturday, June 03, 2006 - Posts

Concurrency and speed of CPUs

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Concurrency and speed of CPUs
The new RSS feed is here

Following my looking into the threading at the DeveloperDay today, I was discussing it with friend who pointed out an article discussing the speed of CPUs and concurrency.

Its a great article discussing how Moore's law is working in the CPU world, currently CPU speed has stalled, but the law is continuing with the development of multi-cores.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Concurrency and speed of CPUs

posted Saturday, June 03, 2006 6:48 PM by SimonSabin with 0 Comments

SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete

You may have come across this error in your event log. Here's a great post on the reason, and resolution of the issue.

SQL Error Messages – I/O Related

Cross posted from http://sqlblogcasts.com/blogs/simons

posted Saturday, June 03, 2006 6:14 PM by SimonSabin with 0 Comments

Developer Day 3 - Live

2 sessions in and DDD is going really well so far I've been to Colin's TSL Best Practices and Peter Ibbotson's Threading session.

Peter's session gave some really good points on how to handle threads properly, especially when working with the UI.

Colin raised a point on use of ISNULL which was news to me. If you use

Update mytable set myVarcharCol = ISNULL(@mysmallvarchar,myVarcharCol)

If the variable is null, you think that the value of the column won't change. This is only true if the variable is the same length or bigger than the column. If it's smaller then the value in the column will be truncated.

Try it for yourselves

posted Saturday, June 03, 2006 12:06 PM by SimonSabin with 1 Comments