Kategorie: "SQL Server"

SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction

Posted on Dez 18, 2008 von in SQL Server
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)

Posted on Dez 18, 2008 von in SQL Server
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

Posted on Dez 11, 2008 von in SQL Server
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

Posted on Dez 10, 2008 von in SQL Server
http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx

Informationen zu Trigger

Posted on Dez 4, 2008 von in SQL Server
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

Posted on Nov 6, 2008 von in SQL Server
http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx

Hints for DML queries

Posted on Nov 6, 2008 von in SQL Server
http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx

Non updating updates

Posted on Nov 6, 2008 von in SQL Server
http://blogs.msdn.com/queryoptteam/archive/2006/07/07/659453.aspx