Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 1: The TOP Clause Expand / Collapse
Author
Message
Posted Monday, January 6, 2014 7:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, January 12, 2016 1:09 PM
Points: 1,042, Visits: 288
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
Post #1528101
Posted Thursday, January 9, 2014 2:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 20, 2014 12:31 PM
Points: 51, Visits: 101
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
Post #1529566
Posted Friday, January 10, 2014 7:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, January 12, 2016 1:09 PM
Points: 1,042, Visits: 288
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
Post #1529801
Posted Friday, January 10, 2014 8:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 20, 2014 12:31 PM
Points: 51, Visits: 101
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
Post #1529829
Posted Wednesday, January 15, 2014 5:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, February 4, 2016 3:27 PM
Points: 407, Visits: 842
Well done. Great article!
Post #1531063
Posted Wednesday, January 15, 2014 8:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 4, 2016 1:17 PM
Points: 331, Visits: 1,753
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.
Post #1531149
Posted Wednesday, January 15, 2014 9:03 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:02 AM
Points: 1,519, Visits: 892
Nice article Greg.
Post #1531172
Posted Thursday, January 30, 2014 10:14 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
Greg, if you can edit this, can you change
SalesAgent's
to
SalesAgents
where you just mean the plural, please?
Post #1536451
Posted Wednesday, April 2, 2014 3:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 2, 2014 3:49 PM
Points: 1, Visits: 8
I think in one place, the word PRECENT is mispelling PERCENT. Otherwise, solid informative article.
Post #1557717
Posted Monday, July 14, 2014 3:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 24, 2015 11:05 AM
Points: 80, Visits: 21
Thank you so much for this very valuable and helpful article!
Post #1592112
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse