Database Administrators
Profile Activity
Meta user
Network profile
5,572
reputation
2
22
41

James Anderson

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

168
answers
13
questions
~565k
people reached

Communities (10)

Top Meta Posts
4
0

Top network posts

Top tags (177)

Score 276
Posts 116
Posts % 64
Score 81
Posts 31
Score 43
Posts 23
Score 41
Posts 14
Score 34
Posts 14
Score 24
Posts 11
View all tags →

Top posts (181)

All Questions Answers
Votes Newest
26 What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan Jun 20 '14
24 Detecting the locked table or row in SQL Server Oct 8 '14
14 Restricting users to COPY ONLY backups May 1 '14
11 Would it be better for query plans to be split by statement for re-usability? Jan 15 '15
9 Why do temporal tables log the begin time of the transaction? Jul 7 '16
9 Alternative of DBCC CHECKDB May 14 '15
9 Error 35338: Clustered columnstore index is not supported Mar 2 '16
9 Microsoft SQL Server creating an Inline function Jun 17 '16
8 Can you gain the performance benefits of partition elimination without changing SQL module or table definitions? Feb 22 '17
8 Raise error if BCP command fails to dump data into a file Dec 30 '15
View all questions and answers →

Badges (65)

Gold

2

Rarest

Silver

22

Rarest

Bronze

41

Rarest

View all badges →