589689.xyz

[Специалист] M55144B Настройка производительности и оптимизация SQL Server 2014

  • 收录时间:2018-04-08 18:38:53
  • 文件大小:11GB
  • 下载次数:105
  • 最近下载:2020-12-10 21:48:25
  • 磁力链接:
立即下载 复制链接

文件列表

  1. Образ winserv2012r2/55144BC.part01.rar 2GB
  2. Образ winserv2012r2/55144BC.part02.rar 2GB
  3. Образ winserv2012r2/55144BC.part03.rar 2GB
  4. Образ winserv2012r2/55144BC.part04.rar 1GB
  5. m55144 3.mp4 821MB
  6. m55144 2.mp4 659MB
  7. m55144 4.mp4 563MB
  8. m55144 1.mp4 537MB
  9. Lab Files/8 In-Memory OLTP/Test_IM_OLTP 491MB
  10. Book/55144BCVideospart1.rar 110MB
  11. Book/55144BCVideospart2.rar 110MB
  12. Book/55144BCVideospart3.rar 110MB
  13. Book/55144BCDataBasespart1.rar 110MB
  14. Book/55144BCVideospart4.rar 100MB
  15. Book/55144BCLabFiles.rar 28MB
  16. Book/5 Query Optimizing and Operators.pdf 11MB
  17. Lab Files/7 Statistics/DB backup for Statistics/BUofPartionedDB.bak 10MB
  18. Book/3 The Database Engine.pdf 8MB
  19. Book/7 UNDERSTANDING STATISTICS.pdf 7MB
  20. Book/8 IN-MEMORY DATABASES.pdf 7MB
  21. Book/6 Understanding Indexes.pdf 6MB
  22. Book/10 QUERY ISSUES AND HINTS.pdf 6MB
  23. Book/9 SQL PROFILER AND SQL TRACE.pdf 5MB
  24. Lab Files/9 Trace and Profiler/Tuning2_1.trc 5MB
  25. Lab Files/9 Trace and Profiler/Tuning2.trc 5MB
  26. Book/2 SQL 2014 Architecture.pdf 5MB
  27. Book/4 SQL Performance Tools.pdf 4MB
  28. Lab Files/9 Trace and Profiler/Tuning2_2.trc 3MB
  29. Lab Files/9 Trace and Profiler/Tuneing2.trc 839KB
  30. Book/55144BCSQLServer2014PerformanceTuningandOptimizationNewHighlight.pdf 268KB
  31. Book/Title.pdf 158KB
  32. Lab Files/6 Indexes/PERFMON Indexes/STUDENTSERVER_20150613-000001/DataCollector01.blg 128KB
  33. Lab Files/8 In-Memory OLTP/OLTP Sample Script/SQL Server 2014 RTM In-Memory OLTP Sample/SQL Server 2014 RTM In-Memory OLTP Sample.sql 69KB
  34. Lab Files/5 Query Optimization/Test.htm 18KB
  35. Lab Files/8 In-Memory OLTP/OLTP Sample Script/SQL Server 2014 RTM In-Memory OLTP Sample.zip 12KB
  36. Lab Files/9 Trace and Profiler/Deadlocks/MyDeadlockRon.xdl 3KB
  37. Lab Files/9 Trace and Profiler/Deadlocks/MyDeadlock.xdl 3KB
  38. Lab Files/9 Trace and Profiler/Tune.trc 3KB
  39. Lab Files/8 In-Memory OLTP/Comparing speed of memory optimized tables and Stored Procs.sql 3KB
  40. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics combined.sql 3KB
  41. Lab Files/3 Database Engine/Vertical Partitioning a Table.sql 3KB
  42. Lab Files/3 Database Engine/Horizonally Partitioning a Table.sql 3KB
  43. Lab Files/3 Database Engine/Horizonally Partitioning a table with filegroups.sql 2KB
  44. Lab Files/3 Database Engine/Transactions.sql 2KB
  45. Lab Files/7 Statistics/Creat a Database for Incremental Statistics.sql 2KB
  46. Lab Files/7 Statistics/New Cardinality estimator with ugly SQL.sql 2KB
  47. Lab Files/9 Trace and Profiler/Fast Query.sql 2KB
  48. Lab Files/7 Statistics/Old Cardinality estimator with ugly SQL.sql 2KB
  49. Lab Files/3 Database Engine/Set up partition wizard.sql 2KB
  50. Lab Files/7 Statistics/Ascending SQL 2012.sql 1KB
  51. Lab Files/2 SQL Architecture/Startup Stored Procedure Example.sql 1KB
  52. Lab Files/7 Statistics/Ascending SQL 2014.sql 1KB
  53. Lab Files/10 Hints etc/FORCE ORDER hint applied.sql 1KB
  54. Lab Files/6 Indexes/Index_Usage_Stats.sql 1KB
  55. Lab Files/10 Hints etc/FORCE ORDER.sql 1KB
  56. Lab Files/6 Indexes/Create indexes.sql 1KB
  57. Lab Files/3 Database Engine/Table Value Parameters.sql 1KB
  58. Lab Files/7 Statistics/Partitioned Index.sql 1KB
  59. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 1.sql 1KB
  60. Lab Files/7 Statistics/Filtered Statistics.sql 1KB
  61. Lab Files/6 Indexes/Missing Index DMO join.sql 1KB
  62. Lab Files/7 Statistics/Histogram.sql 1KB
  63. Lab Files/5 Query Optimization/View information about extended events.sql 1KB
  64. Lab Files/8 In-Memory OLTP/Simulate a workload.sql 993B
  65. Lab Files/9 Trace and Profiler/Default Trace Information.sql 948B
  66. Lab Files/5 Query Optimization/exec_query_stats.sql 935B
  67. Lab Files/7 Statistics/Computed Columns.sql 931B
  68. Lab Files/6 Indexes/Compression Demonstration.sql 871B
  69. Lab Files/4 Performance Tools/sp_who2.sql 826B
  70. Lab Files/8 In-Memory OLTP/Create a memory optimized table.sql 737B
  71. Lab Files/8 In-Memory OLTP/Bucket Monitoring.sql 724B
  72. Lab Files/10 Hints etc/Hint Examples/HASH ORDER/MERGE HASH CONCANT.sql 683B
  73. Lab Files/5 Query Optimization/Clear cach and run DMVs.sql 672B
  74. Lab Files/8 In-Memory OLTP/DMVs for In-Memory.sql 654B
  75. Lab Files/5 Query Optimization/dm_exec_requests.sql 643B
  76. Lab Files/10 Hints etc/Freeze/3 Create a plan guide for the query by specifying the query plan in the plan cache.sql 634B
  77. Lab Files/7 Statistics/Statistics Object.sql 621B
  78. Lab Files/6 Indexes/Index Metadata.sql 620B
  79. Lab Files/8 In-Memory OLTP/Currently Active or blocked.sql 612B
  80. Lab Files/2 SQL Architecture/Create test for zeroing with IFI.sql 601B
  81. Lab Files/10 Hints etc/Plans/Execution benefit from Recompile.sql 599B
  82. Lab Files/6 Indexes/Prep code for missing indexes.sql 598B
  83. Lab Files/6 Indexes/DTA Index code.sql 578B
  84. Lab Files/6 Indexes/Indexed Views.sql 570B
  85. Lab Files/5 Query Optimization/Data Access Operators.sql 551B
  86. Lab Files/9 Trace and Profiler/Create Stored Proc Get Sales Order By Country.sql 550B
  87. m55144.txt 550B
  88. Lab Files/9 Trace and Profiler/List events.sql 529B
  89. Lab Files/9 Trace and Profiler/Deadlocks/Create Tables.sql 516B
  90. Lab Files/5 Query Optimization/StatisticsTime.sql 513B
  91. Lab Files/10 Hints etc/Recompile applied.sql 512B
  92. Lab Files/6 Indexes/PageSplits/04 ObserverQtyFragmentation.sql 501B
  93. Lab Files/10 Hints etc/Create Plan.sql 487B
  94. Lab Files/10 Hints etc/Optimize FOR.sql 486B
  95. Lab Files/4 Performance Tools/Worse 10.sql 473B
  96. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 4.sql 465B
  97. Lab Files/10 Hints etc/Recompile.sql 463B
  98. Lab Files/5 Query Optimization/Generate a Execution Plan non-trivial.sql 449B
  99. Lab Files/4 Performance Tools/Slow Query.sql 447B
  100. Lab Files/5 Query Optimization/Slow Query.sql 447B
  101. Lab Files/9 Trace and Profiler/Create SlowStoredProcedure.sql 418B
  102. Lab Files/9 Trace and Profiler/Create SlowStoredProceddure.sql 418B
  103. Lab Files/5 Query Optimization/Turn On and Off XML Plans.sql 410B
  104. Lab Files/9 Trace and Profiler/Slow Query.sql 398B
  105. Lab Files/5 Query Optimization/Event Wizard Query.sql 395B
  106. Lab Files/6 Indexes/PageSplits/05 Create NoSplitPage Table.sql 385B
  107. Lab Files/10 Hints etc/Plans/Extracted.sql 374B
  108. Lab Files/10 Hints etc/Extracted.sql 374B
  109. Lab Files/3 Database Engine/Table Variables.sql 373B
  110. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 3.sql 371B
  111. Lab Files/10 Hints etc/Create Plan using Profiler.sql 370B
  112. Lab Files/10 Hints etc/Create SP GetSalesOrderByCountry.sql 364B
  113. Lab Files/8 In-Memory OLTP/Create a database with memory optimized filegroup.sql 363B
  114. Lab Files/9 Trace and Profiler/BlockedProcess/Enable blocked process.sql 354B
  115. Lab Files/10 Hints etc/Freeze/2 Inspect the query plan by using dynamic management views.sql 338B
  116. Lab Files/6 Indexes/PageSplits/01 Create PageSplit Table.sql 333B
  117. Lab Files/8 In-Memory OLTP/Wait statistics.sql 318B
  118. Lab Files/6 Indexes/PageSplits/08 Compare Logical Reads (IO).sql 313B
  119. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 5.sql 309B
  120. Lab Files/9 Trace and Profiler/Deadlocks/Session1.sql 307B
  121. Lab Files/7 Statistics/Enable XPs.sql 306B
  122. Lab Files/6 Indexes/PageSplits/10 See effect of REBUILD INDEX on PageSplit.sql 286B
  123. Lab Files/8 In-Memory OLTP/View Hash Index.sql 283B
  124. Lab Files/10 Hints etc/Plans/SQL Plan code.sql 270B
  125. Lab Files/9 Trace and Profiler/Deadlocks/Session2.sql 269B
  126. Lab Files/10 Hints etc/Hint Examples/HASH ORDER/Group By Suffix.sql 267B
  127. Lab Files/6 Indexes/PageSplits/06 InsertIntoNoPageSplit.sql 261B
  128. Lab Files/6 Indexes/PageSplits/02 InsertIntoPageSplit.sql 256B
  129. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 7.sql 243B
  130. Lab Files/10 Hints etc/Plans/Create Plan using Profiler.sql 233B
  131. Lab Files/10 Hints etc/Freeze/1 SQL Script to use for freeze cache.sql 231B
  132. Lab Files/10 Hints etc/Code for guide using profiler.sql 222B
  133. Lab Files/4 Performance Tools/DROP udf classifier.sql 220B
  134. Lab Files/6 Indexes/PageSplits/11 See Logical Reads after REBUIL on PageSplit.sql 197B
  135. Lab Files/4 Performance Tools/Block transaction 1.sql 190B
  136. Lab Files/10 Hints etc/Plans/SQl code to be used by Profiler.sql 186B
  137. Lab Files/10 Hints etc/FAST.sql 174B
  138. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 2.sql 168B
  139. Lab Files/7 Statistics/Incremental Statistics/Incremental Statistics Part 6.sql 156B
  140. Lab Files/10 Hints etc/Freeze/4 Verify that the plan guide is created..sql 151B
  141. Lab Files/9 Trace and Profiler/Deadlocks/Cleanup.sql 147B
  142. Lab Files/6 Indexes/PageSplits/07 See Logical Read on No Page Split.sql 145B
  143. Lab Files/6 Indexes/PageSplits/09 Alter Index on PageSplit REBUILD.sql 145B
  144. Lab Files/6 Indexes/PageSplits/03 See logical reads.sql 143B
  145. Lab Files/3 Database Engine/Query for registry Keys.sql 122B
  146. Lab Files/9 Trace and Profiler/BlockedProcess/Session1.sql 115B
  147. m55144 (4).asx 112B
  148. Lab Files/2 SQL Architecture/View Startup Stored Procedures.sql 112B
  149. Lab Files/4 Performance Tools/Block transaction 2.sql 109B
  150. Lab Files/6 Indexes/PageSplits/12 Cleanup.sql 93B
  151. Lab Files/9 Trace and Profiler/BlockedProcess/Session2.sql 91B
  152. Lab Files/4 Performance Tools/sys.dm_exec_sessions.sql 82B
  153. Lab Files/4 Performance Tools/Block transaction 3.sql 75B
  154. Lab Files/2 SQL Architecture/Compatability Level.sql 71B
  155. Lab Files/2 SQL Architecture/Path to SQL Exec.txt 70B
  156. Lab Files/5 Query Optimization/Estimated VS Actual Execution Plans.sql 65B
  157. Lab Files/10 Hints etc/Plans/Code for SQL plan hint .txt 55B
  158. Lab Files/9 Trace and Profiler/Create Database.sql 52B
  159. Lab Files/9 Trace and Profiler/Execute Slow Stored Proc.sql 37B