When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.<\/p>\n
SQL Server supports a wide variety of data types, each tailored for different types of data. These include:<\/p>\n
INT<\/code>, BIGINT<\/code>, FLOAT<\/code>, DECIMAL<\/code>, etc.<\/li>\n- Character Data Types:<\/strong> Such as
CHAR<\/code>, VARCHAR<\/code>, NCHAR<\/code>, NVARCHAR<\/code>.<\/li>\n- Date and Time Data Types:<\/strong> Such as
DATE<\/code>, DATETIME<\/code>, DATETIME2<\/code>.<\/li>\n- Binary Data Types:<\/strong> Such as
BINARY<\/code>, VARBINARY<\/code>.<\/li>\n- Other Data Types:<\/strong> Including
BIT<\/code>, UNIQUEIDENTIFIER<\/code>, XML<\/code>, JSON<\/code>, etc.<\/li>\n<\/ul>\nEach of these types has specific storage requirements, performance implications, and use cases. Choosing the correct data type requires a thorough understanding of both the data you need to store and the operations you plan to perform on that data.<\/p>\n
The Impact of Data Type Selection on Storage<\/h3>\n
The storage footprint of each data type varies. For instance, an INT<\/code> requires 4 bytes of storage, while a BIGINT<\/code> requires 8 bytes. While this difference might seem trivial on a small scale, it can become significant when you are dealing with millions or billions of rows.<\/p>\nExample:<\/strong> Consider a table with a billion rows. If you use an INT<\/code> (4 bytes) versus a BIGINT<\/code> (8 bytes) to store an integer value, the difference in storage requirements is 4 GB (4 bytes * 1 billion) versus 8 GB (8 bytes * 1 billion). That\u2019s a 4 GB difference, which can have a considerable impact on storage costs, backup sizes, and query performance.<\/p>\nNumeric Data Types and Their Trade-offs<\/h3>\n
When working with numeric data, it\u2019s important to choose the smallest data type that can accommodate the values you expect to store. SQL Server offers several options, each with different storage requirements:<\/p>\n
\nTINYINT<\/code> (1 byte): Stores integers from 0 to 255. Ideal for small enumerations or boolean-like values.<\/li>\nSMALLINT<\/code> (2 bytes): Stores integers from -32,768 to 32,767. Useful when a wider range is needed, but the full range of INT<\/code> is not required.<\/li>\nINT<\/code> (4 bytes): Stores integers from -2,147,483,648 to 2,147,483,647. The most commonly used numeric data type.<\/li>\nBIGINT<\/code> (8 bytes): Stores integers from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. Necessary when dealing with very large numbers.<\/li>\n<\/ul>\nChoosing a larger data type than necessary not only increases storage requirements but also impacts index size and, subsequently, query performance. Indexes built on columns with smaller data types are more efficient because they occupy less space, allowing more index pages to fit into memory, which reduces I\/O operations and speeds up query performance.<\/p>\n
Character Data Types and Their Implications<\/h3>\n
For storing text, SQL Server provides CHAR<\/code>, VARCHAR<\/code>, NCHAR<\/code>, and NVARCHAR<\/code> data types. The choice between these types can significantly impact both storage and performance:<\/p>\n\nCHAR(n)<\/code>: A fixed-length character data type. Always uses n<\/code> bytes of storage, regardless of the actual string length. Best used when all entries in the column are expected to be of the same length.<\/li>\nVARCHAR(n)<\/code>: A variable-length character data type. Uses only as much storage as needed for each entry, up to n<\/code> bytes. Ideal for columns with varying string lengths.<\/li>\nNCHAR(n)<\/code> and NVARCHAR(n)<\/code>: These are the Unicode equivalents of CHAR<\/code> and VARCHAR<\/code>. They use 2 bytes per character to support a wider range of characters, which is necessary for languages with large character sets.<\/li>\n<\/ul>\nExample:<\/strong> If you are storing fixed-length codes, such as a 3-character country code, CHAR(3)<\/code> might be more appropriate than VARCHAR(3)<\/code>, as it avoids the overhead associated with variable-length storage. On the other hand, for storing names or descriptions where the length varies significantly, VARCHAR<\/code> would be more efficient.<\/p>\nOne important consideration is the choice between Unicode and non-Unicode data types. If your application requires support for multiple languages, including those with large character sets like Chinese or Arabic, NVARCHAR<\/code> is necessary. However, for English-only applications, VARCHAR<\/code> saves space, as it uses half the storage per character compared to NVARCHAR<\/code>.<\/p>\nDate and Time Data Types: Precision vs. Storage<\/h3>\n
SQL Server offers several data types for storing date and time information:<\/p>\n
\nDATE<\/code>: Stores only the date component, using 3 bytes.<\/li>\nTIME<\/code>: Stores only the time component, using between 3 and 5 bytes, depending on the precision.<\/li>\nDATETIME<\/code>: Stores both date and time, with a precision to the nearest 3.33 milliseconds, using 8 bytes.<\/li>\nDATETIME2<\/code>: An enhanced version of DATETIME<\/code> that allows precision up to 100 nanoseconds, using between 6 and 8 bytes depending on the precision.<\/li>\nSMALLDATETIME<\/code>: Stores both date and time, with a precision to the nearest minute, using 4 bytes.<\/li>\n<\/ul>\nThe choice of which date and time type to use depends on the precision required and the storage considerations. For most applications, DATETIME<\/code> or DATETIME2<\/code> are sufficient, but in cases where only a date is needed, DATE<\/code> saves space.<\/p>\nExample:<\/strong> If you only need to store a user\u2019s birthdate, DATE<\/code> is the most efficient choice. Using DATETIME<\/code> would unnecessarily consume an additional 5 bytes per row.<\/p>\nBinary Data Types: Storing Raw Data Efficiently<\/h3>\n
Binary data types in SQL Server, such as BINARY<\/code> and VARBINARY<\/code>, are used to store raw binary data, such as images, files, or encrypted data. The key difference between BINARY<\/code> and VARBINARY<\/code> is that BINARY<\/code> is a fixed-length data type, while VARBINARY<\/code> is variable-length.<\/p>\n\nBINARY(n)<\/code>: Allocates a fixed n<\/code> bytes of storage regardless of the actual size of the data.<\/li>\nVARBINARY(n)<\/code>: Allocates only the necessary amount of storage for the data, up to n<\/code> bytes.<\/li>\n<\/ul>\nThese data types are particularly useful when dealing with data that does not fit neatly into other categories, such as multimedia files or custom binary formats. However, it\u2019s important to consider the storage implications and performance impacts when storing large amounts of binary data directly in the database. In many cases, storing the data externally and referencing it within the database may be more efficient.<\/p>\n
Other Data Types: Specialized Needs and Performance Considerations<\/h3>\n
SQL Server also provides several other data types designed for specific purposes:<\/p>\n
\nBIT<\/code>: A simple data type that stores a Boolean value (0 or 1). It\u2019s highly efficient for storing binary flags or true\/false values, using only 1 bit of storage per value.<\/li>\nUNIQUEIDENTIFIER<\/code>: Used to store globally unique identifiers (GUIDs). While UNIQUEIDENTIFIER<\/code> ensures uniqueness across tables, databases, and even servers, it consumes 16 bytes per value, making it less efficient in terms of storage and indexing compared to other data types.<\/li>\nXML<\/code> and JSON<\/code>: These data types allow for the storage of structured data in XML or JSON formats. They are useful in scenarios where the data is inherently hierarchical or semi-structured. However, storing large XML or JSON documents in these formats can lead to performance issues, especially in terms of parsing and indexing.<\/li>\nSQL_VARIANT<\/code>: A versatile data type that can store values of various data types, with the exception of text, ntext, and image. While flexible, SQL_VARIANT<\/code> is generally not recommended for high-performance scenarios due to the overhead involved in determining and managing the underlying data types.<\/li>\n<\/ul>\nThese data types serve specialized needs and can be highly effective when used appropriately. However, their performance and storage implications should be carefully considered, particularly in high-transaction environments or when designing for scalability.<\/p>\n
Best Practices for Data Type Selection<\/h3>\n
1. Use the Smallest Possible Data Type:<\/strong> Always choose the smallest data type that can accommodate the data you plan to store. This reduces storage requirements and improves performance, particularly in large tables with millions of rows.<\/p>\n2. Consider Indexing Implications:<\/strong> Smaller data types not only reduce the size of the data but also the size of indexes. This can lead to faster query performance as smaller indexes fit better in memory, reducing disk I\/O.<\/p>\n3. Avoid Unnecessary Precision:<\/strong> Using overly precise data types (e.g., DECIMAL(38,18)<\/code>) when it\u2019s not needed can lead to wasted space and slower performance. Match the precision of your data type to the precision of the data you are storing.<\/p>\n4. Be Mindful of Unicode Requirements:<\/strong> Use Unicode data types (NCHAR<\/code>, NVARCHAR<\/code>) only when necessary. For English-only or ASCII data, non-Unicode types (CHAR<\/code>, VARCHAR<\/code>) save space and improve performance.<\/p>\n5. Understand the Impact of Implicit Conversions:<\/strong> Mixing data types in queries can lead to implicit conversions, which can negatively impact performance. Ensure that the data types in your queries match those defined in your schema.<\/p>\n6. Test Performance Impacts:<\/strong> Always test the performance implications of your data type choices, especially in production-like environments. The differences in storage and performance can be substantial and are often workload-dependent.<\/p>\nConclusion<\/h3>\n
Choosing the right data type in SQL Server is more than just a matter of picking a type that fits the data. The decisions you make will have long-term implications for the performance, storage, and scalability of your database systems. By understanding the storage requirements, performance characteristics, and best practices associated with SQL Server\u2019s data types, you can design more efficient databases that are easier to manage and faster to query. The key is to balance precision with storage efficiency and to be mindful of the impacts your choices will have on indexing, querying, and overall system performance.<\/p>\n","protected":false},"excerpt":{"rendered":"
When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12,5,84],"tags":[248,249,4,250,131],"class_list":["post-734","post","type-post","status-publish","format-standard","hentry","category-internals","category-performance","category-sql-developer","tag-data-types","tag-database-design","tag-internals","tag-sql-optimization","tag-sql-server"],"yoast_head":"\n
The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqltabletalk.com\/?p=734\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=734\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-30T13:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"The Hidden Costs of Data Type Decisions in SQL Server\",\"datePublished\":\"2024-08-30T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734\"},\"wordCount\":1458,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"Data Types\",\"Database Design\",\"Internals\",\"SQL Optimization\",\"SQL Server\"],\"articleSection\":[\"Internals\",\"Performance\",\"SQL Developer\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=734#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=734\",\"name\":\"The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-08-30T13:00:00+00:00\",\"description\":\"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=734\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=734#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Hidden Costs of Data Type Decisions in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk","description":"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqltabletalk.com\/?p=734","og_locale":"en_US","og_type":"article","og_title":"The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk","og_description":"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.","og_url":"https:\/\/www.sqltabletalk.com\/?p=734","og_site_name":"SQL Table Talk","article_published_time":"2024-08-30T13:00:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=734#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=734"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"The Hidden Costs of Data Type Decisions in SQL Server","datePublished":"2024-08-30T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=734"},"wordCount":1458,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["Data Types","Database Design","Internals","SQL Optimization","SQL Server"],"articleSection":["Internals","Performance","SQL Developer"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=734#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=734","url":"https:\/\/www.sqltabletalk.com\/?p=734","name":"The Hidden Costs of Data Type Decisions in SQL Server - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-08-30T13:00:00+00:00","description":"When designing a SQL Server database, the choice of data types is one of the most fundamental decisions that will have a lasting impact on both performance and storage efficiency. Each data type in SQL Server has specific characteristics that determine how data is stored, how much space it consumes, and how it performs in various operations such as indexing, querying, and sorting. Understanding these characteristics and making informed decisions about data types can lead to significant improvements in both the speed and the efficiency of your database systems.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=734#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=734"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=734#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"The Hidden Costs of Data Type Decisions in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=734"}],"version-history":[{"count":1,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/734\/revisions"}],"predecessor-version":[{"id":735,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/734\/revisions\/735"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}