Sign in
Vipul Shah's SQL Blogs
SQL Server Blogs
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
/3GB /PAE and AWE
64-bit
Benefits of SQL 2005
Bing
Bing Map Apps
Bing Maps
Data Scripter Utility
Database Design
DDL Triggers
Default Traces
DTS
Guest User in SQL Server
Indexes
Integration Services
LOGON Triggers
Migration to SQL 2005
Missing Indexes DMVs
Monitoring
Patches
Reporting Services
SQL Server Management Studio
SQL Server Performance
Table Partitioning
T-SQL
Archive
Archives
May 2013
(1)
January 2013
(1)
November 2012
(1)
March 2012
(1)
January 2012
(2)
June 2011
(3)
February 2011
(1)
November 2010
(3)
October 2010
(2)
August 2010
(1)
June 2010
(2)
June 2009
(1)
May 2009
(1)
January 2009
(1)
April 2008
(1)
February 2008
(2)
December 2007
(2)
September 2007
(3)
August 2007
(1)
July 2007
(1)
June 2007
(1)
May 2007
(3)
April 2007
(3)
March 2007
(5)
February 2007
(2)
January 2007
(1)
November 2006
(2)
December, 2007
TechNet Blogs
>
Vipul Shah's SQL Blogs
>
December, 2007
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Vipul Shah's SQL Blogs
Finding Missing Indexes and Unused Indexes using DMVs
Posted
over 6 years ago
by
VipulShah
0
Comments
Finding Missing Indexes: Dynamic management object Information returned sys.dm_db_missing_index_group_stats Returns summary information about missing index groups, for example, the performance improvements that could...
Vipul Shah's SQL Blogs
DDL Triggers and LOGON Triggers
Posted
over 6 years ago
by
VipulShah
1
Comments
DDL Triggers: DDL triggers can be used for administrative tasks such as auditing and regulating database operations. Use DDL triggers when you want to do the following: ¾ You want to prevent certain changes to your database schema. ¾ You want...
Page 1 of 1 (2 items)