Geek City: Space Used By Worktables mehr »

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

How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3) mehr »

Microsoft SQL Server 2005 Service Pack 3 + Cumulative Updates

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 »

SQL Server 2005 Service Pack 3 released

Zum direkten Download geht es hier: mehr »

Feststellen, ob eine Tabelle einen Trigger besitzt

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 mehr »

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]; mehr »

German translation of Tibor Karaszi`s updated datetime article

Frank Kalis, has translate the The ultimate guide to the datetime datatypes article to German. An article of great value, original written by Tibor Karaszi.So check it out in: EN : The ultimate guide to the datetime datatypes GER: Der ultimative Guide… more »

Cumulative Update #2 for SQL Server 2008 RTM

Alles weitere steht hier: mehr »

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… mehr »

UPDATE STATISTICS undocumented options mehr »

Hints for DML queries mehr »

Non updating updates mehr »

Ordering Guarantees in SQL Server 2005 mehr »

Distinct Aggregation Considered Harmful mehr »

New update on minimal logging for SQL Server 2008 mehr »

SQL Server 2008 Security Whitepapers mehr »

How it Works: SQL Command Mode Parsing mehr »

What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats? mehr »

Random Prefetching mehr »

More Business Logic Validation mehr »

CHECK Constraints vs. TRIGGERS mehr »

Cumulative update package 10 for SQL Server 2005 Service Pack 2

Cumulative update package 10 for SQL Server 2005 Service Pack 2 (Build 9.00.3294) is now available: here you can get the whole information of builds that were released after SQL Server 2005 Service Pack… more »

Über (un)genaue Float-Operationen

Wie wirkt sich eigentlich eine ungenaue Float-Operation aus? Sind die Fehler vernachlässigbar? Durch einen Artikel bei SQL Server Central wurde ich mal wieder inspiriert mich intensiver mit diesem Thema zu beschäftigen. mehr »