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

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

Name	[Специалист] M55144B Настройка производительности и оптимизация SQL Server 2014	DOWNLOAD Copy Link
Total Size	11.3 GB
Total Files	159
Hash	FB98FDC7C4A98008D2DAB2F9BB90A6AD7C999A77

/.../9 Trace and Profiler/
Execute Slow Stored Proc.sql	0.0 KB
Create Database.sql	0.1 KB
Slow Query.sql	0.4 KB
Create SlowStoredProcedure.sql	0.4 KB
Create SlowStoredProceddure.sql	0.4 KB
List events.sql	0.5 KB
Create Stored Proc Get Sales Order By Country.sql	0.6 KB
Default Trace Information.sql	0.9 KB
Fast Query.sql	1.7 KB
Tune.trc	3.3 KB
Tuneing2.trc	859.2 KB
Tuning2_2.trc	3.6 MB
Tuning2.trc	5.2 MB
Tuning2_1.trc	5.2 MB
/.../10 Hints etc/Plans/
Code for SQL plan hint .txt	0.1 KB
SQl code to be used by Profiler.sql	0.2 KB
Create Plan using Profiler.sql	0.2 KB
SQL Plan code.sql	0.3 KB
Extracted.sql	0.4 KB
Execution benefit from Recompile.sql	0.6 KB
/Lab Files/5 Query Optimization/
Estimated VS Actual Execution Plans.sql	0.1 KB
Event Wizard Query.sql	0.4 KB
Turn On and Off XML Plans.sql	0.4 KB
Slow Query.sql	0.4 KB
Generate a Execution Plan non-trivial.sql	0.4 KB
StatisticsTime.sql	0.5 KB
Data Access Operators.sql	0.6 KB
dm_exec_requests.sql	0.6 KB
Clear cach and run DMVs.sql	0.7 KB
exec_query_stats.sql	0.9 KB
View information about extended events.sql	1.1 KB
Test.htm	18.7 KB
/Lab Files/2 SQL Architecture/
Path to SQL Exec.txt	0.1 KB
Compatability Level.sql	0.1 KB
View Startup Stored Procedures.sql	0.1 KB
Create test for zeroing with IFI.sql	0.6 KB
Startup Stored Procedure Example.sql	1.4 KB
/Lab Files/4 Performance Tools/
Block transaction 3.sql	0.1 KB
sys.dm_exec_sessions.sql	0.1 KB
Block transaction 2.sql	0.1 KB
Block transaction 1.sql	0.2 KB
DROP udf classifier.sql	0.2 KB
Slow Query.sql	0.4 KB
Worse 10.sql	0.5 KB
sp_who2.sql	0.8 KB
/.../9 Trace and Profiler/BlockedProcess/
Session2.sql	0.1 KB
Session1.sql	0.1 KB
Enable blocked process.sql	0.4 KB
/Lab Files/6 Indexes/PageSplits/
12 Cleanup.sql	0.1 KB
03 See logical reads.sql	0.1 KB
07 See Logical Read on No Page Split.sql	0.1 KB
09 Alter Index on PageSplit REBUILD.sql	0.1 KB
11 See Logical Reads after REBUIL on PageSplit.sql	0.2 KB
02 InsertIntoPageSplit.sql	0.3 KB
06 InsertIntoNoPageSplit.sql	0.3 KB
10 See effect of REBUILD INDEX on PageSplit.sql	0.3 KB
08 Compare Logical Reads (IO).sql	0.3 KB
01 Create PageSplit Table.sql	0.3 KB
05 Create NoSplitPage Table.sql	0.4 KB
04 ObserverQtyFragmentation.sql	0.5 KB
/
m55144 (4).asx	0.1 KB
m55144.txt	0.6 KB
m55144 1.mp4	563.2 MB
m55144 4.mp4	590.3 MB
m55144 2.mp4	691.5 MB
m55144 3.mp4	861.2 MB
/Lab Files/3 Database Engine/
Query for registry Keys.sql	0.1 KB
Table Variables.sql	0.4 KB
Table Value Parameters.sql	1.2 KB
Set up partition wizard.sql	1.6 KB
Transactions.sql	2.2 KB
Horizonally Partitioning a table with filegroups.sql	2.3 KB
Horizonally Partitioning a Table.sql	2.6 KB
Vertical Partitioning a Table.sql	2.6 KB
/.../9 Trace and Profiler/Deadlocks/
Cleanup.sql	0.1 KB
Session2.sql	0.3 KB
Session1.sql	0.3 KB
Create Tables.sql	0.5 KB
MyDeadlock.xdl	3.4 KB
MyDeadlockRon.xdl	3.4 KB
/.../10 Hints etc/Freeze/
4 Verify that the plan guide is created..sql	0.2 KB
1 SQL Script to use for freeze cache.sql	0.2 KB
2 Inspect the query plan by using dynamic management views.sql	0.3 KB
3 Create a plan guide for the query by specifying the query plan in the plan cache.sql	0.6 KB
/Lab Files/7 Statistics/Incremental Statistics/
Incremental Statistics Part 6.sql	0.2 KB
Incremental Statistics Part 2.sql	0.2 KB
Incremental Statistics Part 7.sql	0.2 KB
Incremental Statistics Part 5.sql	0.3 KB
Incremental Statistics Part 3.sql	0.4 KB
Incremental Statistics Part 4.sql	0.5 KB
Incremental Statistics Part 1.sql	1.1 KB
Incremental Statistics combined.sql	2.7 KB
/.../10 Hints etc/
FAST.sql	0.2 KB
Code for guide using profiler.sql	0.2 KB
Create SP GetSalesOrderByCountry.sql	0.4 KB
Create Plan using Profiler.sql	0.4 KB
Extracted.sql	0.4 KB
Recompile.sql	0.5 KB
Optimize FOR.sql	0.5 KB
Create Plan.sql	0.5 KB
Recompile applied.sql	0.5 KB
FORCE ORDER.sql	1.3 KB
FORCE ORDER hint applied.sql	1.3 KB
/.../10 Hints etc/Hint Examples/HASH ORDER/
Group By Suffix.sql	0.3 KB
MERGE HASH CONCANT.sql	0.7 KB
/.../8 In-Memory OLTP/
View Hash Index.sql	0.3 KB
Wait statistics.sql	0.3 KB
Create a database with memory optimized filegroup.sql	0.4 KB
Currently Active or blocked.sql	0.6 KB
DMVs for In-Memory.sql	0.7 KB
Bucket Monitoring.sql	0.7 KB
Create a memory optimized table.sql	0.7 KB
Simulate a workload.sql	1.0 KB
Comparing speed of memory optimized tables and Stored Procs.sql	2.9 KB
Test_IM_OLTP	514.8 MB
/Lab Files/7 Statistics/
Enable XPs.sql	0.3 KB
Statistics Object.sql	0.6 KB
Computed Columns.sql	0.9 KB
Histogram.sql	1.1 KB
Filtered Statistics.sql	1.1 KB
Partitioned Index.sql	1.2 KB
Ascending SQL 2014.sql	1.4 KB
Ascending SQL 2012.sql	1.4 KB
Old Cardinality estimator with ugly SQL.sql	1.7 KB
New Cardinality estimator with ugly SQL.sql	1.7 KB
Creat a Database for Incremental Statistics.sql	2.1 KB
/Lab Files/6 Indexes/
Indexed Views.sql	0.6 KB
DTA Index code.sql	0.6 KB
Prep code for missing indexes.sql	0.6 KB
Index Metadata.sql	0.6 KB
Compression Demonstration.sql	0.9 KB
Missing Index DMO join.sql	1.1 KB
Create indexes.sql	1.3 KB
Index_Usage_Stats.sql	1.3 KB
/.../OLTP Sample Script/
SQL Server 2014 RTM In-Memory OLTP Sample.zip	12.2 KB
/.../SQL Server 2014 RTM In-Memory OLTP Sample/
SQL Server 2014 RTM In-Memory OLTP Sample.sql	71.0 KB
/.../STUDENTSERVER_20150613-000001/
DataCollector01.blg	131.1 KB
/Book/
Title.pdf	161.9 KB
55144BCSQLServer2014PerformanceTuningandOptimizationNewHighlight.pdf	274.0 KB
4 SQL Performance Tools.pdf	4.2 MB
2 SQL 2014 Architecture.pdf	5.2 MB
9 SQL PROFILER AND SQL TRACE.pdf	5.4 MB
10 QUERY ISSUES AND HINTS.pdf	5.9 MB
6 Understanding Indexes.pdf	6.6 MB
8 IN-MEMORY DATABASES.pdf	7.4 MB
7 UNDERSTANDING STATISTICS.pdf	7.7 MB
3 The Database Engine.pdf	8.2 MB
5 Query Optimizing and Operators.pdf	11.1 MB
55144BCLabFiles.rar	29.3 MB
55144BCVideospart4.rar	105.2 MB
55144BCVideospart1.rar	115.3 MB
55144BCVideospart2.rar	115.3 MB
55144BCVideospart3.rar	115.3 MB
55144BCDataBasespart1.rar	115.3 MB
/.../DB backup for Statistics/
BUofPartionedDB.bak	10.6 MB
/Образ winserv2012r2/
55144BC.part04.rar	1.5 GB
55144BC.part01.rar	2.0 GB
55144BC.part02.rar	2.0 GB
55144BC.part03.rar	2.0 GB
Total files 159