Database Administrators
Meta user
Network profile
2,328
reputation
6
20

jyao

A senior SQL Server Consultant enjoys reading the concise and smart sql tips and loves R&D work in DBA Engineering topics. I enjoy database administration automation to save me time for life and more automation.

You can find me at

https://www.mssqltips.com/sqlserverauthor/121/jeffrey-yao/

or

https://www.sqlservercentral.com/author/jeffrey-yao

117
answers
9
questions
~98k
people reached

Communities (17)

Top network posts

Top tags (109)

Score 128
Posts 105
Posts % 83
Score 32
Posts 17
Score 21
Posts 12
Score 20
Posts 14
Score 14
Posts 7
Score 14
Posts 6
View all tags →

Top posts (126) All Questions Answers | Votes Newest

13 NULL value self comparison in a table Aug 26 '16
8 sys.objects column [Type] weird value 'ST' Nov 16 '17
8 WHERE vs. HAVING on non-aggregate columns. Advantages / Disadvantages / Irrelevant? Jan 24 '18
7 Enable TLS 1.2 for SQL Server 2016 database mail Jul 30 '18
6 Upgrade SQL Server 2016 R Service (in-database) Jan 24 '17
5 Is it possible to do this math in a view? Oct 6 '16
5 Quickest Method To Invalidate Statistics Dec 9 '16
5 Can bad table-scan queries slow down nice index-covered queries at the same instance? Jan 28 '18
4 MS SQL - Find Stored Procedure (Dynamic) Related to Table in Database Feb 9 '18
4 Enable TLS 1.2 for SQL Server 2016 database mail Aug 9 '18
View all questions and answers →

Badges (26)

Gold

—

Silver

6

Rarest

Bronze

20

Rarest

View all badges →