bedbmsguru

출처: https://goosl.tistory.com/entry/MS-SQL-설치-센터-실행시-오류 [하늘 빛 하늘]

설치를 위해서 Setup을 실행할경우 아래 오류가 발생하는 경우가 있다.

solution
해결 방법은 저기 보이는 디렉토리 폴더를 삭제 해주면 된다. 

System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ or one of its dependencies. The system cannot find the file specified. (C:\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config line 5) —> System.IO.FileNotFoundException: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ or one of its dependencies. The system cannot find the file specified.
File name: ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′
at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory..ctor(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)
at System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord)
at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

출처: https://goosl.tistory.com/entry/MS-SQL-설치-센터-실행시-오류 [하늘 빛 하늘]

SELECT      t.NAME AS TableName
,    s.Name AS SchemaName
,    p.rows
,      CAST(ROUND(((SUM(a.total_pages)   *  8)   /  1024.00),  2)  AS NUMERIC(36,  2))  AS TotalSpaceMB
,      CAST(ROUND(((SUM(a.total_pages)   *  8)   /  1024.00/1024),  2)  AS NUMERIC(36,  2))  AS TotalSpaceGB
,      CAST(ROUND(((SUM(a.used_pages)   *  8)   /  1024.00),  2)  AS NUMERIC(36,  2))  AS UsedSpaceMB
,      CAST(ROUND(((SUM(a.used_pages)   *  8)   /  1024.00/1024),  2)  AS NUMERIC(36,  2))  AS UsedSpaceGB
,    CAST(ROUND(((SUM(a.total_pages)   -  SUM(a.used_pages))   *  8)   /  1024.00,  2)  AS NUMERIC(36,  2))  AS UnusedSpaceMB FROM      sys.tables t INNER JOIN           sys.indexes i ON t.OBJECT_ID  =  i.object_id INNER JOIN      sys.partitions p ON i.object_id  =  p.OBJECT_ID AND i.index_id  =  p.index_id INNER JOIN       sys.allocation_units a ON p.partition_id  =  a.container_id LEFT OUTER JOIN      sys.schemas s ON t.schema_id  =  s.schema_id WHERE      t.NAME NOT LIKE  'dt%'       AND t.is_ms_shipped  =  0     AND i.OBJECT_ID  >  255  GROUP BY      t.Name
, s.Name
, p.Rows ORDER BY      TotalSpaceMB DESC
, t.Name

https://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database/7892349

테이블 반환함수 VIEW를 대체하면 VIEW보다 성능이 좋다.

https://templar.tistory.com/34