Finding long running queries in SQL server

Tuesday, 8 September 2009

Here's a query to find the longest running queries.This works in SQL Server 2005 and 2008.

SELECT DISTINCT TOP 10
t.TEXT QueryName,
s.execution_count AS ExecutionCount,
s.max_elapsed_time AS MaxElapsedTime,
ISNULL(s.total_elapsed_time / s.execution_count, 0) AS AvgElapsedTime,
s.creation_time AS LogCreatedOn,
ISNULL(s.execution_count / DATEDIFF(s, s.creation_time, GETDATE()), 0)AS FrequencyPerSec
FROM sys.dm_exec_query_stats s
CROSS APPLY sys.dm_exec_sql_text( s.sql_handle ) t
ORDER BY
s.max_elapsed_time DESC

SQL Server 2008 Developer Training Kit

Monday, 22 June 2009

SQL server 2008 Developer Training Kit which is released recently is available here.

Contents
The training kit includes the following content:

• Presentations (6)
• Filestream
• Spatial
• T-SQL
• Date and Time Types
• SQLCLR
• Reporting Services
• Demos (12)
• AdventureWorks Racing All-Up SQL Server 2008 Demo
• SQL Server 2008 All-Up Spatial Demo
• Spatial Types Demo
• Intro to Filestream Demo
• SQL CLR Nullable Types Demo
• Programming with Filestream Demo
• Reporting Services Web Application Integration Demo
• Date and Time Support in SQL Server 2008 Demo
• T-SQL Table-Valued Parameters Demo
• T-SQL Row Constructors Demo
• T-SQL Grouping Sets Demo
• T-SQL Merge Demo
• Hands-on Labs (3)
• Using Spatial Data in TSQL
• Using Spatial Data in Managed Code
• Using SQL CLR in SQL Server 2008

-----------------------------------------------------------------------------------------------------------------------Reference : download.microsoft.com

SQL Server 2008 Wallpaper

Thursday, 4 June 2009

Here's a high resolution SQL Server 2008 wallpaper!

SQL Server 2008 certification path

Monday, 18 May 2009

Download the SQL server (2008) certification path here.

It will be handy if you have any idea of taking Microsoft SQL server certification.

Don't forget, there is a second shot offer available for selected exams till June 30,2009.

You can take these exams in 

Bangalore @

NIIT

#143-B,II Floor , 5th Block,   

60 Feet Road,Koramangala

Bangalore.

In chennai @,

NIIT,

Shah Complex, 59, L B Road,Adyar,

Near Adyar Bus terminal.

Chennai.

Homson prometric testing (p) ltd

No 15,II floor,

Romar house,

Jagannathan road,

Nungambakkam,

Chennai.

Check the nearest Prometric services for more information about exam centers.