SQL 2008 List all DMV Views

SELECT
name, type, type_desc
FROM
sys.system_objects
WHERE
name LIKE 'dm_%'
ORDER BY
name

SQL2008 Listing the 10 Most Expensive Queries

SELECT TOP 10
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)
,qs.execution_count
,qs.total_logical_reads
,qs.last_logical_reads
,qs.total_logical_writes
,qs.last_logical_writes
,qs.total_worker_time
,qs.last_worker_time
,qs.total_elapsed_time/1000000 total_elapsed_time_in_s
,qs.last_elapsed_time/1000000 last_elapsed_time_in_s
,qs.last_execution_time
,qp.query_plan
FROM
sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY
qs.total_logical_reads DESC

Data Management Policies

Data Management

Transferring and Exchanging Data
Permitting Emergency Data Amendment
Receiving Information on Disks
Setting up a New Folder / Directory
Amending Directory Structures
Sharing Data on Project Management Systems
Archiving Documents
Information Retention Policy
Setting up New Spreadsheets
Setting up New Databases
Linking Information between Documents and Files
Updating Draft Reports
Deleting Draft Reports
Using Version Control Systems
Updating Customer Information
Using Meaningful File Names
Managing Data Storage
Managing Databases
Using Headers and Footers
Using and Deleting ‘Temp’ Files
Using Customer and Other Third Party Data Files
Saving Data / Information by Individual Users

Changing a SQL Server 2008 Instance Name

To change the name of a SQL server instance.

EXEC sp_dropserver 'oldname'
GO
EXEC sp_addserver 'newname', 'local'
GO

Now restart the mssqlserver service.

Check the servername using

SELECT @@servername

Creating a Random Date in MySQL

The following code can be used to create a random date between 1930-01-01 and 2010-01-01.

SELECT '1930-01-01' + interval rand() * 29200 day;