Browse by Tags

SQL Server 2008 TSQL enhancements - what I like?

Published 4 April 8 9:58 AM | SSQA.net

Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...

Filed under: sql server, performance, blogs, technet, merge, tsql, plan guide, new features, tvp, table-value

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)

Published 15 November 7 7:16 AM | SSQA.net

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...

Filed under: sql server, performance, microsoft, technet, dmv, top, tsql, reads, system resources, expensive query, identity, writes