ADVICE: >> Tracking query execution with SQL Server 2005 Profiler TIP :Analyzing SQL Server Profiler results can help you fine-tune query performance. Edgewood Solutions' Jeremy Kadlec explains ... >> Stored procedure: Keep track of SQL Server Agent jobs TIP :Enterprise Manager's standard tools aren't much help in examining SQL Agent jobs. To get details about jobs currently ... >> Stored procedure: Examining SQL Agent job run history TIP :Using Enterprise Manager to examine SQL Agent job run history is a chore. The sp_ListJobRunHistory stored procedure provides ... >> How to set a trigger to execute daily ASK THE EXPERTS :I created a trigger on tblauditordetails. I want the trigger to be executed once daily, or at regular intervals. Could you ... >> Starting SQL Server job on first business day ASK THE EXPERTS :I would like to know is there a way to get the first business day and start a SQL Server job based on that? >> SQL 2000 jobs running for days ASK THE EXPERTS :I have SQL 2000 and some jobs are running for days. The status is 'performing completion actions.' How do I stop these jobs? >> Managing backups for a large number of SQL Servers TIP :In a large SQL Server 2000 installation, you have to contend with many backup and recovery challenges. Get help establishing ... >> Automate scheduled backups for all databases TIP :Script to make complete scheduled backups of all your databases on a single server. LEARNING TOOLS: >> Setting job notifications

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Performance Monitoring and Tuning Using traces in SQL Server Profiler SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Data restoration and DB property management Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Troubleshooting Distributed Transaction Coordinator errors in SQL Server Clearing the Windows page file and its effect on server performance Optimizing SQL Server indexes –- even when they're not your indexes Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary