Frank Kalis

Ab sofort ist SQL Server 2008 RTM für TechnetPlus- /MSDN-Abonnenten zum download verfügbar.

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
    Aug 7 2008 10:01:31

Zugegeben nicht gerade etwas, das man jeden Tag braucht, aber falls doch...

DECLARE @s varchar(100);
SELECT @s = 'Und Was Habe Ich Damit Zu Tun?';

SELECT 
    x.OnlyInitials
FROM
    (SELECT
        SUBSTRING(@s, N.Number, 1) 
    FROM
        dbo.Number N
    WHERE 
        N.Number BETWEEN 1 AND LEN(@s) AND
        ASCII(SUBSTRING(@s, N.Number, 1)) BETWEEN 65 AND 90
        FOR XML PATH('')) AS x(OnlyInitials);

OnlyInitials
------------
UWHIDZT

(1 row(s) affected

http://blogs.technet.com/dataplatforminsider/archive/2008/07/28/php-driver-1-0-for-sql-server-2005-released-with-source.aspx

http://blogs.msdn.com/benjones/archive/2008/07/18/tablediff.aspx

http://blogs.msdn.com/sqlsecurity/archive/2008/07/12/microsoft-source-code-analyzer-for-sql-injection-july-2008-ctp.aspx

http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx

http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx

http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx