Suggestions - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Suggestions (RSS)
06 November 2007 14:43

What application doesn't have UNDO in today's world

Well the first that is close to my heart is Integration Services and its really annoying. I tried to track down a connect item for this but couldn't find a specific one. So I raised one https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx...
Posted by simonsabin | with no comments
Filed under: , , , ,
02 July 2007 21:36

SSIS : Web Service task doesn't cut it but who cares

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work...
Posted by simonsabin | with no comments
Filed under: , , , ,
26 June 2007 09:04

Time dimension - What should the key be?

We are currently implementing a data warehouse and the design of the time dimension was recently being done. Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , ,
08 March 2007 07:54

Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon...
Posted by simonsabin | with no comments
Filed under: , , , , ,
30 November 2006 18:44

Team Foundation Server Support for Keyword Expansion

I remember coming across this last year when looking at TFS and was shocked. I thought I heard it was going to be added in an service pack but can't find anything to support it. If you feel that Keyword expansion is needed then please vote on the suggestion...
Posted by simonsabin | 2 comment(s)
Filed under:
19 October 2006 00:59

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...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
06 October 2006 10:45

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...
Posted by simonsabin | with no comments
Filed under: , , ,
04 October 2006 20:58

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...
Posted by simonsabin | with no comments
Filed under: , ,
04 October 2006 20:43

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...
Posted by simonsabin | 3 comment(s)
Filed under: , ,