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

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?
Dec
24
comment How to protect SQL Server from Hackers
Looks like SF will be the third destination for this question!.
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`
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.
Apr
14
comment How can we recover/restore lost/overwritten data in our MSSQL 2008 table?
The NOT NULL lsn is explained here not good news I'm afraid. I was hoping it might mean that your log files were not in auto truncate mode for some bizarre reason but that would be too much to hope for.
Apr
14
comment How can we recover/restore lost/overwritten data in our MSSQL 2008 table?
@TeTe - The results you want to see from the above query are FULL for the recovery model and a NOT NULL value for last_log_backup_lsn. If that is NULL then this means your database is in auto truncate mode and your log files will be being automatically recycled rather than maintaining an unbroken history.
Apr
14
comment How can we recover/restore lost/overwritten data in our MSSQL 2008 table?
What does this return for your database? select d.name,recovery_model_desc,last_log_backup_lsn from sys.database_recovery_status r join sys.databases d on r.database_id=d.database_id
Apr
8
comment SQL Server 2008 Underperforming - extreme slowness after migrating to new server
Hmmm, Even on my laptop that query takes about a second looking at select MAX(Date),MIN(Date) from #Temp. What does sys.dm_os_wait_stats say?
Mar
29
comment SQl 2005-2008 vs. SQL 2000 maintenance
A good blog post on the statistics issue - might you be hitting that kind of problem?
Mar
29
comment SQl 2005-2008 vs. SQL 2000 maintenance
Why are you rebuilding indexes every night? To remove fragmentation? How fragmented do they get in one day then?