Kunal RanpuraJul 29, 20191 minFind SQL Server Version-- SQL and OS Version information for current instance SELECT @@VERSION AS [SQL Server and OS Version Info];
Kunal RanpuraJul 29, 20192 minScript to restore multiple database backupsThe following script will generate output script with restore command to restore all log backup located at L:\Log_Backup\DB_Name\ exec...
Kunal RanpuraJul 29, 20191 minChange DB_Owner to SA/* The Code */ --If you want to get a list of current owners who aren't sa SELECT suser_sname(owner_sid) as DBOwner, Name as DBName FROM...
Kunal RanpuraJul 29, 20191 minScript to find SQL Server Data and Log file Auto Growth Event--Script to find autogrowth event from the default trace. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLARE...
Kunal RanpuraJul 29, 20191 minFind Job History for all SQL Server Agent Jobs.Use msdb go select distinct j.Name as "Job Name", --j.job_id, case j.enabled when 1 then 'Enable' when 0 then 'Disable' end as "Job...
Kunal RanpuraJul 29, 20191 minScript to list table names short by total space used desc.SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS...
Kunal RanpuraJul 28, 20191 minScript to compare data between two tables-- Show data in table dbtest02 that do not exists in dbtest01 select * from dbtest02.dbo.article except select * from dbtest01.dbo.article