Beginning SQL Server - Limit Your Queries

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  April 18, 2006 at 11:41 am

  #632926

  And I thank you for that!! I've worked as both a developer (VB, ASP, C#) and a DBA, and I prefer to be a DBA. So thank you for being my yin to my yang so that we can both do the job we prefer.

  ---

  My blog: SQL Soldier[/url]
  SQL Server Best Practices: SQL Server Best Practices
  Twitter: @SQLSoldier
  My book: Pro SQL Server 2008 Mirroring[/url]
  Microsoft Certified Master: SQL Server, Data Platform MVP
  Database Engineer at BlueMountain Capital Management[/url]

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  April 18, 2006 at 8:46 pm

  #632994

  That's probably in the TOP 20 (no pun intended) of the all-time most requested T-SQL improvements, and someone at Microsoft agrees with you...  SQL 2005 includes a new SELECT TOP (@var) syntax without all the mucking about with SET ROWCOUNT and dynamic SQL.

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  April 18, 2006 at 8:48 pm

  #632995

  LOL.  I didn't even realize there were still places where you could be one or the other and not at least a little bit of both...

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 19, 2006 at 7:44 am

  #633053

  - you're right...it's only a matter of ratio these days...instead of 6 of one and half a dozen of the other..you could actually be weightier on one side than the other..but you can't really escape either role altogether...

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Kevin

  SSCarpal Tunnel

  Points: 4962

  More actions

  April 19, 2006 at 8:55 am

  #633070

  Thanks for that link. Very informative read.