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 Paul White: Page Free Space (Weblog) by Paul White on September 4, 2012
  • Getting Dynamic in SSIS Queries

    When you start working with SQL Server and SSIS, it isn’t long before you find yourself wishing you could change bits of SQL queries dynamically. Most commonly, I see people that want to change the date portion of a query so that you can limit your query to the last 30 days, for example. This can be done using a combination of expressions and ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on March 22, 2010
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement