SQL 서버의 성능 저하 – 아키텍처 불량 이는 성능이 떨어지는 SQL Server의 가장 큰 이유인 것으로 보입니다. 그러나 건축의 주제는 매우 광범위하며 건축비효율성의 모든 지점을…
USE master GO IF OBJECT_ID (‘sp_hexadecimal’) IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT…
USE master GO — 보조 복제본 읽기 전용 연결 허용 (UI로 변경 가능) ALTER AVAILABILITY GROUP [ALG] MODIFY REPLICA ON N’WS16-AOSVR1′ WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS…
EXEC sp_configure ‘external scripts enabled’, 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure ‘external scripts enabled’ USE <database_name> GO GRANT EXECUTE ANY EXTERNAL SCRIPT TO [UserName] EXEC…
SELECT OBJECT_NAME(p.object_id) AS ObjectName, i.name AS IndexName, p.index_id AS IndexID, ds.name AS PartitionScheme, p.partition_number AS PartitionNumber, fg.name AS FileGroupName, prv_left.value AS LowerBoundaryValue, prv_right.value AS UpperBoundaryValue,…
Views Today : 9
Views Yesterday : 54
Views This Month : 9
Views This Year : 4055
Total views : 84146
Who's Online : 0