SQL

Since model is a system databases, unfortunately we cannot move this just by detach and attach process, as we cannot attach or detach a sy...

Below is the query to rename all stored procedures with some a specific word as prefix. SELECT 'EXEC sp_rename '+ ''...

Clustered and Non clustered indexes are stored in B-Tree Structure. Clustered Index Clustered index enforce the logical order. (Misco...

Sometimes we may need to extract only numbers from a string. The simple approach is to run a while loop on given string to check each and ...

You can disable a Job either through Job ID or Job Name: exec msdb..sp_update_job @job_id = 0xC0923E436928064EA33B46B2A47BFF61 , @enabled...