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_handle) [Statement]
OUTER APPLY sys.dm_exec_query_plan(plan_handle) Executionplan
WHERE
Statement.[text] LIKE @string AND
SCP.cacheobjtype ='Compiled Plan' AND
SCP.objtype = 'proc'
Should Microsoft provide a transaction log reader tool?
http://www.sqlskills.com/blogs/paul/2008/08/26/ShouldMicrosoftProvideATransactionLogReaderTool.aspx
High-performance FILESTREAM tips and tricks
http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx
Can GUID cluster keys cause non-clustered index fragmentation?
http://www.sqlskills.com/blogs/paul/2008/08/20/CanGUIDClusterKeysCauseNonclusteredIndexFragmentation.aspx
How to tell if you have instant initialization enabled?
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
http://weblogs.sqlteam.com/jeffs/archive/2008/08/13/examining-database-primary-keys.aspx
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
