Sean Lange (10/17/2013)

---

SQLBill (10/17/2013)

---

My wife doesn't want to hear about it. But interestly enough, she goes on and on about her work and expects me to be interested. ...

There's no undo command unfortunately!

RTaylor2208 (10/18/2013)

---

They asked if I woud take 15K less than they had advertised, considering I'm a senior SQL DBA with 12 years experience, on a permenant contract for a world...

India's a big place, but Google seems to think so ;-). Is this any use for starters?

http://www.sqlpass.org/PASSChapters/India.aspx

John Mitchell-245523 (10/18/2013)

---

Beatrix, where are you based? There should be a user group[/url] near you. There only about once a month, so it's not much of a time...

This is timely. I'd like (ok, I need!) to do more networking but it seems like the UK has less of a culture of it than the US and Canada....

I kind of do, in my limited way. My husband works in a different area of IT, so it can be interesting to...

Yeah. I'll stop, I'm only embarrassing myself ;-).

I keep recommending this, but this free eBook may help you: http://qa.sqlservercentral.com/articles/books/89519/

You don't have e.g. an offsite backup that takes a copy of your backup file every night, do you? If so you could possibly restore that.

Thanks; sorry if that was a hijack.

Thanks. So if an image is taken every hour (would it be? Is that likely?), and up to an hour's data loss was considered acceptable, bam, no need for SQL...

No it doesn't, not for the pdf.

To clarify, when I say pdf I mean the downloadable version, which is free. The book does cost money if you buy it from...

At risk of asking a silly question, does this reduce/remove the need to back up databases within SQL Server for recovery purposes?

Thanks

Forgot to add, I found this script here; it might be useful?

SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName,

ind.name AS IndexName, indexstats.index_type_desc AS IndexType,

indexstats.avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats

INNER JOIN sys.indexes ind

ON...

There's a good free pdf book here called SQL Server Maintenance Plans[/url], and it has some nice sections on indexes, especially pages 106 onwards.