Post reply

Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 1: The TOP Clause

  • January 6, 2014 at 7:49 am

    #146449

    Comments posted to this topic are about the item Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 1: The TOP Clause

    Gregory A. Larsen, MVP

  • January 9, 2014 at 2:30 pm

    #1678974

    First of all, this is a great article, especially for newer folks to SQL. Now, I've noticed that these queries take quite a few minutes to run. Is this normal? I've been working with SQL for about 2 years now and haven't seen half of what you showed used anywhere else.

    Once again, great article:-)

  • January 10, 2014 at 7:35 am

    #1679170

    If you are running the samples queries in the article on your server and they are taking a long time then something else is going on. The queries in the article all should run very quick, and not take minutes to run.

    Gregory A. Larsen, MVP

  • January 10, 2014 at 8:31 am

    #1679194

    Gregory,

    You are correct, I tried running these on another server and the queries ran quickly. We are currently modifying/rebuilding our indexes and I believe that was causing these queries to run lot slower than they should.

    Thx again:-)

  • January 15, 2014 at 5:57 am

    #1680228

    Well done. Great article!

  • January 15, 2014 at 8:33 am

    #1680305

    Well done. I much appreciated the review questions at the bottom. I would like to see review questions as a standard for the Stairway and other technical articles.

  • January 15, 2014 at 9:03 am

    #1680326

    Nice article Greg.

  • January 30, 2014 at 10:14 am

    #1684763

    Greg, if you can edit this, can you change

    SalesAgent's

    to

    SalesAgents

    where you just mean the plural, please?

  • April 2, 2014 at 3:27 pm

    #1702651

    I think in one place, the word PRECENT is mispelling PERCENT. Otherwise, solid informative article.

  • July 14, 2014 at 3:54 am

    #1729077

    Thank you so much for this very valuable and helpful article!

  • November 20, 2015 at 9:51 am

    #1841400

    Great article. Thank you for your efforts.

    - Les

  • November 23, 2015 at 1:31 pm

    #1841840

    Good solid info, thanks.

  • February 6, 2019 at 5:01 pm

    #2021327

    Hello everyone, starting this tutorial I got to the exercises outlining the need for AdventureWorks. Which version of adventure works is it? I've tried 08, 12, and 16 and none of them contain the EmployeeID column that I need to complete the exercise,

    Thanks

  • February 6, 2019 at 6:37 pm

    #2021330

    If you did not start here then you probably started in the wrong place. If you start with the article I linked to, there's code for creating and populating the table he uses in the article.

  • February 6, 2019 at 7:43 pm

    #2021334

    I'm sorry, i posted onto the wrong forum 🙂

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

You must be logged in to reply to this topic. Login to reply