Database Administrators
Meta user
Network profile
5,493
reputation
2
18
40

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
~497k
people reached

Communities (10)

Top Meta Posts
4
0

Top network posts

Top tags (177)

Score 271
Posts 116
Posts % 64
Score 80
Posts 31
Score 42
Posts 23
Score 41
Posts 14
Score 33
Posts 14
Score 24
Posts 11
View all tags →

Top posts (181) 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
23 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 Error 35338: Clustered columnstore index is not supported Mar 2 '16
9 Alternative of DBCC CHECKDB May 14 '15
8 Raise error if BCP command fails to dump data into a file Dec 30 '15
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
View all questions and answers →

Badges (60)

Gold

2

Rarest

Silver

18

Rarest

Bronze

40

Rarest

View all badges →