Nice article on Bookmark Lookups. They are not always worth getting rid of.

http://www.sqlservercentral.com/columnists/RDyess/bookmarklookups.asp

I agree that your email response to the candidate was unprofessional, and served no useful purpose.

Having been asked some very similar questions in a recent interview, I also did...

I found another site http://weblogs.sqlteam.com/tarad/archive/2005/01/04/3933.aspx that says somthing a little different "It turns out that only when a non-unique clustered index gets rebuilt, that the non-clustered ones get rebuilt as well."...

Before I get yelled at...DBCC DBREINDEX

FYI:

Examples of sites making this claim

http://www.sql-server-performance.com/rebuilding_indexes.asp

http://www.windowsitlibrary.com/Content/77/17/1.html

I agree with the other comments. The given answer is incorrect.

That's two days in a row I've missed points because of incorrect answers. Does anyone review these before publishing?

As David Burrows has stated, SERVERPROPERTY is not valid in 7.0. therefore there is no single correct answer to this QOD.

I am truly an idiot. Thanks

I agree with the american version. 12/04 for today.

I came here to voice my objections on the "correct" answer bu I guess enough said!

If you have the schedule set to daily...change it to weekly and then check off the individual days you wish it to run on. This is a known bug in...

Don't do it ! You will regret it due to space concerns and no ability to compare the image type.

Put the image in a bcked up directory and dtore the...

These are datatype image. As I said I inherited this mess and never would have taken this approach, but now I need to remedy the situation.

quote:

---

You can use dbcc checkident to reset the identity. This could have happened.

To fix things, find the max value and ensure the...

quote:

---

Have you run dbcc checktable to check anything wrong on these three tables?

---

I have...