again.

someone tell her to read the forums eh?

Only difficulty there is then the pk (I am carelessly assuming its clustered) rebuild...

I would suggest your biggest issue is going to be handling the transaction logs.  This is going to be a pain wether you are inserting 75million rows or deleting 125million.

Check...

I had a bunch of data (100,000s of records) disappear over the space of about 5 hours once...everything gone for that time period.  Turned out that some dev hadn't got...

I mean, let's face it: These kinds of questions are sensationalist. Most people who get into an interview situation ARE ABSOLUTELY QUALIFIED FOR THE JOB. Period. No one would waste...

So, what has scanning electron microscopy got to do with being a good dba

Check the logon for the performance counter service.

Wondering if you managed to resolve your issue?

I have come to the conclusion that I over reacted badly in my initial post here, possibly because I have come to expect especially high standards in this environment.

Therefore I...

There is another potential cause, and it is the one that I suffered from last year.  Basically its a permissions issue.  Can't remember the exact details, but it was my...

), a warning is generated and the database remains unrecovered."  If "the database remains unrecovered.", isn't that a FAILURE? 

I would assume that this is using the parlance of the...

what utter drivel.  This is such a daft question it is insulting.

backup database tester to disk ='c:\tester.bak'

RESTORE DATABASE tester FROM DISK = N'c:\ tester.bak' , NORECOVERY

Gives:

Server: Msg 3206, Level...

Grr... Foyles (like the biggest(?) bookshop in the world) had the box set for £100 ... £30 more than in amazon.  Sadly they didn't feel like matching the price in...

If you want to see unbridled outrageousness on the plagiarism front have a squiz at http://www.kdkeys.net/forums/default.aspx?ForumGroupID=7  Shocking.

I have noticed a lot of people posting what appears to be second...

The pain really kicks in when you set up the sqlserver to take a binary sort, but set up a database to be CI_AI ... fun with variables and temp...