Get Free Tips
MSSQLTips.com

Category: Database Design

Home » Database Objects » Database Design
TitleAuthorDate
SQL Server Database Diagram Tool in Management StudioJim Evans2025-05-28
Add New Columns Versus New Table in SQL ServerJared Westover2025-02-04
Drop All Tables SQL ServerJoe Gavin2024-12-31
SQL Server DROP TABLE IF EXISTS ExamplesJoe Gavin2024-12-18
SQL Create Database Valuable Tutorial with T-SQL and SSMSNisarg Upadhyay2024-12-11
Build Polymorphic Associations in SQL Server with Foreign KeysJared Westover2024-12-06
GUID in SQL Server​Rick Dobson2024-11-22
Building an Enterprise Resource Planning (ERP) Database SystemSebastiao Pereira2024-08-07
Normalization in SQL to Reduce Data RedundancyDaniel Calbimonte2024-07-15
Modify SQL Server database tables to keep similar columns togetherGreg Robidoux2024-05-30
Microsoft SQL Server Data Warehouse Data Quality, Cleansing, Verification and MatchingRay Barley2024-01-02
SQL Server Table Design Guide – Data Types, Primary Keys and moreJared Westover2023-11-01
SQL Script for Table and Column Properties in a SQL Server DatabaseHadi Fadlallah2023-09-29
Append SQL Table with New Columns and Add New DataRajendra Gupta2023-08-08
Insight into Rowstore and Columnstore Indexes in SQL ServerJared Westover2023-06-08
Star Schema vs Snowflake Schema for Dimensional ModelingKoen Verbeeck2023-04-24
Snowflake Schema Overview and Usage in Power BIKoen Verbeeck2023-04-04
Star Schema Data Modeling for Power BIKoen Verbeeck2023-03-16
SQL Create Schema to Organize Objects, Permissions and ManagementJoe Gavin2023-01-09
How to Build an ERD for Database ApplicationsDavid Ekete2022-12-15
Getting Started with SQL SchemasAubrey Love2022-12-12
Determine SQL Server Page Counts for Tables, Indexes and ObjectsJared Westover2022-12-09
Drop All Tables in SQL Server and Generate a List of Objects with TypeAubrey Love2022-10-19
Add a Column in a Table in SQLManvendra Singh2022-09-26
SQL ALTER TABLE to Add, Delete and Change Columns in a TableJohn Miner2022-09-19
Create SQL Server Database Tables, Foreign Keys and DataJan Potgieter2022-08-18
Create Table SQL Server with Foreign Key ConstraintsJan Potgieter2022-08-09
Create Table SQL Server Step by StepJan Potgieter2022-07-28
Create Database SQL Server with SSMS or T-SQLJan Potgieter2022-07-05
Cleanup and Enhance Data in SQL Server Dimension TablesAaron Bertrand2022-04-08
Reduce Size of SQL Server Logging Tables with Dimension TablesAaron Bertrand2022-04-08
CREATE TABLE SQL Server Syntax ExamplesAubrey Love2022-03-15
Create Table SQL Server vs OraclePablo Echeverria2022-03-09
Surrogate Key vs Natural Key Differences and When to Use in SQL ServerBen Snaidero2022-01-31
Generate SQL Server Sparse Columns ScriptSvetlana Golovko2022-01-18
SQL Server Sparse Columns Identifying Columns For ConversionKen Simmons2022-01-14
Find and Remove Duplicate Rows from a SQL Server TableSergey Gigoyan2021-07-20
What is a Relational DatabaseEric Blinn2021-06-10
SQL Drop Column ExamplesJoe Gavin2021-04-15
Gitflow Workflow Feature Branching for SQL Database ProjectsHaroon Ashraf2020-12-30
What is a Relational Database Management SystemNai Biao Zhou2020-12-11
SSMS Database Diagram Support Objects Cannot Be InstalledSergey Gigoyan2020-12-02
Basics of Gitflow Workflow for SQL Database ProjectsHaroon Ashraf2020-11-17
Git Branch for New Features in SQL Database ProjectHaroon Ashraf2020-10-30
SQL Server Data Tools in Visual Studio with GIT Source ControlHaroon Ashraf2020-10-20
Explore the Role of Normal Forms in Dimensional ModelingNai Biao Zhou2020-10-06
Git Branch with SQL Server Database ProjectHaroon Ashraf2020-09-29
Alter Table Modify Column ONLINE Issues in SQL ServerAaron Bertrand2020-08-19
Create Table in SQL Server using Excel TemplateGreg Robidoux2020-07-29
SQL Server Performance Testing for Check Constraint vs Foreign KeyBen Snaidero2020-04-21
Dealing with a No NULL Requirement for Data Modeling in SQL ServerK. Brian Kelley2020-01-28
Create Tables in SQL Server with T-SQLGauri Mahajan2019-12-23
SQL Server Create Database ExamplesJoe Gavin2019-12-11
SQL Server Foreign Key Hierarchy Order and Dependency List ScriptEduardo Pivaral2019-09-24
Find SQL Server Integer Columns to Make SkinnierAaron Bertrand2019-07-25
What is a GUID in SQL ServerSiddharth Mehta2019-04-23
Query Extended Properties from Multiple SQL Server DatabasesAaron Bertrand2019-04-05
SQL Server IOT Database Design ExampleSemjon Terehhov2019-02-18
Reverse Engineer SQL Server Databases with Visual StudioJohn Miner2019-02-07
Float vs Numeric for SQL Server CPU Usage Arithmetic OperationsBen Snaidero2018-12-11
Add Primary Key to Prepopulated Table using SQL Server Object ExplorerHaroon Ashraf2018-10-30
Create Star Schema Data Model in SQL Server with Microsoft ToolsetNai Biao Zhou2018-09-17
Data Modeling: Understanding First Normal Form in SQL ServerK. Brian Kelley2018-08-16
Why Surrogate Keys are Needed for a SQL Server Data WarehouseDinesh Asanka2018-07-24
CRUD Operations in SQL ServerJeffrey Yao2018-07-19
The Pros and Cons of Using T-SQL Soft TransactionsTim Smith2018-07-18
Working with SQL Server Extended PropertiesJayendra Viswanathan2018-04-13
Compare SQL Server Page Splits for INT vs BIGINT vs GUID Data TypesBen Snaidero2017-11-16
SQL Table Join Performance for INT vs BIGINT vs GUID Data TypesBen Snaidero2017-10-19
SQL Server Performance Comparison INT versus GUIDBen Snaidero2017-09-29
Easy way to compare SQL Server table schemasMatteo Lorini2017-04-18
Remodel Poorly Designed SQL Server Database TablesDerek Colley2016-05-11
Identify and Correct SQL Server Forwarded RecordsBrady Upton2013-06-25
Solving the SQL Server Multiple Cascade Path Issue with a TriggerBen Snaidero2012-08-07
Using DELETE CASCADE Option for Foreign KeysBen Snaidero2012-08-01
Using Hashbytes to track and store historical changes for SQL Server dataChristian Allaire2012-07-19
Storing E-mail addresses more efficiently in SQL Server – Part 2Aaron Bertrand2012-04-12
Storing E-mail addresses more efficiently in SQL ServerAaron Bertrand2012-03-13
Optimal Storage of IP addresses in a SQL Server databaseBrent Shaub2011-11-28
Creative Uses for Extended Properties in SQL ServerBrent Shaub2011-07-11
Understanding First Normal Form in SQL ServerK. Brian Kelley2011-06-28
SQL Server Database Design with a One To One RelationshipBrent Shaub2011-05-16
SQL Server Data Type ConsistencyAaron Bertrand2010-09-29
Using Microsoft Quadrant for data analysis and modelingSiddharth Mehta2010-04-05
Create a Simple SQL Server Database Server Object ReportSiddharth Mehta2010-02-01
Getting started with SQL Server database diagramsAtif Shehzad2009-08-14
Identifying Object Dependencies in SQL ServerAshish Kumar Mehta2009-06-09
Using Computed Columns in SQL Server with Persisted ValuesAtif Shehzad2009-02-06
Script to build a SQL Data Dictionary and report with Microsoft ExcelKun Lee2008-12-02
SQL Server User Defined Data Types, Rules and DefaultsAtif Shehzad2008-11-17
Build a SQL Server Data Dictionary with the Extended PropertiesKun Lee2008-11-04
Create SQL Server Data Dictionary in SecondsKen Simmons2008-05-15
Calculating Table Width in SQL ServerJeremy Kadlec2007-12-12
Retrieving SQL Server Column Properties with COLUMNPROPERTYGreg Robidoux2007-06-28
Identify All SQL Server Tables with Columns of a BLOB Data TypeJeremy Kadlec2007-06-15
Data model access after a SQL Server database restoreJeremy Kadlec2006-11-13
SQL Server Data Modeling ToolsJeremy Kadlec2006-10-06
SQL Server 2005 Data Modeling ToolsJeremy Kadlec2006-09-20

Categories

Recent Articles

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

  • Database Modernization with AI-Powered Tools

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide