A bit late but I made the following updates which were useful to me -- flag table versus view and identify if a field is an identity field. Maybe...

For the index query try

INNER JOIN sys.index_columns b

ON a.[object_id] = b.[object_id] and a.index_id = b.index_id

+1

That's the resource I found

+1

Great explanation

You can also use

select o.name as ProcedureName

, db_name(parent_object_id) as DatabaseName

--, sm.definition

, o.create_date as CreateDate

, o.modify_date as LastAlteredDate

from sys.sql_modules sm

inner join sys.objects o on sm.object_id = o.object_id

Benefit is the definition here...

Fragments in full-text catalog

select object_name([table_id]) as TableName

, count([fragment_id]) over(partition by table_id) as Fragments

from sys.fulltext_index_fragments

Hugo Kornelis (6/13/2013)

---

Boy, how do I hate questions like this. No wait, the question is okay, it's the answer options.

If the question is "how many rows", the answer options should...

zerko (4/28/2013)

---

the joys of answering early :pinch: -

The QotD question states "Which of the following hints require the word WITH? (choose 3) "

I don't use Table Hints that...

Hugo Kornelis (4/4/2013)

---

Great idea for a question, Kapil!

But ... (isn't there always a "but"?)

When I saw the question in the newsletter, I expected the answer options to be phrased in...

The way I read there are only 2 correct answers:

not 106,107,109,113

20,21

The answer, and included as a correct answer

Styles greater than 100

Cannot be correct because of the exceptions 106,107,109,113.

The answer appears...

Yep, Yep. 😀

I figured I was missing something/not thinking straight this morning.

Thanks

Not so much the information on that "landing page" as much as the additional links to additional information regarding each index type.

Worked for me this time 😀

Cheers.

Nice. I found this link very helpful...

http://msdn.microsoft.com/en-us/library/ms175049.aspx

Cheers

Did a little research and ran across this previous QotD

http://www.sqlservercentral.com/questions/Model+Database/69457/

"With SQL Server 2005 or 2008. Wnen (sic) working with the Model database what can you NOT do? Select...