SQL Performance – Explain Plan
sp_updatestats
Display sys procedures in SQL Server
SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + ‘.’ + QUOTENAME(name) FROM sys.all_objects WHERE type = ‘P’ AND is_ms_shipped = 1
Oracle hash values for Passwords
set long 150 set linesize 150 set longchunksize 150 select ‘alter user ‘||username||’ identified by values ‘||REGEXP_SUBSTR(DBMS_METADATA.get_ddl (‘USER’,USERNAME), ”'[^”]+”’)||’;’ from dba_users
Powershell – Recursive Search for Strings in Files
To search for a string (grep) in files recursively with Powershell (example): gci -recurse -include *.sql|%{gc $_} | %{$_|select-string “dba”} To get the filename(s): gci -recurse -include *.txt|%{$Filename=$_;gc $_} | %{$res=$_|select-string “dba”;if ($res) {Write-Host “$Filename”}}
SQL Server – Translate object_ids/object_names
— Get object_id from object name select OBJECT_ID(‘[dbo].[testobject]’) — get object_name from object id select OBJECT_NAME(213575799)
SQL Server – Display Running Tasks
Use this query in conjunction with sp_who to display running tasks and determine whether there are sessions blocking other sessions, and who is executing the query (sp_who) SELECT command, r.session_id, r.blocking_session_id, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600)…
Changing SQL Server Database Collation
See the article: http://sqlmag.com/database-performance-tuning/seven-step-process-changing-database-collation
free -m
Real Memory Consumption = Total – (free + buffers + cached) # free -m total used free shared buffers cached Mem: 15943 15678 265 6 511 3706 -/+ buffers/cache: 11460 4483 Swap: 8159 0…
Flush and Reset Client Resolver Cache
ipconfig /flushdns