Archiv für: "Dezember 2008"
Fremdschlüssel Aktion Check
Dez 29th
SELECT
OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsUpdateCascade') AS updcascade,
OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsDeleteCascade') AS delcascade,
[name]
FROM
sys.objects O
WHERE
OBJECTPROPERTY(O.[OBJECT_ID], 'IsForeignKey') = 1 AND… mehr »
Durchschnittliche Zeilenlänge anzeigen
Dez 29th
DECLARE @TableID int
SELECT @TableID = OBJECT_ID ('Enter TableName here')
SELECT
OBJECT_NAME (IXStats.[object_id]) AS ObjectName,
IXStats.index_type_desc,
IXStats.avg_record_size_in_bytes
FROM
sys.dm_db_index_physical_stats (DB_ID(),… mehr »
UPDATE STATISTICS undocumented options
Dez 18th
http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx mehr »
You got questions? I got answers!
Dez 18th
http://feeds.feedburner.com/~r/sqlserverpedia/~3/487244045/ mehr »
Geek City: Space Used By Worktables
Dez 18th
http://sqlblog.com/blogs/kalen_delaney/archive/2008/11/26/space-used-by-worktables.aspx mehr »
SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
Dez 18th
http://blogs.msdn.com/jimmymay/archive/2008/09/01/sql-server-performance-troubleshooting-methodology.aspx mehr »
How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)
Dez 18th
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 mehr »
Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates
Dec 17th
Aaron Bertrand describes in his Blog some very interesting inaccessibilities which belongs to SP3 and CU#10 / CU#11 (CUs after SP2). Take a look at his post:… more »
Feststellen, ob eine Tabelle einen Trigger besitzt
Dez 11th
CodeSELECT CASE WHEN OBJECTPROPERTY(OBJECT_ID('dbo.BookSource'), 'HasAfterTrigger') + OBJECTPROPERTY(OBJECT_ID('dbo.BookSource'), 'HasInsteadOfTrigger') > 0… mehr »
Diagnosing Transaction Log Performance Issues and Limits of the Log Manager
Dez 10th
http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx mehr »
Informationen zu Trigger
Dez 4th
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]; mehr »
