in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • 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 aggregate on the index because is sorted by date...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 24 2011
  • 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 error messages. I posted a related message a...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Oct 30 2010
  • 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, because it can only hold time up to midnight after...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 23 2010
  • 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?FeedbackID=308794 . We've been told that...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Nov 6 2007
  • 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 for these web services. On further investigation...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 2 2007
  • 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. So considering the day dimension what should...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
  • 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] GO DBCC CHECKDB.... To handle errors in the process...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 8 2007
  • 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 at connect "Vote here Support for...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 30 2006
  • 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
Page 1 of 2 (12 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems