Archiv für: August 2008
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 sys.dm_exec_sql_text(plan_handl… 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 »
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 »
XML-Feeds