July 2, 2010 at 7:31 am
Gianluca Sartori (7/2/2010)
Paul White NZ (7/2/2010)Reported as spam - assuming no-one here is in the market for kitchen cabinets?
On days like today I wish I was...
Seems like Gianluca's having an Oracle day...:laugh:
July 2, 2010 at 8:23 am
Paul White NZ (7/2/2010)
Gianluca Sartori (7/2/2010)
Paul White NZ (7/2/2010)Reported as spam - assuming no-one here is in the market for kitchen cabinets?
On days like today I wish I was...
Seems like Gianluca's having an Oracle day...:laugh:
Well, actually it's a SQLServer day...
http://www-01.ibm.com/support/docview.wss?uid=swg21307083
-- Gianluca Sartori
July 2, 2010 at 8:58 am
one thing no one asked is "what do you intend to do with this single-value once you get it"?? That is by far the most significant factor in what type of code you can/should use to acquire said value.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 2, 2010 at 9:01 am
Gianluca Sartori (7/2/2010)
Well, actually it's a SQLServer day...
Serves you right for still running SQL Server 2000 😛 😉
July 2, 2010 at 9:09 am
As far as convenience, that's a personal and organizational preference.
As far as performance, benchmark all three kinds of functions, pure repeated inline code, stored procedures returning a row, stored procedures returning an output parameter, derived tables, temp tables, table variables, temp tables with indexes, and whatever else you can think of.
Different environments and data sets do have differences, and there's a lot of theory in benchmarking... but in the end, only practice tells you how your system is _really_ performing.
July 2, 2010 at 9:22 am
Paul White NZ (7/2/2010)
Gianluca Sartori (7/2/2010)
Well, actually it's a SQLServer day...Serves you right for still running SQL Server 2000 😛 😉
I would be really happy to get rid of that cluster. It's the "garbage" server, where I keep all the databases for applications not certified for SQL Server 2005/2008. You'd be really surprised to see how many of them we still have around.
-- Gianluca Sartori
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply