SQL Server 2008 :: Database Level Selection Settings?

I have following table structure

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FAS_LEDGER](
[TID] [INT] IDENTITY(1,1) NOT NULL,
[TDATE] [DATETIME] NOT NULL,

[code].....

in this table I have 1571182 rows

the problem is someone did some changes in this LEDGER table

I can insert new rows in this table but when I try to fetch latest rows on the basis of following query then I did not get the latest row.

means

following query gives all the rows of this table

SELECT * FROM dbo.FAS_LEDGER ORDER BY TID DESC

and when I try to filter Master_code = '02-07-01-008-0001' and apply oder by TDATE I do not get latest rows

SELECT * FROM dbo.FAS_LEDGER WHERE MASTER_CODE = '02-07-01-008-0001'
ORDER BY TDATE DESC