Forum Replies Created

Viewing 15 posts - 1 through 15 (of 43 total)

  • RE: Level 1: The Basic SELECT Statement

    Great article! A minor typo (I think): Exercise #1 refers to "Human.Resources.Employee table". I think it should be "HumanResources.Employee table". What do you think?

    Also I think the Level 3 link...

  • RE: TOP

    Steve Jones - Editor (4/23/2009)


    I think the answer is correct, but I have added a warning to the explanation so that people that might not read the discussion will see...

  • RE: Correlated Joins Using "Apply"

    Matt Miller (6/16/2008)


    Having done some amount of testing on this - while this scenario is certainly convenient in some scenarios, it has a tendency to perform on par with CSQ's,...

  • RE: Chargeback

    Check out this link on chargebacks:

    http://www.computerworld.com/managementtopics/management/itspending/story/0,10801,99697,00.html

    At the moment, I agree with former Ace Hardware Corp. CIO Paul Ingevaldson: "He thinks the best alternative is a system where all the top...

  • RE: Passing a Table to a Stored Procedure

    Mick Dugan (2/13/2009)


    This is pretty neat, but what I've REALLY been looking for for ages is the ability to pass an entire .Net dataset to a proc. Of course,...

  • RE: Celebrating A Million

    Pyay Nyein (1/29/2009)


    just curious that who is the 1,000,000th member? ๐Ÿ˜€

    Yeah... I'm curious too. Who is it? ๐Ÿ™‚

  • RE: Solving the โ€œRunning Totalsโ€ Problem in SQL Server 2005 with Partitioned Tables

    Wooh ... this is some article. Great job! ๐Ÿ˜Ž

  • RE: Getting A Clue About Your Databases

    Excellent article! :smooooth:

    Very impressive topic and easily readable!

    I look forward to your future articles!

  • RE: How To Avoid Msg 106

    Henrik, you type fast. ๐Ÿ˜‰

  • RE: How To Avoid Msg 106

    OzarkMountainMan (12/9/2008)


    Couldn't you solve the design problem by creating a new table (or series of tables) that contain all of the customer data in them with customer ID's to separate...

  • RE: Data Vices

    I'm practically perfect in every way. :hehe:

  • RE: Just Keep Going and Going and Going

    K. Brian Kelley (12/4/2008)


    Microsoft probably would support a legacy system, but for the right price.

    I agree. It makes sense to me that Microsoft could profit handsomely by supporting...

  • RE: Which is better

    I learned about using conventional joins by reading these articles.

    Joins Clarified By Sanket Naik http://www.sqlservercentral.com/articles/Miscellaneous/joinsclarified/1333/[/url]

    A Refresher on Joins By Jambu Krishnamurthy http://www.sqlservercentral.com/articles/Basic+Querying/2937/[/url]

    Hidden RBAR: Triangular Joins By Jeff Moden http://www.sqlservercentral.com/articles/T-SQL/61539/[/url]

    I found...

  • RE: Power and Deception of CTEs

    Christopher Stobbs (12/2/2008)


    Good point Steve, I was asking just yesterday about the left join vs NOT Exists, and well Gail gave me a very good visible answer and well ......

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    I also enjoyed the article. I like that you include applications and explanations of best some practices, e.g. the discussion on using a SELECT instead of an IF under...

Viewing 15 posts - 1 through 15 (of 43 total)