What position are you applying for?

Main advice I can give you is to relax, be honest and be willing to admit that you don't know something. Especially for a junior...

brd123 (4/20/2009)

---

Would it make sense to create several separate 'chunks' of the 900 bytes just for indexing and then present the original descriptive field to the user after he/she...

I think you've got a form of data corruption there. I'm not sure how to deal with that myself, not on SLQ 2000. I've pinged an expert on corruption, I'm...

I'll be blunt (as usual)

The phrase 'dumps' usually refers to questions memorised from the exam and posted online in violation of the NDA on exams. If that's want you're asking...

You can try the default trace. Depending on the activity on your system it may go back 2 weeks or it may not. The default trace is made up of...

Get them back or know who dropped them?

Minimal, if at all.

Why can't you do the identifying of bad records and updating of...

Tim Walker (4/20/2009)

---

However I've never done a controlled test on this and it may well come down to optimisation differences because of the lack of statistics on the table...

660 MB of data's a fair bit. I wouldn't be surprised if the time difference is due to the network. That's a lot of data to be streaming out.

What's the...

This kb may be of interest, even though it's supposedly just for SQL 7 and 2000.

http://support.microsoft.com/kb/314648

Table variables, just like temp tables are allocated space in TempDB. SQL tries as much as possible to keep them in memory (in the data cache) because it knows that...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic700470-391-1.aspx

Is there any blocking?

Just a thought, can you run a consistency check on the databases on that server?

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Any errors in the SQL Error log?

Try this

exec sp_msforeachdb 'use [?] exec sp_spaceused'