Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
James Anderson
  • Member for 8 years, 4 months
  • Last seen this week
Profile Activity
Stats
5,635
reputation
633k
reached
167
answers
13
questions
Communities
View all
About

James Anderson is a SQL Server production DBA based in Southampton. Working on multi terabyte databases that provide the backbone for many large scale loyalty reward schemes in the UK and Europe. He has been working with databases since 2008. The first and worst RDBMS he worked with was Paradox. He quickly moved to using T-SQL in SQL Server 2005 and has worked on every version of the product since.

Blog: TheDatabaseAvenger.com

Twitter: @DatabaseAvenger

Badges
View all badges
2
gold badges
23
silver badges
41
bronze badges
Top tags
View all tags
281
Score
116
Posts
64
Posts %
81
Score
31
Posts
17
Posts %
44
Score
23
Posts
13
Posts %
41
Score
14
Posts
8
Posts %
35
Score
14
Posts
8
Posts %
24
Score
12
Posts
7
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
28
What is the use of "Backup set will Expire:" option while creating Backup Database task in Maintenance plan
Jun 20, 2014
answer
24
Detecting the locked table or row in SQL Server
Oct 8, 2014
question
14
Restricting users to COPY ONLY backups
May 1, 2014
question
11
Would it be better for query plans to be split by statement for re-usability?
Jan 15, 2015
question
9
Why do temporal tables log the begin time of the transaction?
Jul 7, 2016
answer
9
Alternative of DBCC CHECKDB
May 14, 2015
answer
9
Error 35338: Clustered columnstore index is not supported
Mar 2, 2016
answer
9
Microsoft SQL Server creating an Inline function
Jun 17, 2016
answer
8
Can you gain the performance benefits of partition elimination without changing SQL module or table definitions?
Feb 22, 2017
answer
8
Raise error if BCP command fails to dump data into a file
Dec 30, 2015
Top Meta posts
4
0
10
Improving my answer after it's been accepted
8
Reopen should require a reason
5
Adding tags based on my answer
3
Should each RDBMS tag have a version number?
Top network posts
View all network posts
13
Temporary failure in name resolution [Errno -3] with Docker
10
Does water have surface tension in a vacuum?

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.