For more information about the site, see the Site Index

• Differences between DTS and SSIS
• Passing column and table names as parameters
• Copying views from one database server to another
• Integrating Oracle and MSSQL
• Sorting dimensions using Analysis Services
• Connecting to SQL Server using Visual Studio
• Permissions error when connecting .NET
• Troubleshooting database log file error messages
• Accessing tables in the MySQL database from the SQL 7 database
• Using three part names to reference data in a separate database
• Script to select specific record from a multiple-records table
• How to upload data from Access on SQL Server 2005
• How to secure ASP.NET applications that pull data from SQL Servers
• How can I compare encrypted columns in SQL Server 2000?
• A sample query for students with most classes
• Converting date format in flat files
• Testing old SQL Server 7 app on a free version of SQL Server 2005
• Function to determine which Service Pack is installed
• 'Suspect' SQL Server database solution
• Advice for becoming an expert DBA
• Managing common IDs in two separate databases
• What is the difference between normal SQL and T-SQL?
• I'm running a defrag on a test system -- will it work the same in the production system?
• Is my SQL Server 2000 optimized?
• What impact does changing one record have on the database?
• Is there a maximum number of sockets that SQL can handle?
• Why is my SQL Server frequently corrupted?
• Initial password after a fresh install of SQL Server 2000
• Getting data from two servers using the same query
• Creating a script for row selection
• Querying current and previous outstanding reserves
• Developing a table-like structure in Visual Basic
• Using DISTINCT in a SQL query
• Changing date format of a flat file using VB.NET
• Retrieving Excel data for an application
• Splitting data across different drives
• Best approach for using stored SQL procedures in Visual C++
• Strange error when installing SQL Server 2000 Developer Edition
• SQL Server versions with data encryption/decryption support
• How to set a trigger to execute daily
• Long delay when applications runs a query
• Resolve errors received when restoring a database in SQL Server
• Restoring tables without a backup
• Sum aggregate operation won't take varchar data type
• Should I switch databases inside the procedure?
• What's the best approach for restoring MSDB on another server?
• How to speed up a composite nonclustered index-based query
• What's the best way to page SQL Server data results?
• Can I restore a SQL Server 7.0 backup in SQL Server 2005?
• Can I change the date format when moving a flat file to SQL?
• Moving from SQL Server 7.0 to SQL Server 2005
• Query Analyzer's replacement in SQL Server 2005
• Is there an upgrade cost to SQL Server 2005 when you have SQL Server 2000?
• Setting up automatic switchover between SQL Server instances
• Can I connect SQL Server 2000 with SQL Server 2005 instances?
• Converting logins after an upgrade
• Database mirroring in SQL Server 2005
• Migrating from SQL Server 2005 to SQL Server 2000
• SQL Service Broker and Microsoft Message Queuing
• SQL Server 2005 DDL vs. DML triggers
• SQL Native Client
• What are Event Notifications?
• What is the SQLCMD tool used for?
• SQLCLR permission sets
• Forced parameterization database option
• Overcoming SQL Server's 8060-byte row limit
• Relationship between SQL Service Broker and Microsoft Message Queuing
• Publisher residing on a different domain
• SQL Mail troubleshooting
• Installing SQL Server client tools on Windows XP Pro
• Concealing metadata in SQL Server 2005
• Incorrect drive letter assignments
• Installing SQL Server 2000 Enterprise Edition on Windows XP
• Storing XML data in SQL Server 2005
• Will SQL Server 2000 DTS packages work in SQL Server 2005?
• Identifier field in Microsoft's SQL Server
• Getting scheduled DTS packages to run
• CLR stored procedures versus T-SQL stored procedures
• Performance problems after installing Windows Service Pack 4
• Identifying new user accounts
• Improve performance by spreading data
• Restricting System Administrator access
• Aggregate functions in SQL Server 2005
• Difficulties transferring stored procedures and triggers
• Storing business objects as a SQL CLR user-defined type
• Shrinking database and log files
• Writing stored procedures without knowing T-SQL
• Difficulty storing XML data in SQL Server 2005
• Concerned with performance degradation
• Clarifying user ID privileges
• Tools to migrate data to SQL Server 2005
• Importing Oracle database tables
• Renaming SQL Server
• Benefits of upgrading to SQL Server 2005
• IIS error when installing SQL Server 2000 on XP
• Index types in SQL Server 2005
• Row versioning with SNAPSHOT isolation level
• Web site that searches in specified tables and columns
• Restoring a database without a backup
• Performance differences between Windows and Linux-based databases



• More