DBCC SQLPERF(logspace) ———————————————————————————————- DECLARE @sql_command varchar(1024) DECLARE @logtable TABLE ( [Database Name] VARCHAR(1000) NULL, [Log Size (MB)] numeric, [Log Space Used (%)] numeric, [Status] VARCHAR(128) NULL ) SELECT @sql_command = ‘dbcc sqlperf (logspace)’ INSERT INTO…
export bcp <database.schema.tablename> out c:\raytemp\tablename.out -n -T -S”<server,port>” import bcp <database.schema.tablename> in c:\raytemp\tablename.out -n -T -S”<server,port>”
Microsoft document: Install SQL Server on Linux [root@oralintest ~]# curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server.repo [root@oralintest ~]# yum install mssql-server … Installed: mssql-server.x86_64 0:14.0.900.75-1 Complete! [root@oralintest ~]# /opt/mssql/bin/mssql-conf setup The license terms for this product can be…
DECLARE @objtable TABLE ( dbname VARCHAR(100) NULL, SizeMB INT ) insert into @objtable exec sp_msforeachdb ‘use [?]; SELECT ”?”, MAX(TotalSpaceMB) as MaxObjSizeMB FROM ( SELECT t.NAME AS TableName, i.name as indexName, (sum(a.total_pages) * 8) /…
https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/
USE [master] GO DECLARE @dbName SYSNAME DECLARE @sqlCmd VARCHAR(MAX) SET @sqlCmd = ” SET @dbName = ” SELECT @sqlCmd = @sqlCmd + ‘KILL ‘ + CAST(session_id AS VARCHAR) + CHAR(13) FROM sys.dm_exec_sessions WHERE DB_NAME(database_id) =…
select * from ( SELECT [UserName] = CASE princ.[type] WHEN ‘S’ THEN princ.[name] WHEN ‘U’ THEN ulogin.[name] COLLATE Latin1_General_CI_AI END, [UserType] = CASE princ.[type] WHEN ‘S’ THEN ‘SQL User’ WHEN ‘U’ THEN ‘Windows User’ END,…
SELECT * FROM ( SELECT TOP 10000 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2)+1) AS [Text], qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time/1000 total_worker_time_in_ms, qs.last_worker_time/1000 last_worker_time_in_ms, qs.total_elapsed_time/1000 total_elapsed_time_in_ms, qs.last_elapsed_time/1000…
select (LEN(@string)-LEN(REPLACE(@string,@strToFind,”)))/LEN(@strToFind)
— Read the errorlog with a stored procedure EXEC xp_ReadErrorLog 0, 1, N’Server is listening on’, N’any’, NULL, NULL, ‘DESC’ GO Or look in the Configuration Manager SQL Server Network Configuration/Protocols/IP Addresses/TCP Port