Browse by Tags

All Tags » Suggestions (RSS)

The optimiser should understand that year(datecolumn) is correlated to the datecolumn

If you have a query such as select year ( OrderDate ) yr , count ( 1 ) from AdventureWorks2008 . Sales . SalesOrderHeader group by year ( OrderDate ) and you have an index on OrderDate you will find that even though the query optimiser could do a stream...

Unhelpful error messages

Following my last post on the login failed message not being as helpful as it could be ( half-error-message-login-failed-for-user-reason-failed-to-open-the-explicitly-specified-database ) I thought it would be good if people could post any other unhelpful...
Posted by simonsabin | with no comments

Time is no use for recording Time

I was asked by a client about the new Time datatype in SQL 2008. They wanted to store the duration of some work so they could use the nice date time functions to get the hours, minutes, seconds etc. However you can't use the Time date type for that...

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...

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...

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...

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...

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

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...

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...