top of page
This site was designed with the
.com
website builder. Create your website today.
Start Now
John's data story
More
Use tab to navigate through the menu items.
Topic
All Posts
(108)
108 posts
No categories yet.
SQL
(84)
84 posts
No categories yet.
Visualization
(5)
5 posts
No categories yet.
Data
(1)
1 post
No categories yet.
Python
(17)
17 posts
No categories yet.
Recent Posts
Bitwise operators
In honor of Lothar Collatz
sqrt() and int()
For loops
String Methods
break and continue
sleep()
Assignment Operators
while i and for i in range ()
Multi-line printing
Compact while()
int()
float() and round()
if-elif-else instructions
Time evaluation
end=, sep=, +, *, and /
Assignment (Shortcut) operators
Binary <==> Decimal Conversion
Data scientists vs analysts
Performance, error and warning events
Inner Join (vs Inline TVF)
Query performance
exec_query_stats
REORGANIZE vs REBUILD
Data Collector vs Activity Monitor
Database recovery
Version Store
Activity Monitor
Data change recording
Indexed v.s. Partitioned Views
Database Snapshot
Baseline performance
Common Table Expressions (CTEs)
#temp table v.s. @table
The backstage architecture
With Check Option
SQL Server Profiler
Memory-Optimized Tables -- Non-durable v.s. variable
Azure Portal
Service Editions and Tiers
Extreme Transaction Processing (XTP)
Lock Events Category
GRANT Object Permissions
Identify missing indexes
Query Store properties
SQL Syntax
Resource Pool
Stored procedure with OUTPUT and READONLY
Statistics updates
Extended Event
Archive
June 2020
(18)
18 posts
May 2020
(9)
9 posts
April 2020
(22)
22 posts
March 2020
(31)
31 posts
February 2020
(23)
23 posts
November 2016
(2)
2 posts
October 2016
(3)
3 posts
Tags
No tags yet.
Inner Join (vs Inline TVF)
Let’s consider a query that combines data from multiple tables to produce the query plan. The Hash Match (Inner Join) operator combines...
Indexed v.s. Partitioned Views
Indexed View Creating a unique clustered index on a view improves query performance because the view is stored in the database in the...
With Check Option
When using a view as an interface like we are doing in this section, one of the things that you generally don’t want to occur is to have...
Indexed views
An indexed view (sometimes referred to as a materialized view), is a view that has been made into more than just a simple stored query by...
bottom of page
