C:\WINDOWS\system32>dism /Get-WimInfo /WimFile:E:\x64\sources\install.esd /index:1
Deployment Image Servicing and Management tool
Version: 10.0.15063.0
Details for image : E:\x64\sources\install.esd
Index : 1
Name : Windows 10 S
Description : Windows 10 S
Size : 15.568.710.987 bytes
WIM Bootable : No
Architecture : x64
Hal : <undefined>
Version : 10.0.16299
ServicePack Build : 15
ServicePack Level : 0
Edition : Cloud
Installation : Client
ProductType : WinNT
ProductSuite : Terminal Server
System Root : WINDOWS
Directories : 21270
Files : 102845
Created : 30.09.2017 - 16:24:52
Modified : 15.11.2017 - 10:09:06
Languages :
tr-TR (Default)
The operation completed successfully.
14 Kasım 2017 Salı
13 Kasım 2017 Pazartesi
SQL Server index fragmentation
SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType, indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 30 ORDER BY indexstats.avg_fragmentation_in_percent DESC
Kaydol:
Kayıtlar (Atom)