Identify memory pressure (SQL 2008)

-- SQL Server 2008 and R2 Memory Related Queries
-- By Glenn Berry Oct 2010

http://glennberrysqlperformance.spaces.live.com/
-- Twitter: GlennAlanBerry

Identify top 20 most expensive queries

-- Identify top 20 most expensive queries
-- By Satya

Get date when DB was last accessed

-- Database last accessed date (read and write)
-- By Aaron Bertrand

Increase number of ERRORLOGs

-- Increase number of ERRORLOGS to 20, change last value if needed
-- From http://support.microsoft.com/kb/196909

Get logcal and physical DB names

--Get logical and physical DB names for restore purposes
--Last update MsMiller 10/04/11


--SELECT LOGICAL AND PHYSICAL NAMES 2005
SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName
FROM sys.master_files

--SELECT LOGICAL AND PHYSICAL NAMES 2000
SELECT DB_NAME(dbid) AS DatabaseName, name AS LogicalFileName, filename AS PhysicalFileName
FROM master..sysaltfiles

Current Users, Session Counts & Authentication Type

--Current Users, Session Counts & Authentication Type
--From SQLserverCentral.com

Get index usage stats with fragmentation in spec DB

-- Run agaist DB you want to retrieve Index Usage Stats with the fragmentation level
-- Last update by : MsMiller 12-10-10

Change all DBs to FULL recover model

--Change all DBs to FULL recover model
--Last update by MsMiller 27-10-09

Get size of all DBs (MB)

-- Get size of all DBs in MB
-- Last update: MsMiller 09/08/09