1,189 reputation
1815
bio website
location
age
visits member for 3 years, 3 months
seen Oct 25 at 22:38

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
Feb
27
revised What is the purpose of the USING parameter in SQL?
improved formatting
Jan
18
comment SQL Server transaction log - shrinking and reattaching
You should not shrink your data file. See for details: sqlskills.com/blogs/paul/…
Sep
12
revised What is the purpose of the USING parameter in SQL?
reworded
Sep
12
answered What is the purpose of the USING parameter in SQL?
Sep
8
accepted Easy way to check connectivity to SQL Server from client
Sep
5
asked Easy way to check connectivity to SQL Server from client
Jul
16
answered Poor performance after changing SQL Server 2008 R2 database