For more information about the site, see the Site Index

• Deleting duplicate records with a single query
• Checking new tables for keywords, then adding permissions
• Merging data with no down time
• Error converting varchar to numeric
• Locking out accounts with unsuccessful login attempts
• Running multiple instances of SQL Server on VMWare
• Using Audit Trail, part 1
• Updating and enhancing a DB designed on 6.5
• Introductory SQL Server tutorials online
• Swapping Oracle and SQL Server databases in Java servlet
• DELETE takes much longer than SELECT
• Using a non-printable character as a delimiter
• Triggers on system tables
• Accessing SQL Server databases on an intranet with VB.NET
• Creating a '~' delimited file
• Suppressing column headings in Query Analyzer
• Retrieving a deleted table
• Updating 100,000 records in less than one minute
• First execution of SP 10 seconds longer than rest
• Gap in integer sequence of primary key
• Transferring SQL Server data into XML format
• Calling a stored procedure from a Java-based application
• Finding gaps in column of sequential numbers
• Enforcing unique constraint without data getting reordered
• Exporting T-SQL scripts from command line
• Oracle SQL doesn't work in SQL Server
• Encrypting password fields in SQL Server
• Replicating traced data to another SQL Server
• Determining when row was created or last modified
• Automated e-mail alerts when tables updated
• Listing the count of rows in each table
• Equivalent of Oracle's 'autonomous' transactions
• Migrating from DB2 to SQL Server
• Problems with converted date data in stored procedures
• Locking a temp table in a stored procedure
• Listing invalid objects
• Implementing row-level security
• Building nested tables in SQL Server?
• Shrinking the log file
• Variables in WHERE statements of views?
• File operations from stored procedures
• Replicating DB2 data to SQL Server
• Options for replicating Oracle data to SQL Server
• Counting rows on distinct columns
• Storing tables with same name in different schema
• Quickest way to purge all data
• Trying to copy new DLL over old one
• Preventing users from viewing databases in Enterprise Manager
• Listing tables in order of last modification
• Is it safe to remove the BUILTIN/Administrator account?
• Recovering the database from the MDF file
• Unbiased comparisons of Microsoft and Oracle
• Replicating a transactional table on nine sites
• Releasing memory on the fly
• Shrinking log file smaller than its original size
• Error inserting numbers
• Delays with Log Shipping
• Hardware recommendations for SQL Server 2000
• Executing the kill statement
• Joining more than two tables
• Error in "Not for replication" database revisited
• Does SQL Server 2000 recognize almost identical SQL statements?
• Passing a column name as a parameter to a SP
• About the INNER LOOP JOIN syntax
• Hiding the source code of a stored procedure
• Dynamically appending year to 'table_'
• Identifying all SPs with reference to renamed column
• Replicating between vendor's database and own instance
• Performance impact of partitioning table
• Allocating percentages of memory to each database
• Alternative to Database Maintenance Plan for differential backups
• Configuring SQL Mail
• Performance effects of virus protection software
• Importing an Oracle dump file
• Benchmarks and best practices for DTS
• Inserting a decimal into a column
• Query performance using clustering services
• Designing an ERD diagram
• Determining what DTS packages are involving table
• Adding columns to existing columns
• Updating existing records with new primary key
• Sending mail about row changes with SQL Mail
• Migrating data into SQL Server in one query
• Replicating an AS400/DB2 database to SQL server 2000
• Using the transaction log to restore a deleted record
• Problems when sysadmin role removed from BUILTIN/Administrator
• COUNT DISTINCT in VB and Access
• Taking a snapshot of the database and relevant partitions
• Executing an Oracle stored procedure
• Defragmenting hard drive where SQL Server resides
• Granting permissions on a table column
• Using the identity column
• SQL query that does the equivalent of ROWNUM/TOP
• Replicating a server
• Passing values to an "in" expression in query
• Column contents truncated when exported to Excel file
• Changing the language code_set in SQL Server 7.0
• Determining minumum hardware configuration for database server
• Library of administrative commands
• Restoring a database with a different name



• More