{"id":"https://openalex.org/W426461","doi":"https://doi.org/10.1007/978-1-4302-1125-9_3","title":"Optimizing and Debugging","display_name":"Optimizing and Debugging","publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W426461","doi":"https://doi.org/10.1007/978-1-4302-1125-9_3","mag":"426461"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-1125-9_3","doi":"https://doi.org/10.1007/978-1-4302-1125-9_3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-1125-9_3","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server 2000 Stored Procedures Handbook","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2494626703","display_name":"SQL Server 2000 Stored Procedures Handbook"},"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085389366","display_name":"Tony Bain","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tony Bain","raw_affiliation_strings":["Tony Bain & Associates, USA","Tony Bain & Associates"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tony Bain & Associates, USA","institution_ids":[]},{"raw_affiliation_string":"Tony Bain & Associates","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089525145","display_name":"Louis Davidson","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Louis Davidson","raw_affiliation_strings":["Christian Broadcasting Network and NorthStar Studios, Nashville, USA","Christian Broadcasting Network and NorthStar Studios"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Christian Broadcasting Network and NorthStar Studios, Nashville, USA","institution_ids":[]},{"raw_affiliation_string":"Christian Broadcasting Network and NorthStar Studios","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082909495","display_name":"Robin Dewson","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Robin Dewson","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5079566275","display_name":"Chuck Hawkins","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chuck Hawkins","raw_affiliation_strings":["Compass Technology Management, USA","Compass Technology Management"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Compass Technology Management, USA","institution_ids":[]},{"raw_affiliation_string":"Compass Technology Management","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"34","last_page":"62"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.961899995803833,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.961899995803833,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.006500000134110451,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.003100000089034438,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/stored-procedures","display_name":"stored procedures","score":0.7160000205039978},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.9480000138282776},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.7039999961853027},{"id":"https://openalex.org/keywords/debugging","display_name":"debugging","score":0.7360000014305115},{"id":"https://openalex.org/keywords/database-tuning","display_name":"database performance tuning","score":0.5870000123977661}],"concepts":[{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.808769702911377},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7739323377609253},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6516804695129395},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.644838809967041},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5619825720787048},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5457770228385925},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.5105246305465698},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5013854503631592},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4843631684780121},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48009923100471497},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.4769012928009033},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.4709658920764923},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.42337071895599365},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.41082045435905457},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2765665054321289},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.23389273881912231},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2054920494556427},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.11543098092079163},{"id":"https://openalex.org/C152880691","wikidata":"https://www.wikidata.org/wiki/Q146813","display_name":"Client\u2013server model","level":3,"score":0.08460485935211182},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.06611540913581848},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-1125-9_3","doi":"https://doi.org/10.1007/978-1-4302-1125-9_3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-1125-9_3","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server 2000 Stored Procedures Handbook","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4403557708","https://openalex.org/W2378459513","https://openalex.org/W2625998371","https://openalex.org/W7154496775","https://openalex.org/W4237615286","https://openalex.org/W4231624556","https://openalex.org/W86965572","https://openalex.org/W2918109354","https://openalex.org/W3068435484","https://openalex.org/W4245961512"],"abstract_inverted_index":{"In":[0],"this":[1],"chapter,":[2],"we":[3],"will":[4,15],"be":[5,17,30],"discussing":[6],"optimizing":[7,19],"SQL":[8,21,27],"Server\u2019s":[9],"stored":[10,37],"procedures.":[11],"Here,":[12],"our":[13],"focus":[14],"not":[16],"on":[18],"the":[20,33],"statements":[22,28],"themselves,":[23],"but":[24],"instead,":[25],"how":[26],"can":[29],"optimized":[31],"within":[32],"context":[34],"of":[35],"a":[36],"procedure.":[38]},"counts_by_year":[],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-06-24T00:00:00"}