from ideas to solutions

The Latest Blog Posts
  • Ian Jose's WebLog

    Use Condition-Specific Stored Procedures

    • 7 Comments
    The optimizer chooses the best plan for an SP given the current parameter values. This plan is then reused regardless of whether the nature of the parameters changes from call to call. If an application is aware that input parameters have a small number...
  • Ian Jose's WebLog

    Use Function Results

    • 0 Comments
    Built-in functions with literal constant inputs are simplified during optimization to resultant constant values. However, user defined functions or built-in functions with variable [1] inputs are only simplified to resultant constants for the purposes...
  • Ian Jose's WebLog

    Limit Non-order Preserving Expressions

    • 1 Comments
    Expressions with column transformations that do not retain the original column order do not benefit from column statistics. This can lead to poor plans. Assume for purposes of illustration that we've added a column to Sales.SalesOrderHeader in AdventureWorks...
  • Ian Jose's WebLog

    Avoid Unnecessary Data Type Conversions

    • 2 Comments
    SQL Server adds implicit data type conversions when types don’t match. This can have unintended results both on query results, but also on the query plan. It is important to use literal constants that match in type column they are being compared with...
  • Ian Jose's WebLog

    Use Parameters or Literals for Query Inputs

    • 4 Comments
    Use unmodified parameters or literal constants in query statements to ensure that the optimizer can determine a representative value and optimize accordingly. If you use a local variable in a query predicate instead of a parameter or literal, the optimizer...
  • Jason Langridge's WebLog - MR Mobile!

    IntelliGolf Eagle edition Wins Best Software Award

    • 1 Comments
    One of my favourite Windows Mobile applications is Intelligolf Eagle which has just won the prestigious Smartphone & Pocket PC Magazine award. I started playing golf last year so this application has allowed me to record every round I've ever played...
  • The Healthcare IT Blog

    NHIN/RHIO, a step closer...

    • 0 Comments
    The U.S. Department of Health and Human Services has just announced the 4 winners of the RFP for the NHIN/RHIO prototype. Microsoft is actively engaged in the one led by CSC and I am personally working on their implementation of the Massachusetts RHIO...
  • jfo's coding

    New sample: SplitButton

    • 6 Comments
    Now that the toolstrip has a split button, everyone seems to want one for their form too. While you could tweak out the ToolStripRenderer to do this, it's probably just best to use the ButtonRenderer class on your own custom button. The following sample...
  • Jeff Abraham's WebLog

    Interesting new record label: Cordless

    • 0 Comments
    I don't have any musical talent, but I've always been interested in the music industry. Jac Holzman (who started Elektra, which released The Doors' first album) has a new record label that won't be releasing any physical CDs, but instead will rely on...
  • Chris Garty's Weblog

    MBF Changes: It's all about Microsoft Dynamics

    • 3 Comments
    A couple of people saw the recent news about the Microsoft Business Framework (MBF) and emailed me to check how it affected the team and how it affected me. The news about the team has been mostly covered in the couple of press articles on Microsoft Watch...
  • MSBuild Team Blog

    How To: Wrap Custom Targets Around a Solution Build

    • 212 Comments
    We got the following question on the msbuild@microsoft.com alias last week: I'm migrating from VS2003/NAnt to VS2005/MSBuild for my build solution, and want to create a custom project that does the following: Pre-build actions Sync my source...
  • Autokinetic Effect - Erik Saltwell's Weblog

    My brush with the dark side

    • 3 Comments
    I spent the first four years of my career here at Microsoft as part of Microsoft Consulting Services in NYC. One of my biggest pet peeves was that......
Page 29488 of 33,457 (401,474 items) «2948629487294882948929490»