Can GUID cluster keys cause non-clustered index fragmentation?

How to tell if you have instant initialization enabled?

Why Single-Column Primary/Foreign Keys Can't Always Accurately Model/Constrain Your Data

SQLServer 2008 RTM verfügbar

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

Grossbuchstaben eines Strings zurückgeben

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

PHP Driver 1.0 for SQL Server 2005 released with source

tablediff

Microsoft ® Source Code Analyzer for SQL Injection – July 2008 CTP