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 SQL Server performance and tuning Avoid cursors in SQL Server with these methods to loop over records Solve SQL Server errors and more from the DBA trenches -- part 2 Tutorial: Learn SQL Server basics from A-Z FAQ: Troubleshooting SQL Server Reporting Services How to disable the shrink database task in SQL Server 2000 and 2005 SQL Server out of memory: Troubleshoot and avoid SQL memory problems Basic objects of T-SQL in SQL Server 2008 Using T-SQL data types in SQL Server 2008 Additional T-SQL operations in SQL Server 2008 SQL Server 2008 function types in T-SQL

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