January 6, 2014 at 7:49 am
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
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
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
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
Well done. Great article!
January 15, 2014 at 8:33 am
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
Nice article Greg.
January 30, 2014 at 10:14 am
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
I think in one place, the word PRECENT is mispelling PERCENT. Otherwise, solid informative article.
July 14, 2014 at 3:54 am
Thank you so much for this very valuable and helpful article!
November 20, 2015 at 9:51 am
Great article. Thank you for your efforts.
- Les
November 23, 2015 at 1:31 pm
Good solid info, thanks.
February 6, 2019 at 5:01 pm
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 7:43 pm
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