307 reputation
19
bio website
location United Kingdom
age
visits member for 4 years, 3 months
seen yesterday

Email: stackoverflowmartinsmith@gmail.com


Jun
18
comment System time on Windows Server 2008 server increasing continuously
The time on most system clocks increases continuously. I take it yours increases faster than it should then?
Feb
12
awarded  Critic
Dec
24
comment How to protect SQL Server from Hackers
Looks like SF will be the third destination for this question!.
Jan
14
awarded  Student
Jun
8
awarded  Caucus
Dec
9
comment SQL Server 2008 Express R2 restores after restart (and fails)
What do you mean "Most of the time, the database will become stuck in the restore process."? It never completes or just restore takes more time than you would like? Do you potentially have long running transactions in flight when you restart the instance?
Oct
26
comment Unexplained CPU and Disk activity spikes in SQL Server 2005
It's entirely possible I remembered wrong. You should be able to trace them through perfmon though?
Oct
26
comment Unexplained CPU and Disk activity spikes in SQL Server 2005
Are you tracing checkpoints in your trace?
Oct
14
comment How does SQL Server handle simulataneous read/write requests?
There is an overview of SQL Server Scheduling here. It is covered in more detail in Professional SQL Server 2008 Internals and Troubleshooting
Sep
12
comment SQL Server & Disk Space
locate tempdb in object explorer, right click then "Tasks -> Shrink"
Sep
12
comment SQL Server & Disk Space
restarting the service will recreate it or you can shrink the individual files using the SSMS GUI.
Aug
28
comment Can I rollback last update on SQL database?
What RDBMS? If SQL Server what is your recovery model and have you ever taken a full database backup?
Aug
10
comment Transfering database from SQL Server
Probably `C:\Program Files\Microsoft SQL Server\SomeFolderName\MSSQL\DATA`
Aug
10
answered Transfering database from SQL Server
Aug
10
awarded  Scholar
Aug
10
awarded  Citizen Patrol
May
5
comment SQL server slowdown
@Dustin activity monitor probably doesn't exist for SQL Server 7 @user What is the trigger code? Also what do you mean by processing a file?
May
5
comment SQL server start-up bringing online database priority
Ah I thought SQL Server 2008 had multiple threads doing database recovery precisely because of this issue. Although not sure how many of these there are.
May
5
comment SQL server start-up bringing online database priority
What version of SQL Server are you on?
Apr
26
comment How To Back Up a Database from My Web Hosting Server to My Computer
Where are you trying to backup to? The backup location needs to be a path on the server not your local machine.