SQLUSA
SQL Server 2005 Interview Questions

Microsoft SQL Server 2000 Interview Questions

Administration Design Programming

SQL Tip of the Week

Updated Weekly. Submit your how to for publication to Support.
 
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 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 can you 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.