SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets Unable to connect to SQL Server Unable to access a database Unable to identify a table Want to run a script, but need DBA assistance Queries are…
Read FullCustomer Raised Tickets Unable to connect to SQL Server Unable to access a database Unable to identify a table Want to run a script, but need DBA assistance Queries are…
Read FullSpace 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) select * from sys.databases6) select * from sys.database_files Monitoring TSQL…
Read Full