Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
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: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Well done. Great article!
Post #1531063
Posted Wednesday, January 15, 2014 8:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 2:53 PM
Points: 204, Visits: 1,246
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:32 AM
Points: 1,417, Visits: 809
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:52 PM
Points: 65, Visits: 15
Thank you so much for this very valuable and helpful article!
Post #1592112
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse