Wednesday, September 8, 2010

SET STATISTICS TIME ON ? how to read ...

SET STATISTICS TIME ON – how to read results? - The SET STATISTICS TIME command is used in order to identify parse, ... http://ping.fm/DB5i8

SET STATISTICS TIME ON ? how to read ...

SET STATISTICS TIME ON รข€“ how to read results? - The SET STATISTICS TIME command is used in order to identify parse, ... http://ping.fm/DB5i8

Tuesday, September 7, 2010

Find All Queries executed on a partic...

Find All Queries executed on a particular Table - Question : what all select queries are running against a particula... http://ping.fm/DV0qw

Find All Queries executed on a partic...

Find All Queries executed on a particular Table - Question : what all select queries are running against a particula... http://ping.fm/DV0qw

Find All Queries executed on a partic...

Find All Queries executed on a particular Table - Question : what all select queries are running against a particula... http://ping.fm/DV0qw

Monday, September 6, 2010

SQL Monitoring with DDL Triggers - We...

SQL Monitoring with DDL Triggers - We can create a DDL trigger to audit operations such as creating or dropping tabl... http://ow.ly/18TD3N

If you wanted to know : What is Stor...

If you wanted to know :

What is Stored in tempdb ?
A more about tempdb Internals
How to Monitor tempdb
How to Optimize tempdb
tempdb Space Allocation
Tips for Optimizing tempdb
How Many Physical Files Should tempdb Have ?
How to Move tempdb ?

Checkout the answer at :
http://ping.fm/P7SeW