Database Administrators
Profile Activity
Meta user
Network profile
2,727
reputation
1
8
22

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

118
answers
9
questions
~170k
people reached

Communities (18)

Top network posts

Top tags (110)

Score 141
Posts 105
Posts % 83
Score 36
Posts 17
Score 23
Posts 13
Score 20
Posts 14
Score 16
Posts 7
Score 15
Posts 6
View all tags →

Top posts (127)

All Questions Answers
Votes Newest
13 NULL value self comparison in a table Aug 26 '16
10 sys.objects column [Type] weird value 'ST' Nov 16 '17
10 WHERE vs. HAVING on non-aggregate columns. Advantages / Disadvantages / Irrelevant? Jan 24 '18
9 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
6 Change Data Capture vs trigger for logging changes Dec 12 '16
5 Is it possible to do this math in a view? Oct 6 '16
5 Can bad table-scan queries slow down nice index-covered queries at the same instance? Jan 28 '18
5 Quickest Method To Invalidate Statistics Dec 9 '16
4 MS SQL - Find Stored Procedure (Dynamic) Related to Table in Database Feb 9 '18
View all questions and answers →

Badges (31)

Gold

1

Rarest

Silver

8

Rarest

Bronze

22

Rarest

View all badges →

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.