• 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.

  • Microsoft reaches out to Hadoop for big data processing

    In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.

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

  • Part 4: Cursor example

    Contributor Hilary Cotter reviews a poorly rewritten cursor.  Feature

  • Part 3: Cursor disadvantages

    Cursors have been called memory hogs, poor performers and various other unflattering names. Contributor Hilary Cotter explains the cons of cursors.  Feature

  • Part 1: How cursors work

    T-SQL cursors are like skyscraper window washers traveling up and down the skyscraper to stop at each window. Here Hilary Cotter explains exactly how cursors work.  Feature

  • Undocumented DBCC: Report on settings with DBCC RESOURCE

    DBCC RESOURCE allows you to report back specifically on SQL Server internal settings rather than data structure information.  Tip

  • SQL Server 2005: When and how to use Database Snapshots

    Database Snapshots, a new feature in SQL Server 2005, lets you easily create a read-only copy of your database. Edgewood Solutions' Greg Robidoux explains the pros and cons of using this feature.  Tip

  • Beginning T-SQL: Creating and managing database objects

    You can do only three things with any database object, other than actually use it; you can create it, alter it, or drop it to get rid of it. This chapter download covers the use of database objects related to tables, views, stored procedures, and use...  Book Chapter

  • Top five T-SQL stored procedures

    From finding columns and tables to executing code from a file, Brian Walker's top five stored procedures will offer the simple tricks you need to get routine tasks done.  Feature

  • Adding columns and determining row size

    Development expert Greg Low explains how to insert new columns and assess table row sizes.  Ask the Expert

  • What are surrogate key values

    Contributor Brian Walker emphasizes that surrogate key values have no intrinsic meaning in this feature.  Feature

  • Utilities to maintain a surrogate key architecture

    You've discovered why and when to work with a surrogate key architecture, and how to establish its framework. In the third installment of this series, learn how to maintain the database with utility routines and stored procedures.  Feature

Back to top