Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / MS SQL Server / 2008
Showing: 1-2 of 2  
Articles
 
document what is the method to change location of tempdb?
1. Determine the logical file names of the tempdb database and their current location on the disk. SELECT name, physical_name FROM...
07 May, 2008 Views: 287 Comments: 0
document How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints
07 May, 2008 Views: 143 Comments: 0



RSS