Database Administrators
Sponsored by
Sponsored logo
James Anderson
Profile Activity
Stats
5,624
reputation
608k
reached
168
answers
13
questions
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

Communities (10)

Top Meta Posts
4
0

Top network posts

2
gold badges
22
silver badges
41
bronze badges
View all badges

Top tags (177)

Score 280
Posts 116
Posts % 64
Score 81
Posts 31
Score 44
Posts 23
Score 41
Posts 14
Score 35
Posts 14
Score 24
Posts 12
View all tags →

Top posts (181)

All Questions Answers
Votes Newest
27 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 →

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.