Mastering SQL Server Profiler

SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.

SQL Server Execution Plans

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.

SQL Server Execution Plans

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.

Mastering SQL Server Profiler

SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.

• Download free eBook
• Printed book:
  • US
  • UK

RE: VBScript running from command line

Hi sdidomenico, quote: Hi Frank, Please feel free to hook into any of my posts. I'm a developer with 20 years experience, but only 6 months of experience of SQL Server/ASP/ADO/VBScript/HTML and all that jazz. I'm a recovering Mainframe COBOL Flat File programmer. hmm,... an app that needs 30 minutes to run on a mainframe […]

RE: temp_db slow

Sorry, I forgot to add that info to the original message. temp_db is 604mb with 580 mb free. The autoincrement factor is 10%. The disk that it resides on is 120 GB, w/ 70GB free.