Interested to Buy Any Domain ? << Click Here >> for more details...
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 4245 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / irimi
DBCC commands are most useful for performance and troubleshooting
PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how does an oracle clusterware manage crs resources?
What is replication? : sql server DBA
Where would you look for errors from the database engine?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is dbcc? : sql server DBA
how can you schedule a job in database?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What is fill factor? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
