• September 23, 2008 23 Sep'08

    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 ...  Continue Reading

  • September 16, 2008 16 Sep'08

    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 ...  Continue Reading

  • September 16, 2008 16 Sep'08

    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...  Continue Reading

  • September 16, 2008 16 Sep'08

    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.  Continue Reading

  • September 16, 2008 16 Sep'08

    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.  Continue Reading

  • September 16, 2008 16 Sep'08

    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 ...  Continue Reading

  • September 15, 2008 15 Sep'08

    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 ...  Continue Reading

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close