For more information about the site, see the Site Index

• Using the DISTINCT keyword to display results once
• SQL Server 2000 Standard to SQL Server Enterprise upgrade?
• Joining tables without a primary key
• Best table design for 137 identical power supply logs
• Users can't connect after database reintalled
• Returning submitted info and table ID on a confirmation page
• Killing orphaned processes within stored procedures
• Migrating to SQL Server: worth it?
• Creating a delta between two SQL 2000 schemas
• What data type works with 'long' and contains decimals?
• Querying transactions and getting results ordered in single report
• Optimizer using table indexes
• SQL Server 2000 on Windows NT 4.0
• Converting numbers to words
• Pinning tables into memory
• Extracting data from Access using SQL Server
• Triggers and joins
• Is it feasable to create a database in SQL Server by exporting a DDL from ERWin?
• Error with SQL 7 Enterprise Manager
• Enterprise Manager database size reports
• Restoring backups to a different server and creating a text file for bulkcopy
• Access time-out limit
• Destaging caches in servers
• Query processing speed differences for SQL 6.5, 7.0 and 2000
• Indexes on columns
• What are the features of a database management system?
• Requery stored procedures
• How to update restored database so only changes are reflected
• See table description without many details
• How to upload tables and import data to local host
• SQL Server compared to Oracle for billing sector business database
• Load a text file in a table and then remove text file from directory
• Merge replication
• Access SQL Server 7.0 from Linux via a PERL script
• Making a conceptual database for a video rental company
• Product that will provide an audit trail of changes to a Microsoft SQL database
• Can I create derived columns from derived columns?
• How to flush memory occupied by queries in different sessions
• Passing a table's name to a stored procedure as input parameter
• Why is SQL/Outlook/Exchange better than Lotus Notes?
• Synchronizing two servers
• Why is link list used to represent different types of data structures?
• Replication plan to get only the updated data instead of entire database
• Setting up a SQL server hosting multiple databases
• How do I kill a session in SQL Server, not kill a process?
• Query to return all 5 SKILL_IDs
• System-generated unique ID numbers for reaching records (ROWID in Oracle) in SQL Server
• How can I create a stored procedure in SQL Server and call the procedure in VB?
• Which tool is better for backup plans, sqlmaint or backup?
• Date conversion in SQL Server 7 Enterprise Edition