{"id":"https://openalex.org/W2552587053","doi":"https://doi.org/10.1007/978-1-4842-2271-3_1","title":"How SQL Server Works","display_name":"How SQL Server Works","publication_year":2016,"publication_date":"2016-01-01","ids":{"openalex":"https://openalex.org/W2552587053","doi":"https://doi.org/10.1007/978-1-4842-2271-3_1","mag":"2552587053"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4842-2271-3_1","doi":"https://doi.org/10.1007/978-1-4842-2271-3_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2271-3_1","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":"High Performance SQL Server","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2554305242","display_name":"High Performance SQL Server"},"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/A5015803443","display_name":"Benjamin Nevarez","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Benjamin Nevarez","raw_affiliation_strings":["Santa Clarita, California, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Santa Clarita, California, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5015803443"],"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":"1","last_page":"19"},"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.9932000041007996,"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.9932000041007996,"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/T12127","display_name":"Software System Performance and Reliability","score":0.0035000001080334187,"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"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.0007999999797903001,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.8859999775886536},{"id":"https://openalex.org/keywords/database-tuning","display_name":"database performance tuning","score":0.8550000190734863},{"id":"https://openalex.org/keywords/database-configuration","display_name":"database configuration","score":0.8169999718666077},{"id":"https://openalex.org/keywords/database-monitoring","display_name":"database monitoring","score":0.7369999885559082},{"id":"https://openalex.org/keywords/database-troubleshooting","display_name":"database troubleshooting","score":0.8579999804496765},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.8299999833106995},{"id":"https://openalex.org/keywords/database-availability","display_name":"database availability","score":0.6990000009536743},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.9559999704360962},{"id":"https://openalex.org/keywords/mission-critical-applications","display_name":"mission-critical applications","score":0.8209999799728394}],"concepts":[{"id":"https://openalex.org/C147494362","wikidata":"https://www.wikidata.org/wiki/Q2078905","display_name":"Troubleshooting","level":2,"score":0.8617793321609497},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7207381129264832},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6044265031814575},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6005277037620544},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5825585126876831},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5544435977935791},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.505273163318634},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.47527021169662476},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.45862051844596863},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.44757819175720215},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3774949610233307},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21503761410713196},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.15348908305168152},{"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/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4842-2271-3_1","doi":"https://doi.org/10.1007/978-1-4842-2271-3_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2271-3_1","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":"High Performance SQL Server","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2554305242","https://openalex.org/W2553784965","https://openalex.org/W62220995","https://openalex.org/W2898517861","https://openalex.org/W2477342943","https://openalex.org/W7154514928","https://openalex.org/W3020849433","https://openalex.org/W3101854040","https://openalex.org/W4242994217","https://openalex.org/W2220513317"],"abstract_inverted_index":{"SQL":[0,46],"Server":[1,47],"default":[2],"configuration":[3,18],"allows":[4],"you":[5,54,159,166],"to":[6,56,92,146,172],"run":[7],"noncritical":[8],"applications":[9,36,53,77],"with":[10,23],"only":[11],"minimal,":[12],"if":[13],"any":[14],"at":[15],"all,":[16],"additional":[17,25],"changes":[19],"(and":[20],"sometimes":[21],"even":[22,129],"no":[24],"or":[26,84,126],"minimal":[27],"administration":[28],"and":[29,69,108,142,156,169,187,196],"monitoring).":[30],"This":[31,71,151,192],"is":[32,72,96,119,194],"especially":[33],"true":[34],"for":[35,50,75],"running":[37],"the":[38,42,109,123,147,162,167,174,190,197,203],"lower":[39],"SKUs":[40],"of":[41,63,178],"product":[43],"such":[44,80],"as":[45,81,99,202],"Express.":[48],"However,":[49],"most":[51],"production":[52],"need":[55],"follow":[57],"a":[58,97,138],"database":[59],"implementation":[60],"cycle":[61,98,149],"consisting":[62],"four":[64,103,163],"steps:":[65],"design,":[66,141],"configuring,":[67],"monitoring,":[68],"troubleshooting.":[70],"extremely":[73],"important":[74],"mission-critical":[76],"where":[78],"areas":[79],"performance,":[82],"availability,":[83],"security":[85],"are":[86,105],"an":[87],"essential":[88],"requirement.":[89],"I":[90],"want":[91],"emphasize":[93],"that":[94,135],"this":[95],"well.":[100],"Once":[101],"these":[102],"steps":[104],"successfully":[106],"completed":[107],"application":[110,127],"goes":[111],"live,":[112],"it":[113],"does":[114],"not":[115,188],"end":[116],"there.":[117],"Monitoring":[118],"vitally":[120],"important.":[121],"As":[122],"workload,":[124],"database,":[125],"changes\u2014or":[128],"during":[130],"regular":[131],"activity\u2014problems":[132],"will":[133,157],"arise":[134],"may":[136,199],"require":[137],"new":[139],"thinking,":[140],"configuration,":[143],"going":[144],"back":[145],"aforementioned":[148],"again.":[150],"book":[152],"focuses":[153],"on":[154],"performance":[155,176],"guide":[158],"through":[160],"all":[161],"areas,":[164],"giving":[165],"tools":[168],"knowledge":[170],"required":[171],"get":[173],"best":[175],"out":[177],"your":[179],"databases.":[180],"These":[181],"keywords":[182,198],"were":[183],"added":[184],"by":[185,189],"machine":[186],"authors.":[191],"process":[193],"experimental":[195],"be":[200],"updated":[201],"learning":[204],"algorithm":[205],"improves.":[206]},"counts_by_year":[],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-11-30T00:00:00"}