SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)
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
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];
Cumulative Update #2 for SQL Server 2008 RTM
Alles weitere steht hier:
http://blogs.msdn.com/sqlreleaseservices/archive/2008/11/19/cumulative-update-2-for-sql-server-2008-rtm.aspx
European PASS Conference 2009
The 2008 European PASS Conference was an outstanding success, attracting speakers and attendees from all around the world, not just Europe! We had 39 sessions and pre-conference seminars focused on SQL Server technologies covering Business Intelligence, Database Administration and Application Development from high level product overviews to in-depth troubleshooting and configuration. A lot to digest over three packed days!
The feedback received from attendees, exhibitors and sponsors alike was better than we could have ever imagined (hats off to the various volunteer committees involved, conference partners and e-team!), and we're looking earnestly forward to the 2009 Conference!
The Basics
When: 22 - 24 April 2009
Where: Swissôtel Neuss, Germany
For more information, visit the website at http://www.european-pass-conference.com/, register your email address to receive progress updates.
