{"id":"https://openalex.org/W80973625","doi":null,"title":"Microsoft SQL Server 2008 Internals","display_name":"Microsoft SQL Server 2008 Internals","publication_year":2009,"publication_date":"2009-03-11","ids":{"openalex":"https://openalex.org/W80973625","mag":"80973625"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:1520579","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1520579","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5020807118","display_name":"Kalen Delaney","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kalen Delaney","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018011031","display_name":"Paul Randal","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Paul Randal","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051964829","display_name":"Kimberly Tripp","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kimberly Tripp","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085106479","display_name":"Conor Cunningham","orcid":"https://orcid.org/0009-0009-0785-3376","observed_orcids":["https://orcid.org/0009-0009-0785-3376"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Conor Cunningham","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0009-0009-0785-3376","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5035246594","display_name":"Adam Machanic","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Adam Machanic","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.4652,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.86664466,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9984999895095825,"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.9984999895095825,"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.0006000000284984708,"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/T10772","display_name":"Distributed systems and fault tolerance","score":9.999999747378752e-05,"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/microsoft-sql-server-2008","display_name":"Microsoft SQL Server 2008","score":0.9900000095367432},{"id":"https://openalex.org/keywords/relational-database-engines","display_name":"relational database engines","score":0.8899999856948853},{"id":"https://openalex.org/keywords/database-architecture","display_name":"database architecture","score":0.8270000219345093},{"id":"https://openalex.org/keywords/indices","display_name":"indexes","score":0.7070000171661377},{"id":"https://openalex.org/keywords/tables","display_name":"tables","score":0.9279999732971191},{"id":"https://openalex.org/keywords/transactions","display_name":"transactions","score":0.9750000238418579},{"id":"https://openalex.org/keywords/locking","display_name":"locking","score":0.9179999828338623},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.871999979019165}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7982257604598999},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.764803409576416},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.7368640899658203},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6518239974975586},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.6269643306732178},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5924153923988342},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5465890169143677},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5365450978279114},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.5033912062644958},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.48851072788238525},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4854779541492462},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4583134353160858},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4273383617401123},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42278528213500977},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.3832859992980957},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.3814162313938141},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3289880156517029},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.24720928072929382},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08414724469184875},{"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":3,"locations":[{"id":"pmh:oai:cds.cern.ch:1520579","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1520579","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"pmh:oai:cds.cern.ch:1665359","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1665359","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:80973625","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-Internals-Developer-Reference/dp/0735626243","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"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/W2611040470","https://openalex.org/W2345040700","https://openalex.org/W7048720710","https://openalex.org/W162856236","https://openalex.org/W7019598171","https://openalex.org/W193899367","https://openalex.org/W4301086371","https://openalex.org/W66203700","https://openalex.org/W7067816757","https://openalex.org/W2409744994"],"abstract_inverted_index":{"Explore":[0],"the":[1,5,10,27,47,55],"definitive":[2],"guide":[3],"to":[4,34,51],"internals":[6,25],"and":[7,30,44,53,63,68,70,81],"architecture":[8],"of":[9],"Microsoft":[11],"SQL":[12,23,37,56],"Server":[13,24,38,57],"2008":[14],"relational":[15],"database":[16,31],"engine.":[17],"The":[18],"author":[19],"an":[20],"expert":[21],"on":[22],"offers":[26,75],"guidance":[28,49],"developers":[29],"administrators":[32],"need":[33],"understand":[35,52],"how":[36],"internal":[39],"structures":[40],"affect":[41],"application":[42],"development":[43],"functionality.":[45],"Get":[46],"practical":[48,82],"needed":[50],"maximize":[54],"architecture,":[58],"including":[59],"information":[60],"about":[61],"logging":[62],"recovery,":[64],"indexes,":[65],"tables,":[66],"transactions":[67],"locking,":[69],"security.":[71],"This":[72],"complete":[73],"reference":[74],"numerous":[76],"code":[77],"samples,":[78],"table":[79],"examples,":[80],"advice.":[83]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-03T10:50:19.383937","created_date":"2016-06-24T00:00:00"}