SQL Server Questions and Answers

Pluralsight
Course Summary
This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works.
-
+
Course Description
This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone working with SQL Server databases who wants to improve her knowledge and understanding of this complex platform.
-
+
Course Syllabus
Introduction- 0m 54s
—Introduction 0m 54sRetrieving IDENTITY value using @@IDENTITY- 8m 38s
—Misconception 0m 23s
—Resolution 0m 26s
—Demo 6m 9s
—Additional Info 1m 14s
—Summary 0m 26sConcepts Related to Identity Values- 4m 15sDifference between WHERE and HAVING- 5m 52sOrder in WHERE clause- 7m 29sConcepts Around Temporary Tables and Table Variables- 9m 3sAre stored procedures pre-compiled?- 5m 9sUNIQUE INDEX and NULLs problem- 6m 40sDELETE VS TRUNCATE- 6m 7sLocks and Duration of Transactions- 15m 11sNested Transaction and Rollback- 9m 16sUnderstanding Date/Time Datatypes- 7m 40sDifferences between VARCHAR and NVARCHAR datatypes- 6m 38sPrecedence of DENY and GRANT security permissions- 5m 29sIdentify Blocking Process- 6m 37sNULLS usage with Dynamic SQL- 8m 3sAppendix Tips and Tricks with Tools- 20m 44s