Wednesday, June 15, 2005 - Posts

SQL Server Challenges

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

So catching up on the world after a little break (honeymoon).

Found Adam fancies his had as a poker ace but using SQL to run the game http://sqljunkies.com/WebLog/amachanic/archive/2005/05/11/14276.aspx.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server Challenges

posted Wednesday, June 15, 2005 5:18 PM by SimonSabin with 0 Comments

UK SQL Server Usergroup Redesign

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/UK SQL Server Usergroup Redesign
The new RSS feed is here

Tony is in the process of redsigning the UK User group site.

Looking good so far

http://www.sqlserverfaq.com/

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/UK SQL Server Usergroup Redesign

posted Wednesday, June 15, 2005 5:09 PM by SimonSabin with 0 Comments

Spid blocking itself post SP4

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Spid blocking itself post SP4
The new RSS feed is here

If you have noticed a SPID blocking itself i.e. the blocked column of sp_who2 is the same as the spid for the same row, this is due to an enhancement put into SQL in SP4 that allows for the monitoring of blocked latch requests.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Spid blocking itself post SP4

posted Wednesday, June 15, 2005 9:30 AM by SimonSabin with 0 Comments

SQL Server 2005 Grid results

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2005 Grid results
The new RSS feed is here

It is nice to raise a bug and see it fixed.

In Feb raised the issue that results in work bench were fixed to a certain height irrespective of the number of rows being displayed. this meant if you could only have 3 grids (on my laptop) of results. Where as in QA the space between the grids is reduced if the grid has less than 6 rows.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 Grid results

posted Wednesday, June 15, 2005 8:29 AM by SimonSabin with 0 Comments