Filename Size 534417_00_01 - Welcome.en.srt 1.6 KB 534417_00_02 - Using the exercise files.en.srt 1.7 KB 534417_00_03 - What you should know.en.srt 1.4 KB 534417_00_04 - Install the sample database.en.srt 7.7 KB 534417_01_01 - Table design in SQL Server.en.srt 10.8 KB 534417_01_02 - Data types.en.srt 7.4 KB 534417_01_03 - Create and alter tables.en.srt 17.6 KB 534417_01_04 - Implement table schemas.en.srt 14.7 KB 534417_01_05 - Calculate table columns.en.srt 14.7 KB 534417_02_01 - Partition large data tables.en.srt 19.6 KB 534417_02_02 - Create temporary tables.en.srt 10.6 KB 534417_02_03 - Use table variables.en.srt 10.2 KB 534417_02_04 - Understand column collation.en.srt 16.6 KB 534417_02_05 - Data compression fundamentals.en.srt 8.7 KB 534417_02_06 - Compress data tables.en.srt 8.4 KB 534417_02_07 - Go back in time with temporal tables.en.srt 11.2 KB 534417_03_01 - What are views_.en.srt 5.2 KB 534417_03_02 - Create a view of the data.en.srt 17.8 KB 534417_03_03 - Enhance view performance.en.srt 11.7 KB 534417_04_01 - Understand data integrity.en.srt 4.4 KB 534417_04_02 - Implement domain integrity.en.srt 6.2 KB 534417_04_03 - Enforce referential integrity.en.srt 5.5 KB 534417_04_04 - Use DML triggers to verify data.en.srt 11.3 KB 534417_05_01 - Define user roles and permissions.en.srt 8.9 KB 534417_05_02 - Add a user to a role with T-SQL.en.srt 10.9 KB 534417_05_03 - Create loginless and contained users.en.srt 13 KB 534417_05_04 - Implement schema security.en.srt 9.3 KB 534417_06_01 - Store spatial data.en.srt 14.4 KB 534417_06_02 - Add GUID data to a table.en.srt 9.1 KB 534417_06_03 - Implement the XML data type.en.srt 10.6 KB 534417_06_04 - Store BLOB data in a table.en.srt 7.1 KB 534417_06_05 - Implement FILESTREAM access.en.srt 14.7 KB 534417_06_06 - Implicit and explicit data conversions.en.srt 14.1 KB 534417_07_01 - Introduction to stored procedures.en.srt 7.5 KB 534417_07_02 - Write a stored procedure with T-SQL.en.srt 10.7 KB 534417_07_03 - Add parameters to a stored procedure.en.srt 10.6 KB 534417_07_04 - Recompile a stored procedure.en.srt 4.6 KB 534417_08_01 - Why use in-memory tables_.en.srt 4.3 KB 534417_08_02 - Create a memory-optimized table.en.srt 13.3 KB 534417_08_03 - Write a native compiled stored procedure.en.srt 11.8 KB 534417_09_01 - Table index fundamentals.en.srt 6.8 KB 534417_09_02 - Clustered indexes.en.srt 5 KB 534417_09_03 - Non-clustered indexes.en.srt 5.1 KB 534417_09_04 - Single column and composite indexes.en.srt 12.2 KB 534417_09_05 - Design spatial and XML indexes.en.srt 5.8 KB 534417_10_01 - Improve queries with covering indexes.en.srt 10.8 KB 534417_10_02 - Obtain index statistics.en.srt 8.8 KB 534417_10_03 - Filtered indexes.en.srt 7.9 KB 534417_10_04 - Create columnstore indexes.en.srt 4.6 KB 534417_11_01 - Introduction to sparse columns.en.srt 4.3 KB 534417_11_02 - Implement sparse columns.en.srt 7.3 KB 534417_12_01 - Defragment indexes.en.srt 9.2 KB 534417_12_02 - Analyze execution plans and tune queries.en.srt 9.8 KB 534417_12_03 - Leverage the SQL Tuning Advisor.en.srt 8.2 KB 534417_13_01 - SQL Server function overview.en.srt 3.8 KB 534417_13_02 - Return values with scalar functions.en.srt 13 KB 534417_14_01 - Use Dynamic Management Views.en.srt 3.6 KB 534417_14_02 - Record extended event sessions.en.srt 12.9 KB 534417_14_03 - Find bottlenecks with Activity Monitor.en.srt 5.5 KB 534417_15_01 - Next steps.en.srt 1.7 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_03_CreateAlter.sql 1.9 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_04_Schemas.sql 1.2 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_05_CalculateColumns.sql 1.8 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_01_PartitionTables.sql 1.1 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_02_TemporaryTables.sql 879 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_03_TableVariables.sql 1.3 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_04_Collation.sql 1.5 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_06_CompressTables.sql 1 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_07_TemporalTables.sql 1.5 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 03/03_02_CreateView.sql 3.2 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 03/03_03_ViewPerformance.sql 2.9 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 04/04_04_DMLTrigger.sql 1.8 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_02_AddUser.sql 1.3 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_03_LoginlessUser.sql 1.4 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_04_SchemaSecurity.sql 983 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_01_Spatial.sql 3.6 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_02_GUID.sql 1.2 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_03_XML.sql 1.7 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_04_BLOB.sql 825 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_05_Filestream.sql 1.7 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_06_DataConversions.sql 1.5 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/CompanyHistory.pdf 618.3 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/CompanyLogo.jpg 15.1 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 07/07_02_StoredProcedureTSQL.sql 1.5 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 07/07_03_Parameters.sql 1.8 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 08/08_02_CreateMemoryOptimized.sql 1.4 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 08/08_03_CompiledStoredProcedure.sql 1.5 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 09/09_04_CompositeIndexes.sql 842 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_01_CoveringIndex.sql 754 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_02_IndexStats.sql 264 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_03_FilteredIndexes.sql 1.2 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 11/11_02_ImplementSparseColumns.sql 1.3 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_01_DefragIndexes.sql 867 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_02_ExecutionPlans.sql 801 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_03_TuningAdvisor.sql 807 B Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 13/13_02_ScalarFunctions.sql 1.3 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 13/13_03_TableValuedFunction.sql 1 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 14/14_02_EventSessions.sql 2 KB Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 14/14_03_ActivityMonitor.sql 550 B