MS SQL SERVER DBA

Features of SQL SERVER 2000 The feature available in SQL SERVER 2000 are: Enterprise Manager Query Analyzer Server Network Utility SQL Profiler Client Network Utility DTS Packages For More Information on Features of SQL SERVER 2000. See the article http://msdn.microsoft.com/en-us/library/aa313021%28v=SQL.80%29.aspx   New Features of SQL SERVER 2005 SQL Server Management Studio SQL Server 2005 includes SQL Server Management Studio, a new integrated suite of management tools with the functionality to develop, deploy, and troubleshoot SQL Server databases, as well as enhancements to previous functionality. Online Restore With SQL Server 2005, database administrators are able to perform a restore operation while an instance of SQL Server is running. Online restore improves the availability of SQL Server because only the data being restored is unavailable; the rest of the database remains online and available. Database Mirroring Extend log shipping

Common Commands of SQL Server for a SQL DBA sp_helpdb This gives you information about all databases in the instance or specific information about one database. sp_helpdb sp_helpdb databasename fn_virtualfilestats This command will show you the number of read and writes to a data file. Use sp_helpdb with the database name to see the logical file numbers for the data files and the database id. SELECT * FROM :: fn_virtualfilestats(dabaseid, logicalfileid) SELECT * FROM :: fn_virtualfilestats(1, 1) fn_get_sql() Returns the text of the SQL statement for the specified SQL handle. This is similar to using DBCC INPUTBUFFER, but this command will show you additional information. This can also be embedded in a process easier then using the DBCC command DECLARE @Handle binary(20) SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52 SELECT * FROM ::fn_get_sql(@Handle) sp_lock This command shows you all of the locks that the system is currently tracking This is similar to information