Database Administrators
Meta user
Network profile
5,079
reputation
2
18
39

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

169
answers
13
questions
~451k
people reached

Communities (10)

Top Meta Posts
4
0

Top network posts

Top tags (177)

Score 264
Posts 117
Posts % 64
Score 76
Posts 31
Score 42
Posts 23
Score 42
Posts 10
Score 32
Posts 15
Score 24
Posts 11
View all tags →

Top posts (182) All Questions Answers | Votes Newest

24 What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan Jun 20 '14
22 Detecting the locked table or row in SQL Server Oct 8 '14
13 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
10 Microsoft SQL Server creating an Inline function Jun 17 '16
9 Alternative of DBCC CHECKDB May 14 '15
8 Error 35338: Clustered columnstore index is not supported Mar 2 '16
8 Why do temporal tables log the begin time of the transaction? Jul 7 '16
8 Can you gain the performance benefits of partition elimination without changing SQL module or table definitions? Feb 22 '17
7 Removing TDE from server Dec 16 '16
View all questions and answers →

Badges (59)

Gold

2

Rarest

Silver

18

Rarest

Bronze

39

Rarest

View all badges →