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.
Course info
Level
Intermediate
Updated
Jan 24, 2012
Duration
2h 14m
Table of contents
Introduction
Retrieving IDENTITY value using @@IDENTITY
Concepts Related to Identity Values
Difference between WHERE and HAVING
Order in WHERE clause
Concepts Around Temporary Tables and Table Variables
Are stored procedures pre-compiled?
UNIQUE INDEX and NULLs problem
DELETE VS TRUNCATE
Locks and Duration of Transactions
Nested Transaction and Rollback
Understanding Date/Time Datatypes
Differences between VARCHAR and NVARCHAR datatypes
Precedence of DENY and GRANT security permissions
Identify Blocking Process
NULLS usage with Dynamic SQL
Appendix Tips and Tricks with Tools
Description
Course info
Level
Intermediate
Updated
Jan 24, 2012
Duration
2h 14m
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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
Getting Started with MariaDB
Beginner
2h 23m
Nov 2, 2018
Monitoring MySQL with Performance Schema
Intermediate
1h 59m
Apr 28, 2017
More courses by Pinal Dave
About the author

Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences.

More from the author
SQL Server Performance: Indexing Basics
Intermediate
1h 59m
Mar 5, 2012