Kategorie: "SQL Server"

High-performance FILESTREAM tips and tricks

Posted on Aug 26, 2008 von in SQL Server
http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx

Can GUID cluster keys cause non-clustered index fragmentation?

Posted on Aug 21, 2008 von in SQL Server
http://www.sqlskills.com/blogs/paul/2008/08/20/CanGUIDClusterKeysCauseNonclusteredIndexFragmentation.aspx

How to tell if you have instant initialization enabled?

Posted on Aug 14, 2008 von in SQL Server
http://www.sqlskills.com/blogs/paul/2008/08/11/HowToTellIfYouHaveInstantInitializationEnabled.aspx

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

Posted on Aug 14, 2008 by in SQL Server
http://weblogs.sqlteam.com/jeffs/archive/2008/08/13/examining-database-primary-keys.aspx

Grossbuchstaben eines Strings zurückgeben

Posted on Jul 29, 2008 von in SQL Server
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
Tags: ,

PHP Driver 1.0 for SQL Server 2005 released with source

Posted on Jul 29, 2008 von in SQL Server
http://blogs.technet.com/dataplatforminsider/archive/2008/07/28/php-driver-1-0-for-sql-server-2005-released-with-source.aspx
Tags:

tablediff

Posted on Jul 21, 2008 von in SQL Server
http://blogs.msdn.com/benjones/archive/2008/07/18/tablediff.aspx

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

Posted on Jul 21, 2008 von in SQL Server
http://blogs.msdn.com/sqlsecurity/archive/2008/07/12/microsoft-source-code-analyzer-for-sql-injection-july-2008-ctp.aspx