322 reputation
110
bio website
location United Kingdom
age
visits member for 4 years, 6 months
seen Oct 6 at 9:55

Email: stackoverflowmartinsmith@gmail.com


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?
Apr
3
awarded  Yearling
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?
Mar
23
comment SQL Server restore problem
Have you read this already?
Mar
6
comment How to make Sql Server 2005 run on port 1966?
@IAdapter You need to enable TCP/IP protocol then it will start listening on a port. Do you have 3 instances installed? If so you will probably want to make sure that the SQL Browser service is running as they can't all listen on 1433.
Mar
6
comment How to make Sql Server 2005 run on port 1966?
@IAdapter - It's a configuration issue so belongs on ServerFault.
Mar
4
comment Delete Database Information
@Thomas - EventClass=47 is from SELECT trace_event_id FROM sys.trace_events WHERE name = 'Object:Deleted' 16964 is database
Mar
4
comment Delete Database Information
Actually deleted previous comment. I was searching for the word DROP in the text data. I think this might show it SELECT * FROM sys.traces cross apply fn_trace_gettable(path, 1) where EventClass=47 and id = 1 and ObjectType=16964
Mar
2
comment Can I fit an entire DB in memory?
I haven't enough rep to vote this down but not sure why you are saying that it categorically would not be stored in memory. Once a page is read into the buffer cache it will stay there until internal or external memory pressure causes the cache to be trimmed.
Mar
2
comment Can I fit an entire DB in memory?
You need to remember that data pages are not the only memory consumers in SQL Server. The plan cache and even locks can also take hefty amounts of memory. Additionally dirty pages will get written out to disc every checkpoint so there will still be some disk activity.
Mar
2
comment Is having a 92MB .mdf with a 58MB .ldf okay? How do I manage the log to keep things running well?
RE: The Title Question
Feb
23
accepted How can Windows defragmentation tools cause internal fragmentation in SQL Server?
Feb
2
comment How can Windows defragmentation tools cause internal fragmentation in SQL Server?
@Sergey - No it wouldn't be the first time I've read something online that contains errors but as it is on an MSDN blog I assumed that there must be something in what they were saying and that I just wasn't getting it. Having looked at gbn's update I am now somewhat doubting the credibility of this blog however!
Feb
2
comment How can Windows defragmentation tools cause internal fragmentation in SQL Server?
@Sergey - Again this seems completely orthogonal to the issue of Windows defragmentation which was my point of confusion. Unless the author is using "internal fragmentation" to mean something different from what I (and you I think) understand this concept to mean the two things seem entirely unrelated. And if the author is referring to something different what is the issue they are referring to?
Feb
2
comment How can Windows defragmentation tools cause internal fragmentation in SQL Server?
Ah OK the cynical angle hadn't occurred to me. Does the claim that Windows defragmentation can cause internal fragmentation make any sense to you?