VIEW to list running and completed jobs
This view will list all completed and running jobs. It give running times, current step (if active) and average run times for steps.
2019-07-22 (first published: 2019-03-21)
1,758 reads
Jobs
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
2,779 reads
RE: Output parameter returning NULL. Randomly.
Then I think you will benefit from reading this small article. It talks about cache miss that is caused by calling the same proc with different syntaxe. This is not a great performance booster, but every little bit can help on a busy server... But as you can see it can be the cause of […]
2005-05-27
RE: what does DBCC stand for?
Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam. I would really hate to miss a question on something so trivial.Myself, it'll always be the former, I harken back to the 4.21a days on top of LanMan/OS2.
2005-05-05
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers