November 22, 2008 at 6:35 am
hi Experts how are you i have some douts
1)How to do the Defragmentation?
2)how to check the free space in server?
3)my application developer deleted 10 records how can i get back that records?
4)how to check the last index?
5) give me the defragmentation steps?
plz give me the solution.
regards
tn
November 22, 2008 at 4:59 pm
teddunaveen (11/22/2008)
hi Experts how are you i have some douts1)How to do the Defragmentation?
2)how to check the free space in server?
3)my application developer deleted 10 records how can i get back that records?
4)how to check the last index?
5) give me the defragmentation steps?
plz give me the solution.
regards
tn
How about doing some researcher before just asking all these questions. A great place to start is Books Online (BOL).
After you have read the appropriate sections, then read the article in my signature block about asking for help. It will provide you with valuable information on how to best ask for help that will provide you with the most information answer(s).
November 22, 2008 at 5:41 pm
teddunaveen (11/22/2008)
hi Experts how are you
We're busier than we would like due to multiple threads that could easily be answered by a quick read through of Books Online.
1)How to do the Defragmentation?
Books Online: DBCC DBREINDEX
2)how to check the free space in server?
On disk or within a database file?
3)my application developer deleted 10 records how can i get back that records?
If you have a backup then
Books online: Restore database
If you don't have a backup, you don't get the data back.
4)how to check the last index?
Question does not compute
5) give me the defragmentation steps?
See question 1
plz give me the solution.
Is google down? Can you perhaps do a little of your own research first?
Contrary to popular belief, a google search is faster than posting here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy