Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us

Showing: 1-4 of 4  
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: 753 Comments: 0
document Where we can find Maximum Capacity Specifications for SQL Server 2008?
Please visit following URL
08 Mar, 2009 Views: 396 Comments: 0
document what is ONLINE INDEX?
Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for...
09 Mar, 2009 Views: 518 Comments: 0
document How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints
07 May, 2008 Views: 441 Comments: 0



RSS