{"id":78949,"date":"2026-11-10T19:45:22","date_gmt":"2026-11-10T19:45:22","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78949"},"modified":"2026-11-10T19:56:11","modified_gmt":"2026-11-10T19:56:11","slug":"rewritten-sql-server-67781","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78949","title":{"rendered":"SQL and SQL Server Interview Questions: Concepts with Short Answers"},"content":{"rendered":"<p>A good SQL Server interview review connects fundamental relational principles to practical database development, administration, and troubleshooting.<\/p>\n<h2>Queries and relationships<\/h2>\n<p>What is a primary key? A key that uniquely identifies rows and does not allow NULL. What is a foreign key? A constraint that enforces a relationship to a candidate or primary key in another or the same table.<\/p>\n<h2>Joins and grouping<\/h2>\n<p>INNER JOIN returns matching rows; LEFT JOIN retains rows from the left table even without a match. GROUP BY aggregates related records; HAVING filters grouped results after aggregation.<\/p>\n<h2>Transactions and concurrency<\/h2>\n<p>What do COMMIT and ROLLBACK do? They complete or undo a transaction&#8217;s changes. Isolation levels affect what a transaction can observe and how concurrency behaves.<\/p>\n<h2>SQL Server-specific topics<\/h2>\n<p>Explain clustered and nonclustered indexes, execution plans, dynamic SQL with sp_executesql, Query Store, backups versus high availability, and the purpose of tempdb.<\/p>\n<h2>Practice exercise<\/h2>\n<pre><code>SELECT CustomerID, COUNT(*) AS OrdersPlaced\nFROM dbo.Orders\nGROUP BY CustomerID\nHAVING COUNT(*) &gt;= 3;<\/code><\/pre>\n<h2>Answering well<\/h2>\n<p>For each topic, supply a concise definition, one example, one trade-off, and a limitation. Confirm assumptions about schema, version, and workload before making performance claims.<\/p>\n<hr\/>\n<p><strong>AI disclosure and reuse:<\/strong> This AI-generated article is rewritten from <a href=\"https:\/\/bangla.sitestree.com\/?p=67781\">an existing Open Education post (ID 67781)<\/a>. Additional explanations, code examples, and version notes may have been added. You may reuse the newly generated article text with or without attribution. Third-party trademarks and linked works retain their own rights. <strong>AI can make mistakes.<\/strong> Check examples, permissions, supported SQL Server versions, and documentation before use in any live system.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A good SQL Server interview review connects fundamental relational principles to practical database development, administration, and troubleshooting.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20,182],"tags":[466],"class_list":["post-78949","post","type-post","status-publish","format-standard","hentry","category-information-technology","category---blog","tag-sql-server","item-wrap"],"jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":78971,"url":"http:\/\/bangla.sitestree.com\/?p=78971","url_meta":{"origin":78949,"position":0},"title":"SQL Server Beginner Questions and Answers: SQL, Joins, Indexes, and Transactions","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"An introductory SQL Server review should explain core relational ideas and how to apply them in real T-SQL queries.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78941,"url":"http:\/\/bangla.sitestree.com\/?p=78941","url_meta":{"origin":78949,"position":1},"title":"SQL Server Indexes Explained: Clustered, Nonclustered, and Composite Keys","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"An index helps the SQL Server query optimizer find rows efficiently, but every index carries maintenance costs. Good index design begins with real workloads rather than indexing every column.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78953,"url":"http:\/\/bangla.sitestree.com\/?p=78953","url_meta":{"origin":78949,"position":2},"title":"Building a SQL Server Data Warehouse: Revisiting the SQL Server 2012 Workflow","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"A SQL Server data warehouse collects and reshapes operational information for analytics. An older SQL Server 2012 walkthrough is a useful starting point for understanding warehouse layers, although modern deployment tools and platform choices can differ.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78952,"url":"http:\/\/bangla.sitestree.com\/?p=78952","url_meta":{"origin":78949,"position":3},"title":"Designing SQL Server Data Warehouses: Fact Tables, Dimensions, and Star Schemas","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"A data warehouse organizes data for reporting and analysis. A common starting point is a star schema with measurable events in fact tables and descriptive attributes in dimension tables.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5906,"url":"http:\/\/bangla.sitestree.com\/?p=5906","url_meta":{"origin":78949,"position":4},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) LEFT JOIN \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 . SQL LEFT JOIN Keyword","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) UNIQUE \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f Author: Protap Chandra | sincerely.yours2512[at]gmail.com UNIQUE \u0985\u09b0\u09cd\u09a5 \u0985\u09a8\u09a8\u09cd\u09af \u09ac\u09be \u0985\u09a6\u09cd\u09ac\u09bf\u09a4\u09c0\u09df\u0964 \u0985\u09b0\u09cd\u09a5\u09be\u09a4 \u098f\u0995\u0987 \u099c\u09bf\u09a8\u09bf\u09b8 \u09a6\u09c1\u099f\u09bf \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7 \u09a8\u09be\u0964 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u0987\u0989\u09a8\u09bf\u0995 \u09a1\u09be\u099f\u09be \u09b8\u09cd\u099f\u09cb\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be \u09b8\u09be\u09b0\u09cd\u099a \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u09ac\u09bf\u09ad\u09cd\u09b0\u09be\u09a8\u09cd\u09a4\u09bf \u098f\u09dc\u09be\u09a4\u09c7\u0964 \u09af\u09c7 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u09a1\u09be\u099f\u09be \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09bf\u09b8\u09c7\u09ac\u09c7 \u0998\u09cb\u09b7\u09a3\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09b8\u09c7\u0987 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0985\u09a8\u09cd\u09af \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":75826,"url":"http:\/\/bangla.sitestree.com\/?p=75826","url_meta":{"origin":78949,"position":5},"title":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview","author":"Sayed","date":"June 25, 2023","format":false,"excerpt":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency.\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78949"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78949\/revisions"}],"predecessor-version":[{"id":79011,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78949\/revisions\/79011"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78949"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}