in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL Server 2005 » Suggestions (RSS)

Browse by Tags

  • CREATE or REPLACE feature request

    I remember back when I moved from Oracle to 6.5 I found the lack of a create or replace really annoying. Whenever I create new sps I always curse at not being able to do "create or replace myproc..." having to do "if exists (select 1 information_schema...)" or "if object_id(...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 19 2006

  • TSQL turning into C#

    Following my previous post about the requirement of semi-colons when using service broker statements, I have raised a suggestion to improve the "Incorrect syntax near ..." error message. If you find the above message less than helpful, then vote for the suggestion. https://connect.microsoft...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Oct 6 2006

  • SQL Server sucks - Stop complaining and do something about it

    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. - var height=90;var...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 4 2006

  • SQL Engine - BULK UPDATE command

    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. If you would like such a feature in a future...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 4 2006
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems