Indexfragmentierung anzeigen
Sep 1st
SELECT DB_NAME(IXStats.database_id) AS DatabaseName, OBJECT_NAME (IXStats.[object_id]) AS TabellenName, SIX.[Name] AS IndexName, IXStats.avg_fragmentation_in_percent, IXStats.index_type_desc FROM sys.dm_db_index_physical_stats… mehr »
TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database
Sep 1st
http://www.sqlskills.com/blogs/paul/2008/08/29/TechEdDemoCreatingDetachingReattachingAndFixingASuspectDatabase.aspx mehr »
Plan Reuse abfragen
Aug 29th
DECLARE @string varchar(500) SELECT @string = '%SomeString%' SELECT SCP.usecounts, SCP.cacheobjtype, SCP.objtype, [Statement].text, Executionplan.query_plan FROM sys.dm_exec_cached_plans SCP OUTER APPLY… mehr »
Where the Heck is DMO?
Aug 29th
http://blogs.msdn.com/dtjones/archive/2008/08/28/where-the-heck-is-dmo.aspx mehr »
Should Microsoft provide a transaction log reader tool?
Aug 26th
http://www.sqlskills.com/blogs/paul/2008/08/26/ShouldMicrosoftProvideATransactionLogReaderTool.aspx mehr »
High-performance FILESTREAM tips and tricks
Aug 26th
http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx mehr »
Can GUID cluster keys cause non-clustered index fragmentation?
Aug 21st
http://www.sqlskills.com/blogs/paul/2008/08/20/CanGUIDClusterKeysCauseNonclusteredIndexFragmentation.aspx mehr »
How to tell if you have instant initialization enabled?
Aug 14th
http://www.sqlskills.com/blogs/paul/2008/08/11/HowToTellIfYouHaveInstantInitializationEnabled.aspx mehr »
Why Single-Column Primary/Foreign Keys Can't Always Accurately Model/Constrain Your Data
Aug 14th
http://weblogs.sqlteam.com/jeffs/archive/2008/08/13/examining-database-primary-keys.aspx more »
Virtual Lab: What's New in SQL Server 2008 for Database Administrators
Aug 11th
Free on-line lab to started quickly:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358030&EventCategory=3&culture=en-US&CountryCode=US
CU
tosc more »
Webcast: Upgrade and Migration to SQL Server 2008
Aug 8th
Learn to install and upgrade to SQL Server 2008,
check out this free webcast:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US
CU
tosc more »
SQL Server 2008 is RTM, YES!
Aug 7th
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Aug 9 2008 10:01:31
The download ISOs are available from MSDN Subscriber Downloads and/or TechNet Subscriber Downloads, I didn't know when it will be available for non-MSDN/TechNet… more »
SQLServer 2008 RTM verfügbar
Aug 7th
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 mehr »
Grossbuchstaben eines Strings zurückgeben
Jul 29th
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… mehr »
PHP Driver 1.0 for SQL Server 2005 released with source
Jul 29th
http://blogs.technet.com/dataplatforminsider/archive/2008/07/28/php-driver-1-0-for-sql-server-2005-released-with-source.aspx mehr »
Microsoft Visual Studio Team System 2008 Database Edition GDR July CTP Released
Jul 21st
Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP is available for download.Download it here: http://www.microsoft.com/downloads/deta ... laylang=en
CU
tosc more »
Microsoft ® Source Code Analyzer for SQL Injection – July 2008 CTP
Jul 21st
http://blogs.msdn.com/sqlsecurity/archive/2008/07/12/microsoft-source-code-analyzer-for-sql-injection-july-2008-ctp.aspx mehr »
SQL Server 2008 Beta Exams
Jul 15th
The Microsoft certifications blog for developer & SQL Server technologies, makes an Open Inventation for SQL Server 2008 DBA 71-432 and SQL Server 2008 BI 71-448, only through the end of July.Link:… more »
Microsoft Security Bulletin Summary for July 2008
Jul 9th
http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx more »
SQL Server I/O Bottleneck, I don't have one, YES YOU DO!
Jul 9th
http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx mehr »
