SQLUSA
SQL Server 2005 Best Practices

Microsoft SQL Server 2000 Best Practices

Administration Design Programming

SQL Tip of the Week

Updated Weekly. Submit your how to for publication to Support.
 
How to page in large result set?
How to create a stored procedure for DTSRUN?
How to find unique indexes in a database?
How to use CASE for report formating?
How to apply identity for row sequencing?
How to find the login name of the dbo?
How to construct a derived table correlated query?
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 reindex fragmented tables in a database?
How to create a csv list for groups?
How to parse out filename from path?
How to obtain quick counts of rows in all tables?
How to generate DBCC SHOWCONTIG for all the indexes?
How to identify the deadlock victim process?
How to change ownership for a set of stored procedures?
How to backup a database with OSQL?
How to eliminate trailing spaces in a column with RTRIM?
How to find customers by region with dynamic SQL?
How to architect a WHILE loop using table variable?
How to architect a WHILE loop using TOP?
How to set the default language for a login?
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 estimate tempdb space needed for CHECKDB?
How to rename all tables in the database?
How to calculate percent on base?
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 drop Windows login from the server?
How to shrink the transaction log quickly?
How to list the columns in all of the tables?
How to change the Recovery Model for backup purposes?
How to create a list of publishers with COALESCE?
How to audit database object changes with a trigger?
How to configure hard disks for optimal performance?
How to rename an SQL Server 2000 machine?
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 create a covering index?
How to form correlated SELECT list item?
How to sequence subsets in result?
How to turn on SHOWPLAN?
How to use the DATALENGTH function?
How to use UNION ALL instead of or?
How to return OUTPUT with dynamic SQL?
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 use the ISNUMERIC function?
How to make the dbo own every db object?
How to sequentially number the result set?
How to set system date for reports?
How to grant execute permission to a role on all sprocs?
How to execute a cmd file?
How to schedule a job to run quarterly?
How to use DBCC OPENTRAN?
How to SELECT without column names?
How to construct a four table 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 convert from string to datetime?
How to use self-joins?
How to pin a table into memory?
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 move DTS packages?
How to count rows fast on a table of 100 million?
How to use the COALESCE function?
How to set linked server connection timeout?
How to avoid using NULLs?
How to make developers love normalized database?
How to name the primary key of a table?
How to find all the foreign keys pointing to a table?
How to use the Hungarian convention in naming database objects?
How to see triggers in a database?
How to name views?
How to check if an index is deteriorated?
How to get random results from SELECT?
How to name user-defined functions?
How to scrub a table?
How to use sp_sdidebug to enable application debugging?
How to save a DTS package in meta data format?
How to get into the system when locked out by Enterprise Manager?
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 use Oracle Enterprise Manager to monitor SQL Server 2000?
How to put a database into single-user mode?
How to diagnose in crisis situation?
How to tell which stored procedures touch a table?
How to join tables with different collation?
How to stop SQL Server 2000 from the Query Analyzer?
How to get rid of NULLs?
How to rename a database?
How to reseed the identity value on a table?
How can I tell the object type in the sysobjects table?
How to use the inserted and deleted tables?
How to find the server version?
How to do update from two tables?
How to change the collation of a column?
How to avoid using SELECT * FROM?
How to eliminate duplicates in a table?
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?
How to transfer DTS packages between servers?
 

The future is just a click away! Your future!
 
 
SQLUSA.com Home Page
 
Copyright 2003-2004, SMI Corp. All Rights Reserved.
 
Microsoft is a trademark of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.