Archiv für: "November 2008"

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 »