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,076 reads

The first version of my accounting assistant could not find a single purchase of...

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

I’m really excited about some growth in Flyway support. I’ve been asking about this...

Comments posted to this topic are about the item Pay for Performance, which is...

Hi I have this slow query that is pulling data from a linked server....

Comments posted to this topic are about the item Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;