摘要： use masterIF EXISTS (SELECT * FROM sys.databasesWHERE name = 'gpdb83sp')BEGINDROP DATABASE gpdb83spEND;CREATE DATABASE gpdb83spON( NAME = gpdb83sp_dat... 阅读全文

摘要： There are three DMVs you can use to track tempdb usage:sys.dm_db_task_space_usagesys.dm_db_session_space_usagesys.dm_db_file_space_usageThe first two ... 阅读全文

摘要： select r.ring_buffer_address,r.ring_buffer_type,dateadd (ms, r.[timestamp] - sysinfo.sqlserver_start_time_ms_ticks, sysinfo.sqlserver_start_time) as r... 阅读全文

摘要： Balancing CPU and I/O throughput is essential to achieve good overall performance and to maximize hardware utilization. SQL Server includes two asynch... 阅读全文

摘要： 1. Grant necessory permission to user account, so it can use SQL profiler.USE masterGRANT ALTER TRACE TO TEST;GRANT VIEW SERVER STATE TO TEST;USE test... 阅读全文

摘要： SET SHOWPLAN_ALL { ON | OFF }It will not execute the TSQL statements.It cannot be specified inside a stored procedure,must be the only statements in a... 阅读全文

摘要： 1.Enable the change tracking at the database level.ALTER DATABASE AdventureWorks2008 SET CHANGE_TRACKING = ON;By Default retention is 2 dyas with auto... 阅读全文

摘要： 1.DMV Query to identify all active SQL Server SessionsThe query below identifies all currently active SQL Server user connections by their SQL Server ... 阅读全文

摘要： Summary Info:Logical Reads : Reading Data pages from CachePhysical Reads : Reading Data pages from Hard DiskBuffer Cach Hit Ratio: (logical reads – ... 阅读全文

摘要： 1. Why we need the index 'include' feature? For SQLServer , the length of all the index key have a limit length as 900 byte.when you create a index wh... 阅读全文