SQL Server batch processes are usually run from SQL Agent in the background. Often, the responsibility for creating these tasks belongs entirely to the developer. Dennes Torres demonstrates that DBAs can advise and assist with this type of batch job to help reduce their impact on the working system.
2015-05-25
7,564 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers