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 OWHERE OBJECTPROPERTY(O.[OBJECT_ID], 'IsForeignKey') = 1 AN… mehr »
Durchschnittliche Zeilenlänge anzeigen
Dez 29th
DECLARE @TableID intSELECT @TableID = OBJECT_ID ('Enter TableName here')SELECT OBJECT_NAME (IXStats.[object_id]) AS ObjectName, IXStats.index_type_desc, IXStats.avg_record_size_in_bytesFROM sys.dm_db_index_physical_stats (DB… 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 »
SQL Server 2005 Service Pack 3 released
Dez 16th
Zum direkten Download geht es hier: http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4 Hier findet man die ganze Familie von SP 3: http://www.microsoft.com/downloads/results.aspx?freete… mehr »
XML-Feeds