November 2007 - Posts

• Sorted views...

  Here's one that pops up regurarly. Something like: "My views are no longer ordered in SQL Server 2005. I have ORDER BY in the view, but when I select from it, the rows are not returned according to the ORDER BY." Since I tend to post a reply often enough Read More... Posted Wednesday, November 28, 2007 11:21 AM by TiborKaraszi | 17 Comments Filed under: TSQL

• Find table and index name for fragmented indexes

  Got this question from a newsgroup today. The answer is pretty simple, just use the dynamic management view sys.dm_db_index_physical_stats. I'm posting this here mostly so I have somewhere to refer to when asked this question... I prefer to have a helper Read More... Posted Sunday, November 11, 2007 9:53 PM by TiborKaraszi | 14 Comments Filed under: indexes