Beginning SQL Server - Limit Your Queries
-
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] -
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.
-
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...
-
- 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 !!!** -
Thanks for that link. Very informative read.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply