THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Expressions   (RSS)
  • SSIS gotcha – Regional Settings can affect your expressions

    I recently stumbled across a nuance of the SSIS expression language which, when you think about, kinda make sense – but it does help to be aware of it. Its concerned with casting of datetime values using the SSIS expression language Take the following expression: (DT_WSTR,30) @[System::ContainerStartTime] That expression casts a datetime ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 9, 2013
  • Compute Scalars, Expressions and Execution Plan Performance

    The humble Compute Scalar is one of the least well-understood of the execution plan operators, and usually the last place people look for query performance problems.  It often appears in execution plans with a very low (or even zero) cost, which goes some way to explaining why people ignore it. Some readers will already know that a Compute ...
    Posted to Page Free Space (Weblog) by Paul White on September 4, 2012
  • Fun and games with Reporting Services expressions

    I have today been messing about with Reporting Services' expression language and as such have learnt a few things that I figured might be worth sharing. The report that I have been attempting to build has two parameters that define the effective reporting period for the report, effectively they are arguments in a WHERE clause: The business ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 10, 2009
Privacy Statement