Archiv für: August 2008

Plan Reuse abfragen

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?

http://blogs.msdn.com/dtjones/archive/2008/08/28/where-the-heck-is-dmo.aspx mehr »

Should Microsoft provide a transaction log reader tool?

http://www.sqlskills.com/blogs/paul/2008/08/26/ShouldMicrosoftProvideATransactionLogReaderTool.aspx mehr »

High-performance FILESTREAM tips and tricks

http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx mehr »

Can GUID cluster keys cause non-clustered index fragmentation?

http://www.sqlskills.com/blogs/paul/2008/08/20/CanGUIDClusterKeysCauseNonclusteredIndexFragmentation.aspx mehr »

How to tell if you have instant initialization enabled?

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

http://weblogs.sqlteam.com/jeffs/archive/2008/08/13/examining-database-primary-keys.aspx more »

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 mehr »