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.
exec_query_stats
You can also review the statistics collection at the query level by executing a query against the sys.dm_exec_query_stats DMV, which...
Statistics updates
Updating statistics is important. If the statistics are out of date, queries to a table would take longer time to execute. This is also a...
Collection of execution statistics for natively compiled stored procedures
Use the system stored procedures sys.sp_xtp_control_proc_exec_stats and sys.sp_xtp_control_query_exec_stats to enable or disable the...
estimated v.s. actual plan
An essential tool for designing indexes is the query plan. Use the graphical versions from the UI, or one of the SET SHOWPLAN commands to...
bottom of page
