This script gives you an idea on how long the processing time is for your SQL jobs. It will depend on how many records are being retained on the sysjobhistory table (scripts defaults to the last 30 days--may not find any history at all).One may find it useful when there are so many sql jobs […]
2003-02-06
3,217 reads
This script list all SQL Server Jobs with schedule details. One will not need to go to the enterprise manager and verify each job properties just to get the scheduled frequency for each job.
2003-01-31
796 reads
In this article, our focus will be to test, the performance benefits of columnstore...
By nelsonaloor
In the past many years, apart from working as DBA, I was working with...
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...
problem How to make left join to only teams displayed dynamically depend on fields...
question for DB Gurus when sql server is restarted, it will be slow at...
Comments posted to this topic are about the item Query Optimization Level
Ask SSC