233 reputation
28
bio website thingsthatgobleep.com
location New Zealand
age 31
visits member for 1 year, 7 months
seen 15 hours ago
stats profile views 13

I am a gamer, programmer, and a wannabe linguist who is fluent in English and Mandarin, and proficient in French.

I am an achievement hunter. Come and visit me on trueachievements.com

I am also an administrator on Wiktionary and have been for over 3 years. I edit mostly in French, Dutch, English and Mandarin, but I also dabble in Italian, Japanese, Maori and Swedish. We are constantly looking for competent volunteers/lexicographers to contribute to this wonderful multilingual dictionary website.

profile for James Jiao on Stack Exchange, a network of free, community-driven Q&A sites


15h
awarded  Caucus
15h
awarded  Constituent
Apr
5
comment Cannot start SQL Server service on SQL Server cluster
What does the cluster log say and what does the Windows log say exactly? Did you accidentally cut off the error message after error code 259?
Nov
27
comment Denied access sending dbmail while impersonated under a login with sysadmin privilege
That did turn out to be what went wrong. There is, however, another way, that is, to use certificates. It's much more secure than turning on TRUSTWORTHY.
Nov
27
accepted Denied access sending dbmail while impersonated under a login with sysadmin privilege
Nov
25
revised Denied access sending dbmail while impersonated under a login with sysadmin privilege
added 208 characters in body
Nov
25
asked Denied access sending dbmail while impersonated under a login with sysadmin privilege
Oct
13
awarded  Yearling
Aug
24
comment What happens when the mirroring server goes offline (for a short while)?
Sounds reasonable. Should I also disable trans log backup on the principal while the mirror is down?
Aug
24
asked What happens when the mirroring server goes offline (for a short while)?
Aug
22
accepted Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
Aug
22
comment Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
Bingo! Yatsi! I usually use the square brackets for weird db or column names like 1234-abc, but didn't think it would apply here. Worked like a charm. Thanks Shark.
Aug
22
asked Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
Jun
28
revised Index defrag takes forever to run
deleted 6 characters in body
Jun
28
awarded  Commentator
Jun
28
comment Index defrag takes forever to run
I give you the credits for sound advice which helped me resolve the problem. I will start looking at other options than reorging the indexes every night. Have updated my answer with the resolution.
Jun
28
accepted Index defrag takes forever to run
Jun
28
revised Index defrag takes forever to run
update
Jun
27
comment Index defrag takes forever to run
This is a legacy Agent job left over from previous DBAs. I will give reorganize a try tonight. It still doesn't explain why all of sudden it's taking more than 20x longer for the defrag to complete though. The clustered index has 2,146,312 pages in total and the table has 234,001,728 rows.
Jun
27
asked Index defrag takes forever to run