Dear Members,
I would like to know if there is anyway to clear the TempDB in my SQL Server 2008.But with several options whichever resulted in my Google search, but nothing seem to be worked.
Issue Details:
Actually i am running a query which would take probably more than 3 hours to complete an operation ( I am doing the import process for than 1.5 lakh data). Due to this my TempDB increases more than DB size and it causes serve issue in my application.
Please anyone give me the clue to solve my issue..