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 »
German translation of Tibor Karaszi`s updated datetime article
Nov 27th
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
Nov 10th
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
Nov 9th
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
Nov 6th
http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx mehr »
Hints for DML queries
Nov 6th
http://blogs.msdn.com/queryoptteam/archive/2006/07/14/666196.aspx mehr »
Ordering Guarantees in SQL Server 2005
Nov 6th
http://blogs.msdn.com/queryoptteam/archive/2006/05/02/588731.aspx mehr »
Distinct Aggregation Considered Harmful
Nov 6th
http://blogs.msdn.com/sqlqueryprocessing/archive/2008/09/22/distinct-aggregation-considered-harmful.aspx mehr »
New update on minimal logging for SQL Server 2008
Nov 6th
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
Nov 6th
http://blogs.msdn.com/sqlsecurity/archive/2008/10/06/sql-server-2008-security-whitepapers.aspx mehr »
How it Works: SQL Command Mode Parsing
Nov 6th
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?
Nov 6th
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
Nov 6th
http://blogs.msdn.com/craigfr/archive/2008/10/07/random-prefetching.aspx mehr »
More Business Logic Validation
Nov 6th
http://blogs.msdn.com/conor_cunningham_msft/archive/2008/10/31/more-business-logic-validation.aspx mehr »
CHECK Constraints vs. TRIGGERS
Nov 6th
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
Oct 31st
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
Okt 30th
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 »
Microsoft SQL Server 2005 Service Pack 3 Beta now available
Oct 29th
Now it`s time. Microsoft SQL Server 2005 Service Pack 3 Beta is now available for testing. But remember these packages have been made available for general testing purposes only. Do not deploy the Beta software in production.
Download SQL 2005 SP3… more »