https://wiki.nekotype.com/ 2026-04-30T22:29:07+0900 https://wiki.nekotype.com/ https://wiki.nekotype.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2020-06-25T23:11:44+0900 Anonymous (anonymous@undisclosed.example.com) https://wiki.nekotype.com/sqlserver/%E3%83%88%E3%83%A9%E3%83%B3%E3%82%B6%E3%82%AF%E3%82%B7%E3%83%A7%E3%83%B3%E5%88%86%E9%9B%A2%E3%83%AC%E3%83%99%E3%83%AB%E3%81%AE%E7%A2%BA%E8%AA%8D?rev=1593094304&do=diff トランザクション分離レベルの確認 #確認 DBCC USEROPTIONS #Sessionレベルでの変更 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET TRANSACTION ISOLATION LEVEL READ COMMITTED SET TRANSACTION ISOLATION LEVEL REPEATABLE READ SET TRANSACTION ISOLATION LEVEL SNAPSHOT SET TRANSACTION ISOLATION LEVEL SERIALIZABLE #DatabaseレベルのREAD COMMITTED SNAPSHOT 設定の有効化 ALTER DATABASE [データベース名] SET READ_COMMITTED_SNAPSHOT ON text/html 2020-06-25T09:12:51+0900 Anonymous (anonymous@undisclosed.example.com) https://wiki.nekotype.com/sqlserver/%E3%83%AD%E3%83%83%E3%82%AF%E3%81%AE%E7%A2%BA%E8%AA%8D?rev=1593043971&do=diff ロックの確認 SELECT * FROM sys.dm_tran_locks SELECT resource_type AS type --オブジェクトの種類 ,resource_associated_entity_id as entity_id --エンティティID ,( CASE WHEN resource_type = 'OBJECT' THEN OBJECT_NAME( resource_associated_entity_id ) ELSE ( SELECT OBJECT_NAME( OBJECT_ID ) FROM sys.partitions WHERE hobt_id=resource_associated_entity_id ) END) AS object_name ,re… text/html 2020-06-25T09:19:26+0900 Anonymous (anonymous@undisclosed.example.com) https://wiki.nekotype.com/sqlserver/%E4%B8%80%E8%A6%A7%E5%8F%96%E5%BE%97?rev=1593044366&do=diff 一覧取得 データベースの一覧 SELECT name, database_id, create_date FROM sys.databases テーブルの一覧 #全テーブル取得 select * from sys.objects #ユーザーテーブル一覧 select * from sys.objects where type = 'U' #特定(hoge)のスキーマ配下のテーブル一覧 select * from sys.objects where schema_id = schema_id('hoge')