Reputation
1,364
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 9 18
Newest
 Nice Answer
Impact
~116k people reached

Mar
18
comment SQL Server performance is slow when migrated from SQL Server 2012 to SQL Server 2014
Did you follow common guidelines when migrating/upgrading SQL Server instances? See for example Upgrading to SQL Server 2014: A Dozen Things to Check.
Feb
12
comment Too big database file 90GB
Why do you think it is too big?
Jan
28
awarded  Nice Answer
Jan
15
comment When using an ORM, what are some things to watch out for in your database design
+1: "The database should be ORM agnostic". Stick to the standards for database design and good ORMs will be happy too.
Dec
18
awarded  Autobiographer
Nov
11
awarded  Enlightened
Nov
11
awarded  Nice Answer
Oct
15
awarded  Famous Question
Jul
12
awarded  Yearling
May
23
awarded  Quorum
Feb
28
comment What can cause Reads to slow down on SQL Server 2008R2?
@Mark Wilkinson: Should have added a note of caution, indeed.
Feb
28
comment What can cause Reads to slow down on SQL Server 2008R2?
Outdated statistics are also a possible source for performance degradation. You could run EXEC sp_updatestats on the database using Management Studio to update the statistics.
Oct
29
awarded  Notable Question
Aug
30
answered Does a re-index update statistics?
Jul
31
awarded  Popular Question
Jul
12
awarded  Yearling
Jun
5
comment Move database files if database runs
You could do a backup and restore that one on the remote machine, if it's just for offline reporting or some consistency checks that you were mentioning. The backup could be done without having any downtime. You'd just have some load on your server.
May
21
awarded  Constituent
May
14
awarded  Caucus
Mar
26
awarded  Organizer