Developing Microsoft SQL Server 2016 Databases | 66A0437E0911B89CBAAAADC4352796FDCA85D979

Developing Microsoft SQL Server 2016 Databases

Name	Developing Microsoft SQL Server 2016 Databases	DOWNLOAD Copy Link
Total Size	569.7 MB
Total Files	160
Hash	66A0437E0911B89CBAAAADC4352796FDCA85D979

/Exercise Files/Chapter 10/
10_02_IndexStats.sql	0.3 KB
10_01_CoveringIndex.sql	0.8 KB
10_03_FilteredIndexes.sql	1.2 KB
/Exercise Files/Chapter 14/
14_03_ActivityMonitor.sql	0.6 KB
14_02_EventSessions.sql	2.0 KB
/Exercise Files/Chapter 12/
12_02_ExecutionPlans.sql	0.8 KB
12_03_TuningAdvisor.sql	0.8 KB
12_01_DefragIndexes.sql	0.9 KB
/Exercise Files/Chapter 06/
06_04_BLOB.sql	0.8 KB
06_02_GUID.sql	1.3 KB
06_06_DataConversions.sql	1.5 KB
06_05_Filestream.sql	1.7 KB
06_03_XML.sql	1.7 KB
06_01_Spatial.sql	3.6 KB
CompanyLogo.jpg	15.5 KB
CompanyHistory.pdf	633.1 KB
/Exercise Files/Chapter 09/
09_04_CompositeIndexes.sql	0.8 KB
/Exercise Files/Chapter 02/
02_02_TemporaryTables.sql	0.9 KB
02_06_CompressTables.sql	1.1 KB
02_01_PartitionTables.sql	1.2 KB
02_03_TableVariables.sql	1.4 KB
02_07_TemporalTables.sql	1.5 KB
02_04_Collation.sql	1.6 KB
/Exercise Files/Chapter 05/
05_04_SchemaSecurity.sql	1.0 KB
05_02_AddUser.sql	1.3 KB
05_03_LoginlessUser.sql	1.5 KB
/Exercise Files/Chapter 13/
13_03_TableValuedFunction.sql	1.0 KB
13_02_ScalarFunctions.sql	1.4 KB
/Exercise Files/Chapter 01/
01_04_Schemas.sql	1.3 KB
01_05_CalculateColumns.sql	1.8 KB
01_03_CreateAlter.sql	2.0 KB
/Exercise Files/Chapter 11/
11_02_ImplementSparseColumns.sql	1.4 KB
/Exercise Files/Chapter 08/
08_02_CreateMemoryOptimized.sql	1.4 KB
08_03_CompiledStoredProcedure.sql	1.5 KB
/
534417_00_03 - What you should know.en.srt	1.4 KB
534417_00_01 - Welcome.en.srt	1.6 KB
534417_00_02 - Using the exercise files.en.srt	1.7 KB
534417_15_01 - Next steps.en.srt	1.8 KB
534417_14_01 - Use Dynamic Management Views.en.srt	3.7 KB
534417_13_01 - SQL Server function overview.en.srt	3.9 KB
534417_11_01 - Introduction to sparse columns.en.srt	4.4 KB
534417_08_01 - Why use in-memory tables_.en.srt	4.4 KB
534417_04_01 - Understand data integrity.en.srt	4.5 KB
534417_10_04 - Create columnstore indexes.en.srt	4.7 KB
534417_07_04 - Recompile a stored procedure.en.srt	4.7 KB
534417_09_02 - Clustered indexes.en.srt	5.1 KB
534417_09_03 - Non-clustered indexes.en.srt	5.3 KB
534417_03_01 - What are views_.en.srt	5.3 KB
534417_14_03 - Find bottlenecks with Activity Monitor.en.srt	5.6 KB
534417_04_03 - Enforce referential integrity.en.srt	5.6 KB
534417_09_05 - Design spatial and XML indexes.en.srt	6.0 KB
534417_04_02 - Implement domain integrity.en.srt	6.3 KB
534417_09_01 - Table index fundamentals.en.srt	6.9 KB
534417_06_04 - Store BLOB data in a table.en.srt	7.3 KB
534417_11_02 - Implement sparse columns.en.srt	7.5 KB
534417_01_02 - Data types.en.srt	7.6 KB
534417_07_01 - Introduction to stored procedures.en.srt	7.7 KB
534417_00_04 - Install the sample database.en.srt	7.9 KB
534417_10_03 - Filtered indexes.en.srt	8.1 KB
534417_12_03 - Leverage the SQL Tuning Advisor.en.srt	8.4 KB
534417_02_06 - Compress data tables.en.srt	8.6 KB
534417_02_05 - Data compression fundamentals.en.srt	9.0 KB
534417_10_02 - Obtain index statistics.en.srt	9.0 KB
534417_05_01 - Define user roles and permissions.en.srt	9.1 KB
534417_06_02 - Add GUID data to a table.en.srt	9.3 KB
534417_12_01 - Defragment indexes.en.srt	9.4 KB
534417_05_04 - Implement schema security.en.srt	9.5 KB
534417_12_02 - Analyze execution plans and tune queries.en.srt	10.0 KB
534417_02_03 - Use table variables.en.srt	10.5 KB
534417_02_02 - Create temporary tables.en.srt	10.9 KB
534417_06_03 - Implement the XML data type.en.srt	10.9 KB
534417_07_03 - Add parameters to a stored procedure.en.srt	10.9 KB
534417_07_02 - Write a stored procedure with T-SQL.en.srt	11.0 KB
534417_01_01 - Table design in SQL Server.en.srt	11.1 KB
534417_10_01 - Improve queries with covering indexes.en.srt	11.1 KB
534417_05_02 - Add a user to a role with T-SQL.en.srt	11.1 KB
534417_02_07 - Go back in time with temporal tables.en.srt	11.5 KB
534417_04_04 - Use DML triggers to verify data.en.srt	11.6 KB
534417_03_03 - Enhance view performance.en.srt	11.9 KB
534417_08_03 - Write a native compiled stored procedure.en.srt	12.1 KB
534417_09_04 - Single column and composite indexes.en.srt	12.5 KB
534417_14_02 - Record extended event sessions.en.srt	13.2 KB
534417_05_03 - Create loginless and contained users.en.srt	13.3 KB
534417_13_02 - Return values with scalar functions.en.srt	13.3 KB
534417_08_02 - Create a memory-optimized table.en.srt	13.7 KB
534417_06_06 - Implicit and explicit data conversions.en.srt	14.4 KB
534417_06_01 - Store spatial data.en.srt	14.7 KB
534417_01_04 - Implement table schemas.en.srt	15.0 KB
534417_01_05 - Calculate table columns.en.srt	15.0 KB
534417_06_05 - Implement FILESTREAM access.en.srt	15.1 KB
534417_02_04 - Understand column collation.en.srt	17.0 KB
534417_01_03 - Create and alter tables.en.srt	18.0 KB
534417_03_02 - Create a view of the data.en.srt	18.2 KB
534417_02_01 - Partition large data tables.en.srt	20.1 KB
534417_00_03 - What you should know.mp4	853.6 KB
534417_00_02 - Using the exercise files.mp4	1.3 MB
534417_15_01 - Next steps.mp4	2.0 MB
534417_13_01 - SQL Server function overview.mp4	2.4 MB
534417_08_01 - Why use in-memory tables_.mp4	3.2 MB
534417_04_01 - Understand data integrity.mp4	3.2 MB
534417_10_04 - Create columnstore indexes.mp4	3.3 MB
534417_11_01 - Introduction to sparse columns.mp4	3.3 MB
534417_09_03 - Non-clustered indexes.mp4	3.3 MB
534417_03_01 - What are views_.mp4	3.5 MB
534417_07_04 - Recompile a stored procedure.mp4	3.6 MB
534417_09_02 - Clustered indexes.mp4	3.6 MB
534417_04_03 - Enforce referential integrity.mp4	3.7 MB
534417_14_01 - Use Dynamic Management Views.mp4	4.1 MB
534417_09_05 - Design spatial and XML indexes.mp4	4.3 MB
534417_09_01 - Table index fundamentals.mp4	4.4 MB
534417_04_02 - Implement domain integrity.mp4	4.6 MB
534417_07_01 - Introduction to stored procedures.mp4	4.7 MB
534417_01_02 - Data types.mp4	4.9 MB
534417_14_03 - Find bottlenecks with Activity Monitor.mp4	5.5 MB
534417_05_01 - Define user roles and permissions.mp4	6.1 MB
534417_02_05 - Data compression fundamentals.mp4	6.4 MB
534417_00_01 - Welcome.mp4	6.6 MB
534417_06_04 - Store BLOB data in a table.mp4	7.2 MB
534417_13_03 - Create a table-valued function.mp4	7.4 MB
534417_01_01 - Table design in SQL Server.mp4	7.5 MB
534417_11_02 - Implement sparse columns.mp4	7.7 MB
534417_12_03 - Leverage the SQL Tuning Advisor.mp4	7.8 MB
534417_00_04 - Install the sample database.mp4	8.3 MB
534417_06_02 - Add GUID data to a table.mp4	9.1 MB
534417_10_03 - Filtered indexes.mp4	9.2 MB
534417_05_04 - Implement schema security.mp4	10.6 MB
534417_02_03 - Use table variables.mp4	10.7 MB
534417_10_02 - Obtain index statistics.mp4	11.0 MB
534417_02_02 - Create temporary tables.mp4	11.0 MB
534417_02_07 - Go back in time with temporal tables.mp4	11.3 MB
534417_04_04 - Use DML triggers to verify data.mp4	11.4 MB
534417_12_02 - Analyze execution plans and tune queries.mp4	11.6 MB
534417_07_03 - Add parameters to a stored procedure.mp4	11.6 MB
534417_05_02 - Add a user to a role with T-SQL.mp4	12.3 MB
534417_12_01 - Defragment indexes.mp4	12.3 MB
534417_02_06 - Compress data tables.mp4	12.4 MB
534417_08_03 - Write a native compiled stored procedure.mp4	12.5 MB
534417_06_01 - Store spatial data.mp4	12.6 MB
534417_05_03 - Create loginless and contained users.mp4	12.8 MB
534417_06_03 - Implement the XML data type.mp4	12.9 MB
534417_14_02 - Record extended event sessions.mp4	13.7 MB
534417_08_02 - Create a memory-optimized table.mp4	14.3 MB
534417_13_02 - Return values with scalar functions.mp4	14.3 MB
534417_10_01 - Improve queries with covering indexes.mp4	14.6 MB
534417_06_06 - Implicit and explicit data conversions.mp4	14.7 MB
534417_01_04 - Implement table schemas.mp4	15.0 MB
534417_01_05 - Calculate table columns.mp4	15.0 MB
534417_07_02 - Write a stored procedure with T-SQL.mp4	15.2 MB
534417_02_04 - Understand column collation.mp4	15.3 MB
534417_06_05 - Implement FILESTREAM access.mp4	15.4 MB
534417_03_03 - Enhance view performance.mp4	15.8 MB
534417_01_03 - Create and alter tables.mp4	16.3 MB
534417_09_04 - Single column and composite indexes.mp4	16.6 MB
534417_02_01 - Partition large data tables.mp4	20.3 MB
534417_03_02 - Create a view of the data.mp4	21.7 MB
/Exercise Files/Chapter 07/
07_02_StoredProcedureTSQL.sql	1.5 KB
07_03_Parameters.sql	1.9 KB
/Exercise Files/Chapter 04/
04_04_DMLTrigger.sql	1.9 KB
/Exercise Files/Chapter 03/
03_03_ViewPerformance.sql	3.0 KB
03_02_CreateView.sql	3.3 KB
Total files 160