How can I track how frequently my applications use indexes on a particular table and find out which applications are using the indexes?
Tracking index usage helps you determine which indexes you need to keep, but ...
I've created a full-text index on a table, and I have questions about SQL Server 2000's full-text search component. First, can full-text search look for a suffix (e.g., match the phrase *mation to determine whether a...
I've noticed that when I pass varchar data in a parameter to the sp_OASetProperty stored procedure, SQL Server 7.0 truncates the data to 255 characters. For example, when I try to use Microsoft Collaboration Data...
While using SQL Server Profiler to monitor my SQL Server database recently, I periodically received the message Error: 602, Severity: 21, State: 13. In the Process Info window in Enterprise Manager, I found an entry...
I have SQL Server 7.0 development databases installed in a directory called D:\mssql7. I want to move the user databases, Data Transformation Services (DTS) packages, database diagrams, maintenance plans, logins, and...
Our company has 100 franchises organized into 10 zones, and each zone manages 10 branches. Each branch runs a booking system on SQL Server 2000, and every week, each branch must send data to its zone office and the...
Our company requires high availability, so we're concerned about the time we spend on defragmentation. We use the DBCC DBREINDEX command to defragment our SQL Server tables, but our transaction logs seem to fill up...
