Database Administrators
jyao's user avatar
jyao's user avatar
jyao's user avatar
jyao
  • Member for 7 years, 5 months
  • Last seen more than a week ago
Profile Activity
Stats
2,915
reputation
246k
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
10
silver badges
26
bronze badges
Top tags
View all tags
145
Score
105
Posts
83
Posts %
37
Score
17
Posts
13
Posts %
24
Score
13
Posts
10
Posts %
20
Score
14
Posts
11
Posts %
16
Score
7
Posts
6
Posts %
16
Score
6
Posts
5
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
question
20
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
answer
11
WHERE vs. HAVING on non-aggregate columns. Advantages / Disadvantages / Irrelevant?
Jan 24, 2018
question
10
sys.objects column [Type] weird value 'ST'
Nov 16, 2017
question
7
Upgrade SQL Server 2016 R Service (in-database)
Jan 24, 2017
answer
6
Change Data Capture vs trigger for logging changes
Dec 12, 2016
answer
5
Is it possible to do this math in a view?
Oct 6, 2016
answer
5
How to schedule jobs in Sql server 2008 for less than 10 sec?
Dec 11, 2015
answer
5
Can bad table-scan queries slow down nice index-covered queries at the same instance?
Jan 28, 2018
answer
5
Quickest Method To Invalidate Statistics
Dec 9, 2016
Top network posts
View all network posts
15
How to use CSI.exe script argument
13
How to install/update a powershell module from a local folder - set up an internal module repository
12
Inserting datetime with milliseconds into SQL Server table issue
9
Change Passport Information about Citizenship and Issuing Country
7
Can we change PowerShell sessions's LanguageMode?

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.