in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Tips and Tricks » Suggestions (RSS)

Browse by Tags

  • 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

  • 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
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems