<nowikisource lang="tsql">SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],
I.[NAME] AS [INDEX NAME],
USER_SEEKS,
AND USER_UPDATES > 50000
AND (USER_SEEKS + USER_SCANS + USER_LOOKUPS) < 1000
ORDER BY USER_UPDATES desc</nowikisource>
<nowikisource lang="tsql">SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
ON dm_mig.index_handle = dm_mid.index_handle
WHERE dm_mid.database_ID = DB_ID()
ORDER BY Avg_Estimated_Impact DESC</nowikisource>
<nowikisource lang="tsql">SELECT cp.objtype AS ObjectType,
OBJECT_NAME(st.objectid,st.dbid) AS ObjectName,
cp.usecounts AS ExecutionCount,
dbcc memorystatus</nowikisource>
Änderungen – Software Entwicklung Projekte
Änderungen
36 Byte hinzugefügt,
10:57, 21. Apr. 2017