Wednesday, October 04, 2006 - Posts

SQL Server sucks - Stop complaining and do something about it

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 sucks - Stop complaining and do something about it
The new RSS feed is here

Further to my last post about the BULK UPDATE suggestion I have made, if you have any suggestions or bugs of your own then please put them into connect.

Please also support the bugs and suggestions that others have raised. The list of non-closed bugs and suggestions can be found here.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server sucks - Stop complaining and do something about it

posted Wednesday, October 04, 2006 8:58 PM by SimonSabin with 2 Comments

SQL Engine - BULK UPDATE command

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 Engine - BULK UPDATE command
The new RSS feed is here

You can achieve very high performance with the BULK INSERT interfaces in SQL Server 2005, from SSIS, ADO, TSQL or plain old bcp.

Many times you would like to be able to perform bulk updates with the same performance, however there is no command to support this.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Engine - BULK UPDATE command

posted Wednesday, October 04, 2006 8:43 PM by SimonSabin with 0 Comments

RAID Explained

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

Thanks to Tom Moreau for pointing in to this great explanation of RAID

:)

 

 

 

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/RAID Explained

posted Wednesday, October 04, 2006 3:39 PM by SimonSabin with 0 Comments

Training - SQL Server Online

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

TechNet Webcast: SQL Server 2005 Series (Part 1 of 10): Administration Tools
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Training - SQL Server Online

posted Wednesday, October 04, 2006 9:44 AM by SimonSabin with 0 Comments

SQL Engine - Storage of Large Object Data

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 Engine - Storage of Large Object Data
The new RSS feed is here

If you are currently using text, ntext or image data in SQL 2000 and are looking to use "max" data types in SQL 2005 you will be interested in my first article for SQLServerCentral on the use of LOB data.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Engine - Storage of Large Object Data

posted Wednesday, October 04, 2006 8:00 AM by SimonSabin with 0 Comments