Category: MSSQL

1 min read 0

About SQL Server Versions

  • OTI
  • 10 September 2019
Introduction I always very much confused about SQL Server Versions. To check the SQL Server version by TSQL we may…
1 min read 0

Important & Handy TSQL Commands

  • OTI
  • 7 October 2017
Space Management TSQL Commands 1)sp_spaceused2)dbcc sqlperf(logspace)3)xp_fixeddrives Information TSQL Commands 1) sp_helpdb2) select db_id('DBName')3) select db_name(DBID)4) select * from sys.dm_exec_sessions, dm_exec_connections5)…