Shashi Kant Chauhan

MSSQL Job Monitoring Simplified using Simple Query

This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-12-02

1,024 reads

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Over the past few months, I have debated starting a new blog to discuss...

It’s that time of the month again, and once again, I’m late and I’m...

So folks we have around 30/40 sql server failover cluster insatnce with each having...

Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...

hi, need to known weather fast farwand cursor is faster than a while loop...

I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?

SELECT   
    INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail')