• Database index design and optimization: Some guidelines

    What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.

  • Download SQL Server Insider

    SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database t...

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)

  • SQL Server Data Quality Services makes cleanup a cinch

    SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.

SQL Server Database Modeling and Design

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Testing transaction log autogrowth behavior in SQL Server

    Shrinking SQL Server transaction logs can undermine server performance. An expert runs various tests to demonstrate how transaction log files respond to several T-SQL commands and to determine whether shrinking files is necessary.  Tip

  • SQLsafe 4.9

    SQLsafe 4.9 is a high-performance backup and recovery solution that reduces database backup time and backup disk space requirements.  New Product Showcase

  • SQL Server database design disasters: How it all starts

    Many businesses are running SQL Server databases in deplorable conditions. SQL Server architect Brian Walker explains how there's a snowball affect leading to these poorly performing databases and often starts with seemingly innocent Access database ...  Tip

  • Can you shrink your SQL Server database to death?

    In an effort to free up disk space, SQL Server DBAs often turn to shrinking the database as part of their SQL Server maintenance plan. When doing so, the database often needs to grow again to accommodate the new data inserted into the database. But w...  Tip

  • SQL Server and data manipulation in T-SQL

    Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson an...  Book Excerpt

  • Enforcing data integrity in a SQL Server database

    Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.  Book Excerpt

  • SQL Server 2008 data types: Datetime, string, user-defined and more

    Find out about data types available in SQL Server 2008 and how to use them, including datetime, string and user-defined data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric ...  Book Excerpt

  • Physical data storage in SQL Server 2005 and 2008

    Learn the fundamentals of data storage in SQL Server 2005 and 2008, including tables, views and data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones...  Book Excerpt

  • Supertype and subtype tables in SQL Server

    Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.  Book Excerpt

  • SQL Server database design disasters: What not to do

    Would you be embarrassed if an outsider took a good look at your SQL Server database design? Is it possible to implement a foreign key constraint in your tables? Are you using the right data types for your columns? Are your naming conventions defined...  Tip

Back to top