• Nested queries vs. temporary tables in SQL Server

    A look at when to use nested queries or temporary tables when performing large operations in Microsoft SQL Server.

    SearchWindowsServer1,035 pointsBadges:
  • 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.

    ITKE56,495 pointsBadges:
  • Delete from table A if matching row exists in B

    I am using SQL. I have two tables: A and B. A has the field email and others. B also has the field email and others. I need to eliminate some records of A depending on if these records also occur in B. How can I do this by keeping the table B untouched?

    ITKE56,495 pointsBadges:
  • INSTEAD OF trigger to update a SQL Server table

    Find how to use INSTEAD OF trigger to update a SQL Server table for myDate and myTime.

    SearchSQLServer820 pointsBadges:
  • Creating SQL Server tables: A best practices guide

    When creating SQL Server tables, follow these quick tips for defining filegroups, indexes, key constraints and partitions to improve SQL Server performance.

    ITKE56,495 pointsBadges:
  • Building nested tables in SQL Server?

    Is it possible to build nested tables in SQL Server (I have good knowledge of Oracle and have used nested tables in Oracle for quite some time now)? I studied a few articles on Microsoft.com that state that this is possible using data mining, but I'm not sure of this concept of data mining. My...

    ITKE56,495 pointsBadges:
  • Update SQL Server table statistics for performance kick

    Here's what you need to know about using auto and manual update commands and avoiding false statistics -- two of many techniques that will fine-tune SQL Server statistics and boost performance and accuracy.

    Denny Cherry65,490 pointsBadges:
  • Find size of SQL Server tables and other objects with stored procedure

    When determining SQL Server disk space used by an object, Microsoft's sp_spaceused has limits. Here's an original stored procedure, sp_SOS, that calculates specific object space in SQL Server. Use it to get an overview of user table sizes in a database, the summary of the total space owned by a...

    ITKE56,495 pointsBadges:
  • Enabling and disabling all constraints on a table in SQL Server

    This SQL Server stored procedure will disable/enable all constraints for a given parametric table.

    ITKE56,495 pointsBadges:
  • Tuning SQL Server table indexes: Adjusting the fill factor

    Don’t get bedeviled by SQL Server table indexes. They can fragment over time, but a little tuning goes a long way. Adjusting the fill factor for an index is common method. Read on for dos and don’ts.

    SearchWindowsServer1,035 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.