Database Administrators
jyao's user avatar
jyao's user avatar
jyao's user avatar
jyao
  • Member for 8 years, 7 months
  • Last seen this week
Profile Activity
Stats
3,023
reputation
310k
reached
118
answers
9
questions
Communities
View all
About

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

Badges
View all badges
1
gold badge
11
silver badges
26
bronze badges
Top tags
View all tags
149
Score
105
Posts
83
Posts %
40
Score
17
Posts
13
Posts %
27
Score
13
Posts
10
Posts %
20
Score
14
Posts
11
Posts %
19
Score
7
Posts
6
Posts %
16
Score
6
Posts
5
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
question
23
Enable TLS 1.2 for SQL Server 2016 database mail
Jul 30, 2018
question
13
NULL value self comparison in a table
Aug 26, 2016
question
11
sys.objects column [Type] weird value 'ST'
Nov 16, 2017
answer
11
WHERE vs. HAVING on non-aggregate columns. Advantages / Disadvantages / Irrelevant?
Jan 24, 2018
answer
9
Change Data Capture vs trigger for logging changes
Dec 12, 2016
question
7
Upgrade SQL Server 2016 R Service (in-database)
Jan 24, 2017
answer
5
Is it possible to do this math in a view?
Oct 6, 2016
answer
5
Quickest Method To Invalidate Statistics
Dec 9, 2016
answer
5
Can bad table-scan queries slow down nice index-covered queries at the same instance?
Jan 28, 2018
answer
5
Enable TLS 1.2 for SQL Server 2016 database mail
Aug 9, 2018
Top network posts
View all network posts
17
How to install/update a powershell module from a local folder - set up an internal module repository
15
How to use CSI.exe script argument
14
Inserting datetime with milliseconds into SQL Server table issue
10
Change Passport Information about Citizenship and Issuing Country
9
Change Passport Information about Citizenship and Issuing Country

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.