February 2020
Intermediate to advanced
410 pages
9h 37m
English
book
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
by Elizabeth Noble
Content preview from Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server DevelopersBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Index
A
Adaptive joins
Automatic database tuning
index management
plan correction
query store
B
Binary strings
Buffer pool
C
Clustered Index Scans
Clustered Index Seek
Coding standards
database design
ANSI standard
constraint
foreign keys
non-clustered indexes
normal forms
primary keys
table size
value pair, name
performance
implicit conversion
NOLOCK
NULL values
RECOMPILE
sargeable
select data
SET NOCOUNT ON
usability
BETWEEN
CASE statement
CAST
columns
cursors
linked servers
ORDER BY statement
stored procedure parameters
TRY… CATCH
UNION statement
Commenting
header
non-standard practices
queries
stored procedure
view
Common table expressions (CTE)
creation
execution plan
query
recursive CTE
Complex logic
comments
Dynamic Cursor, creation
header information
output, cursor
parameters
query, avoid cursor ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.