Refactoring and static code analysis tool for SQL Server
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

  • Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

    Around 6 months ago, I was desperately looking for some online resources to help me implement some map reports. The shapefile I was dealing with was at a very granular level (which means that it had a lot of data, 2.5 MB in size), and we needed to do...

  • Script Component–Source Part2 Retain previous record

    So keeping my focus on SSIS Script Component as Source I show another example. Mostly Script component is needed when source is Flat file and we need to retain the previous record value(s) to be used in the next record(s). Keeping this in mind I present...

  • To use Script Component or Derived Column Transformation?? Is the question..

    This is an old debate and yet not resolved. To use Script Component or Derived Column Transformation?? Yes Derived Column Transformation can NOT do all that can be done in Script Component. Advantages of Script Component: Code is more readable Easy to...

  • Script Component–Source Part1

      One of the most advance feature of SSIS is Script design capability provided be it Script Task in Control Flow or Script Component in Data Flow Task. I have seen people use the Script task pretty often but avoid Script Component because of various...

  • Performing a Right Outer Join with a Left Outer Join clause

    Most of the interviewers I have seen tend to prefer people with better problem solving skills rather than better knowledge on a particular technology. No wonder considering the fact that technologies change with each fleeting moment, while a good problem...

  • SSIS - Managing Control Flow based on the input file name

    Many times during ETL we have a requirement where based on the file name we have to perform certain operations. Normally within a For Each Loop with File enumerator in Control Flow Task there is no direct way of doing this. If the file mask matches, well...

  • Less known/used property: ExecValueVariable

    At times I have seen in SSIS forums people ask about the way they can know the number of records updated by a query or deleted by a query in an Execute SQL Task in control flow. Even I replied at times that its not possible(in a direct manner), until...

  • Lookup in SSRS 2008 R2

    Many times we want to associate a tablix with more than one dataset in reports but we are not able to do so in SSRS 2008 and previous versions. This limitation has been taken care of by some RDL expression language enhancements in SSRS 2008 R2. Lookup...

  • SQL Server Best Practices Article

    The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use...

  • SSIS Package Configurations

    I have written a paper on SSIS package configurations based upon my experience and learning in projects. After a lot of reviews, finally it has been published and can be found at: http://www.infosys.com/microsoft/resource-center/Documents/SSIS-package...
1 2 3 4 5 Next > ... Last »

Copyright © Beyondrelational.com