Sean's Blog
A place where I record bits and pieces :)
Monday, September 18, 2023
SQL Server: How to run multiple scripts in batch mode
›
In the SQL Management Studio open a new query and type all files as below :r c:\Scripts\script1.sql :r c:\Scripts\script2.sql :r c:\Script...
Thursday, August 17, 2023
SQL Server: Running Jobs Query
›
SELECT j.name AS job_name, ja.start_execution_date AS StartTime, COALESCE(CONVERT(VARCHAR(5),ABS(DATEDIFF(DAY,(GETDATE()-ja.st...
Sunday, June 25, 2023
SQL Server: alter physical file names
›
select 'ALTER DATABASE ' + d.name +' MODIFY FILE ( NAME = ' + f.name + ', FILENAME = ''' + f.physical_name +...
SQL Server set databases offline
›
select 'ALTER DATABASE [' + A.Name + '] SET OFFLINE WITH ROLLBACK IMMEDIATE;' from sys.databases a where a.database_id > ...
SQL Server set databases online
›
select 'ALTER DATABASE [' + A.Name + '] SET ONLINE;' from sys.databases a where a.database_id > 4 and state_desc ='OF...
Friday, June 23, 2023
SQL Server ETA of running SQL e.g. dbcc
›
select T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id) , R.cpu_time, R.total_elapsed_time, R.percent_complete f...
SQL Server Agent Job Startup to remove a tempdb file
›
USE [tempdb] GO DBCC SHRINKFILE (N'temp5', EMPTYFILE) GO ALTER DATABASE [tempdb] REMOVE FILE [temp5] GO
›
Home
View web version