SQLUSA
Free Trial Save on Combos
SQL Server 2008 Best Practices
SQL Server 2005 Best Practices
SQL Server Training Scripts

SQL Server Best Practices

Administration Design Programming

Updated Weekly. Submit your how to for publication to Support.
 
Most Popular How To Topics
How to convert from string to datetime?
How to build and execute dynamic SQL queries?
How to use the ISNUMERIC function?
How to generate index fragmentation report for all the indexes?
How to calculate percent on base?
How to create a covering index?
How to generate RUNNING TOTAL column?
How to use CASE for report formating?
How to do update from two tables?
How to page in large result set?
How to apply table-valued function for sales reporting?
How to eliminate duplicates in a table?
How to identify deadlock processes and prevent deadlocks?
How to use select from select and correlated subqueries?
How to obtain quick counts of rows in all tables?
How to reindex fragmented tables in a database?
How to configure hard disks for optimal performance?
How to use self-joins?
How to sequence subsets in result?
How to use COALESCE and ISNULL?
How to change the collation of a column?
How to architect a WHILE loop using table variable?
How to perform selected administration & programming tasks?
The World Leader in SQL Server Training

 
>
SQL Server IT Career Powering Scripts
How to set the default language and default database for a login?
How to architect a WHILE loop using TOP?
How to create a stored procedure for DTSRUN?
How to find unique indexes in a database?
How to apply identity for row sequencing?
How to find the login name of the dbo?
How to "fingerprint" a database quickly?
How to grant execute permission on all sprocs?
How to connect to a SQL Server database from ASP?
How to construct a delay loop for simulation?
How to create a csv list for groups?
How to parse out filename from path?
How to change ownership for a set of stored procedures?
How to backup a database with OSQL and SQLCMD?
How to eliminate trailing spaces in a column with RTRIM?
How to apply nested CONVERTs for complex data conversion?
How to create login for SQL Server?
How to simulate a casino roulette?
How to use derived tables to build complex queries?
How to apply table-valued function for sales reporting?
How to rename all tables in the database?
How to delete duplicates in a table?
How to limit updates on a table?
How to reinstall SQL Server?
How to apply correlated subquery with averaging?
How to prevent table lock escalation?
How to import & export image column data?
How to create VIEWs for low and high-priced products?
How to email reports using xp_sendmail?
How to list the columns in all of the tables?
How to create a comma-delimited list with COALESCE?
How to check what service pack is installed?
How to find the minimum of two numbers?
How to update 17 million rows of the Order Details table?
How to find all orders with 10% discount?
How to number with a CURSOR loop?
How to form correlated SELECT list item?
How to turn on SHOWPLAN?
How to use the DATALENGTH function?
How to use UNION ALL instead of or?
How to list the last backup date for all databases?
How to resolve PRIMARY filegroup full error?
How to execute a distributed TRANSACTION?
How to set up a restaurant inventory check constraint?
How to fillin missing data with a trigger?
How to obtain the date only part of a datetime column?
How to imbed apostrophe inside a string?
How to reset a suspect database?
How to sequentially number the result set?
How to grant execute permission to a role on all sprocs?
How to execute a cmd file?
How to use DBCC OPENTRAN?
How to SELECT without column names?
How to construct a four table INNER JOIN SELECT?
How to insert into an Excel spreadsheet?
How to create a SQL Profiler trace from a stored procedure?
How to find out the last backup dates of all databases?
How to search all stored procedures?
How to find non-matching rows in two tables?
How to INSERT with OPENQUERY?
How to create a sequence column for the result set?
How to export and import text column data?
How to change user defined data type?
How to parse a string with complex CHARINDEX?
How to backup a terrabyte database to tape?
How to resolve "SQL Server does not exist or access denied"?
How to import an image into a table?
How to find all the triggers in a database?
How to join to an Access table?
How to get file information?
How to pass encrypted password to DTSRUN?
How to link to an Oracle database server?
How to remove users from a database?
How to check the integrity of a database?
How to use the bit data type?
How to get rolling 30 days of data?
How to store pictures in the database?
How to copy a database to a different server?
How to determine the number of reads in a stored procedure?
How to INDEXDEFRAG during daytime?
How to use the timestamp data type?
How to avoid using substring in a WHERE clause?
How to find the highest paid employee in each department?
How to sort on a date column?
How to add identity column to a table?
How to resolve deadlock resolution victim situtation?
How to avoid using NULLs?
How to make developers love normalized database?
How to name the primary key of a table?
How to use the Hungarian convention in naming database objects?
How to see triggers in a database?
How to check if an index is deteriorated?
How to get random results from SELECT?
How to name user-defined functions?
How to get into the system when locked out by Management Studio?
How to check indexes on a table?
How to create an insert statement for a table with many columns?
How to display all objects in a database?
How to use the CHECKPOINT statement?
How to pronounce SQL?
How to put a database into single-user mode?
How to diagnose in crisis situation?
How to join tables with different collation?
How to stop SQL Server with command?
How to eliminate NULLs?
How to reseed the identity value on a table?
How can I tell the object type in the sysobjects table?
How to find the server version?
How to avoid using SELECT * FROM?
How to create a fast clustered index on a table?
How to find street name in address?
How to avoid using INSERT without column list?
The Best SQL Server Training in the World

 

The World Leader in SQL Server 2008 Training
Order SQL 2008 GRAND SLAM Today!
The Future is just a CLICK away! Your Future!
SQLUSA.com Home Page

Copyright 2005-2010, SMI Corp. All Rights Reserved.

SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.