MS SQL Query

Wednesday, 26 March 2025

To check Server level configure settings

SP_configure

--------- To check Advance Server level configuration settings

SP_configure 'show advanced options' ,1
reconfigure

at March 26, 2025

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

To Shrink Tempdb

To check progress of SQL Server Backup or Restore process

SELECT r.session_id , r.command , CONVERT(NUMERIC(6,2), r.percent_complete) AS [Percent Complete] , CONVERT(VARCHAR(20), DATEADD(ms,r....
To find all databases data files size and free space

IF OBJECT_ID('tempdb..#DBFiles') IS NOT NULL DROP TABLE #DBFiles CREATE TABLE #DBFiles ( [id] INT IDENTITY(1,1), [DBNam...

Search This Blog

Home

About Me

MSSQL

View my complete profile

Report Abuse

Blog Date

May 2025 (3)
March 2025 (6)

MS SQL TECH QUERY. Watermark theme. Powered by Blogger.