Great question!

I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.

Thanks, Gail.

So apparently, the documentation is not incomplete, it just hides it's completeness very well 😉

michael.kaufmann (1/18/2011)

---

I don't understand why the following code is not working (using SQL Server 2005; pasted just my amended query--you'll need the original one, too):

--Select 3

SET @inputValue = '''Hardy''' +...

michael.kaufmann (1/18/2011)

---

Thanks for the question--got it wrong as I missed the indexes on computed columns will not be used.

However, I'm baffled about the statistics, as only 25 % of the...

Interesting, that the documentation (or at least the page referenced in this question) never once mentions filegroup restore. I thought that filegroup restore was possible, but (since DBA is not...

Exactly. That's why I wrote: "most online BOL pages include cross-links". Maybe I should have emphasized the "online" in my earlier reply, and not just here 😀

Actually, it does. I used...

Yes. Easily found through Google or Bing.

And most online BOL pages include cross-links to earlier and/or later versions of the same topic.

I thought I had a pretty grasp of everything that was changed in SQL Server 2008, but I somehow completely missed this one. A nice small change that answers a...

Usually, when I come to the forum while thinking that the question is not 100% acccurate, I encounter lots of similar remakrs already. Today, nobody has yet raised the point...

mtassin (1/10/2011)

---

Chris Harshman (1/10/2011)

---

In my previous life as an Oracle DBA / Developer, I think I understand this question better than people with just a SQL Server background. Other...

The only situation I could think of where I would understand scheduled log shrinking would be when the following factors combine:

1. Two databases each have a peak usage period. During...

jay holovacs (1/6/2011)But as a football team needs to know where each player is going to be on a specific play (and a great player violating the play book does...

cengland0 (1/6/2011)

---

Another way to put this is if the question said:

In a non-empty rowset, ROW_NUMBER() always returns consecutive integers.

What would you answer? True or False?

I'd still answer False because...

cengland0 (1/6/2011)

---

When the question asked will it always return consecutive integers, I knew right away that it was false because none of them will always return consecutive integers if there...