Ask the Experts

Ask the Experts

Microsoft SQL Server Performance Monitoring and Tuning

• Utility to dump SQL Server Express database as text file

  I want to dump my SQL Server Express database as a SQL Server text file including "create table and index statements, and "insert into ... statements for all tables." Postgres has such a utility called pg_dump. Any ideas?  Continue Reading

• Stop MS Access from causing timeouts

  Five months ago we migrated our SQL Server databases from 7.0 to 2000. Since then we have experienced timeouts very often. Sometimes we've detected that MS Access blocks the server, and when we kill the process everything starts to work properly. ...  Continue Reading

• Insert values into IDENTITY column

  I pulled some data in using the import utility in SQL Server and placed it into results. I added a couple columns with default values to match the table to merge with the data. The receiving table has an identity column and I have tried different ...  Continue Reading

• Using datagrids for a report in SQL Server Reporting Services

  Datagrids can serve as datasources in Visual Studio 2005. Follow these steps if you want to use your dataset for reports in SQL Server Reporting Services.  Continue Reading

• Writing a generic audit trail trigger in SQL Server

  Writing a generic audit trail trigger in SQL Server to keep track of inserts, deletes, and updates within a table is explained in this expert response.  Continue Reading

• When to update index statistics

  SQL Server 2005 expert Adam Machanic explains why it is not necessary to update statistics after rebuilding indexes.  Continue Reading

• Is my SQL Server 2000 optimized?

   Continue Reading

• What impact does changing one record have on the database?

   Continue Reading

• Is there a maximum number of sockets that SQL can handle?

   Continue Reading

• Why is my SQL Server frequently corrupted?

   Continue Reading

• How to speed up a composite nonclustered index-based query

  A query still responds slowly after implementing an index. Performance Tuning expert Jeremy Kadlec offers help troubleshooting the SQL Server problem.  Continue Reading

• What's the best way to page SQL Server data results?

   Continue Reading

• Long delay when applications runs a query

  A SQL Server query takes much longer to run when executed by an app rather than the client. Development expert Greg Low offers an answer.  Continue Reading

• Can I change the date format when moving a flat file to SQL?

   Continue Reading

• Concerned with performance degradation

  Performance information obtained from SP_WHO or Enterprise Manager Current Sessions dialog may not be entirely accurate. Expert Kevin Kline discusses the limitations of those utilities.  Continue Reading