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

Showing: 1-5 of 5  
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: 1108 Comments: 35
document Where we can find Maximum Capacity Specifications for SQL Server 2008?
Please visit following URL
08 Mar, 2009 Views: 847 Comments: 28
document SQL Server Backup Basics
02 Aug, 2011 Views: 591 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...
08 Mar, 2009 Views: 991 Comments: 44
document How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints
07 May, 2008 Views: 728 Comments: 28



RSS