Kategorie: "SQL Server"
SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
http://blogs.msdn.com/jimmymay/archive/2008/09/01/sql-server-performance-troubleshooting-methodology.aspx
How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)
http://blogs.msdn.com/psssql/archive/2008/12/16/how-it-works-sql-server-no-longer-uses-rdtsc-for-timings-in-sql-2008-and-sql-2005-service-pack-3-sp3.aspx
Feststellen, ob eine Tabelle einen Trigger besitzt
SELECT
CASE
WHEN OBJECTPROPERTY(OBJECT_ID('dbo.BookSource'), 'HasAfterTrigger') + OBJECTPROPERTY(OBJECT_ID('dbo.BookSource'), 'HasInsteadOfTrigger') > 0
THEN 'Trigger vorhanden'
ELSE 'Kein Trigger vorhanden'
END
GO
IF EXISTS (SELECT 1
FROM
sys.triggers T
WHERE
T.parent_id = OBJECT_ID ('dbo.BookSource'))
SELECT 'Trigger vorhanden'
ELSE
SELECT 'Kein Trigger vorhanden'Diagnosing Transaction Log Performance Issues and Limits of the Log Manager
http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx
Informationen zu Trigger
SELECT
T.[name] AS Trigger_Name,
OBJECT_NAME(T.parent_id) AS Table_Name,
TE.type_desc,
T.create_date
FROM
sys.triggers T
JOIN
sys.trigger_events TE ON T.[object_id] = TE.[object_id];
UPDATE STATISTICS undocumented options
http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx
