Pluralsight SQL Server Questions and Answers
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.
| Introduction | 00:00:54 |
| Introduction | 00:54 |
| Retrieving IDENTITY value using @@IDENTITY | 00:08:38 |
| Misconception | 00:23 |
| Resolution | 00:26 |
| Demo | 06:09 |
| Additional Info | 01:14 |
| Summary | 00:26 |
| Concepts Related to Identity Values | 00:04:15 |
| Misconception | 00:32 |
| Resolution | 00:42 |
| Demo | 02:12 |
| Additional Info | 00:26 |
| Summary | 00:23 |
| Difference between WHERE and HAVING | 00:05:52 |
| Misconception | 00:28 |
| Resolution | 00:50 |
| Demo | 03:13 |
| Additional Info | 00:45 |
| Summary | 00:36 |
| Order in WHERE clause | 00:07:29 |
| Misconception | 00:32 |
| Resolution | 00:34 |
| Demo | 05:11 |
| Additional Info | 00:37 |
| Summary | 00:35 |
| Concepts Around Temporary Tables and Table Variables | 00:09:03 |
| Misconception | 00:44 |
| Resolution | 00:37 |
| Demo: Table variables exists in Memory misconception | 02:11 |
| Demo: Temp tables exist in Physical drive myth | 01:14 |
| Demo: Shows Table variables can have Index | 01:27 |
| Demo: Scope of transaction with table and temp tables | 01:49 |
| Additional Info | 00:30 |
| Summary | 00:31 |
| Are stored procedures pre-compiled? | 00:05:09 |
| Misconception | 00:27 |
| Resolution | 00:48 |
| Demo | 02:43 |
| Additional Info | 00:45 |
| Summary | 00:26 |
| UNIQUE INDEX and NULLs problem | 00:06:40 |
| Misconception | 00:46 |
| Resolution | 00:37 |
| Demo | 03:52 |
| Additional Info | 01:03 |
| Summary | 00:22 |
| DELETE VS TRUNCATE | 00:06:07 |
| Misconception | 00:22 |
| Resolution | 00:37 |
| Demo | 03:42 |
| Additional Info | 00:57 |
| Summary | 00:29 |
| Locks and Duration of Transactions | 00:15:11 |
| Misconception | 00:31 |
| Resolution | 00:41 |
| Demo | 12:38 |
| Additional Info | 01:01 |
| Summary | 00:20 |
| Nested Transaction and Rollback | 00:09:16 |
| Misconception | 00:30 |
| Resolution | 00:32 |
| Demo: Nested Transaction - 1 | 02:13 |
| Demo: Nested Transaction - 2 | 02:09 |
| Demo: Nested Transaction - 3 | 03:17 |
| Summary | 00:35 |
| Understanding Date/Time Datatypes | 00:07:40 |
| Misconception | 00:37 |
| Resolution | 00:40 |
| Demo | 05:18 |
| Additional Info | 00:34 |
| Summary | 00:31 |
| Differences between VARCHAR and NVARCHAR datatypes | 00:06:38 |
| Misconception | 00:33 |
| Resolution | 00:28 |
| Demo | 04:39 |
| Additional Info | 00:31 |
| Summary | 00:27 |
| Precedence of DENY and GRANT security permissions | 00:05:29 |
| Misconception | 00:23 |
| Resolution | 00:27 |
| Demo | 03:39 |
| Additional Info | 00:41 |
| Summary | 00:19 |
| Identify Blocking Process | 00:06:37 |
| Misconception | 00:30 |
| Resolution | 00:48 |
| Demo | 03:36 |
| Additional Info | 01:07 |
| Summary | 00:36 |
| NULLS usage with Dynamic SQL | 00:08:03 |
| Misconception | 00:32 |
| Resolution | 00:42 |
| Demo | 05:25 |
| Additional Info | 00:53 |
| Summary | 00:31 |
| Appendix Tips and Tricks with Tools | 00:20:44 |
| Using the ssms command-line tool | 05:01 |
| Using Activity Monitor | 04:59 |
| Using filtering in query results | 04:27 |
| Configuration options in SSMS | 06:17 |