Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators
Meta user
Network profile
2,309
reputation
5
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

http://www.sqlservercentral.com/blogs/jeffrey_yao/

116
answers
8
questions
~86k
people reached

Communities (17)

Top network posts

Top tags (108)

Score 125
Posts 103
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 (124) All Questions Answers | Votes Newest

13 NULL value self comparison in a table Aug 26 '16
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
7 sys.objects column [Type] weird value 'ST' Nov 16 '17
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 (25)

Gold

—

Silver

5

Rarest

Bronze

20

Rarest

View all badges →