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

SET Functions Expand / Collapse
Author
Message
Posted Thursday, February 5, 2009 8:56 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 6, 2009 1:58 PM
Points: 84, Visits: 32
Comments posted to this topic are about the item SET Functions
Post #651388
Posted Friday, February 6, 2009 2:00 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
The question is a bit ambiguous
Post #651450
Posted Friday, February 6, 2009 5:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 2,669, Visits: 779
Good one.

Jamie
Post #651527
Posted Friday, February 6, 2009 6:25 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 23,397, Visits: 32,243
Actually, it seemed quite obvious to me and have never used the option personally.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #651556
Posted Friday, February 6, 2009 7:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 2,373, Visits: 2,725
Good question (though I got it wrong ). The only quibble I have with the formatting is the use of the term "function(s)" in the question.

The "(s)" doesn't make sense in that context, since only 1 function choice is possible with radio buttons.

Thanks,
webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #651670
Posted Sunday, February 8, 2009 9:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 5:40 PM
Points: 209, Visits: 302
webrunner (2/6/2009)
Good question (though I got it wrong ). The only quibble I have with the formatting is the use of the term "function(s)" in the question.

The "(s)" doesn't make sense in that context, since only 1 function choice is possible with radio buttons.


Also, SET FMTONLY is a 'setting' not a 'function' - for those who like their terminology :)
Post #652534
Posted Wednesday, February 11, 2009 4:47 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,368, Visits: 1,391
Good question...:)


Post #654651
Posted Monday, February 23, 2009 10:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 4:03 AM
Points: 185, Visits: 52
I think FMTONLY Executes query. as i came to know from earlier comments, FMTONLY returns meta data without processing any row how can it estimate the query response. please clear my doubts.
Post #663208
Posted Wednesday, February 25, 2009 8:08 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 5:40 PM
Points: 209, Visits: 302
SET FMTONLY generates metadata using the structure of the query - metadata can be derived from the types of constants, columns, or expressions.

In the case of stored procedures, which aren't typed, SET FMTONLY needs to execute the SP in order to determine the metadata. This may also be true for inline table-valued functions - but I'm not sure.

If you need more information, check out SQL Server books online at http://msdn.microsoft.com/en-us/library/ms173839.aspx or post a question in the general T-SQL forums.
Post #664734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse