Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • but this will require me to build a whole new DAL for the administration page, that will return all the data (regardless it's deleted or not) Commented Mar 9, 2011 at 4:13
  • You should design your DAL with handling of deleted column in mind. If you do, the difference is only a boolean flag passed which determines if you want to show deleted elements or not. Commented Mar 9, 2011 at 4:20
  • concerning your edit, the Id is already a primary key which is by default an Index .. so I should index the deleted only! .. I'm sorry it's off this question's topic but you got me confused about this right now! Commented Mar 9, 2011 at 4:21
  • You're right, I've just modified the example, the code is just to illustrate the idea, it's not SQL Server specific. Commented Mar 9, 2011 at 4:24
  • I meant that the Id column in my database is already a primary key, doesn't it mean that it's already using a cluster index/do I have to add an index to it ?? .. and btw thanks for the index tip +1 Commented Mar 9, 2011 at 4:29