Geek City: Space Used By Worktables

http://sqlblog.com/blogs/kalen_delaney/archive/2008/11/26/space-used-by-worktables.aspx mehr »

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

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)

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

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

http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx 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: http://blogs.msdn.com/sqlreleaseservices/archive/2008/11/19/cumulative-update-2-for-sql-server-2008-rtm.aspx 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

http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx mehr »

Hints for DML queries

http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx mehr »

Non updating updates

http://blogs.msdn.com/queryoptteam/archive/2006/07/07/659453.aspx mehr »

Ordering Guarantees in SQL Server 2005

http://blogs.msdn.com/queryoptteam/archive/2006/05/02/588731.aspx mehr »

Distinct Aggregation Considered Harmful

http://blogs.msdn.com/sqlqueryprocessing/archive/2008/09/22/distinct-aggregation-considered-harmful.aspx mehr »

New update on minimal logging for SQL Server 2008

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx mehr »

SQL Server 2008 Security Whitepapers

http://blogs.msdn.com/sqlsecurity/archive/2008/10/06/sql-server-2008-security-whitepapers.aspx mehr »

How it Works: SQL Command Mode Parsing

http://blogs.msdn.com/psssql/archive/2008/09/18/how-it-works-sql-command-mode-parsing.aspx mehr »

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

http://blogs.msdn.com/craigfr/archive/2008/10/30/what-is-the-difference-between-sys-dm-db-index-usage-stats-and-sys-dm-db-index-operational-stats.aspx mehr »

Random Prefetching

http://blogs.msdn.com/craigfr/archive/2008/10/07/random-prefetching.aspx mehr »

More Business Logic Validation

http://blogs.msdn.com/conor_cunningham_msft/archive/2008/10/31/more-business-logic-validation.aspx mehr »

CHECK Constraints vs. TRIGGERS

http://blogs.msdn.com/conor_cunningham_msft/archive/2008/10/28/check-constraints-vs-triggers.aspx 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: http://support.microsoft.com/kb/956854And 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 »