Posts Tagged ‘70-443’

« Older Entries

What is the SystemProcessor Queue Length counter?

September 30th, 2009

The SystemProcessor Queue Length counter displays the number of threads ready in the processor queue but not currently able to use the processor. The Processor: %Processor Time counter should be measured with a counter. If its value is two, it indicates a CPU bottleneck. This results in slow performance of the server. To eliminate the performance problem, several steps can be used such as reducing the number of processors, using = multiple processors, updating the processors, or installing new and updated CPUs.

Permanent link to this post (284 words, estimated 1:08 mins reading time)
  • Share/Bookmark

No comments »

Posted in MCAD, MCDBA, MCP, MCSA, MCSA 2000, MCSA 2000 to 2003, MCSA to MCSE-2003, MCSE, MCSE 2000

Tags:

What are the types of capacity planning?

September 30th, 2009

The following are the types of capacity planning:

  • Preconfiguration capacity planning: This capacity planning involves the planning and implementation of hardware resources that will be used to accomplish a given task.
This is a preview of What are the types of capacity planning?. Read the full post (136 words, estimated 33 secs reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP

Tags:

Replication

September 29th, 2009

Replication is a type of configuration used to copy data and database objects from one database instance to another. A database administrator has to configure a server for replication, and monitor it in order to detect and resolve issues regarding replication.

Requirements for replication: The following roles are required for replication configuration:

This is a preview of Replication. Read the full post (1359 words, estimated 5:26 mins reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Administrator SQL Server 2008, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2005, MCTS SQL Server 2008

Tags:

What is Database Engine Tuning Advisor?

September 3rd, 2009

Database Engine Tuning Advisor is a tool that tunes a database for better query performance by analyzing a workload that is a set of T-SQL statements. It suggests clustered indexes, nonclustered indexes, indexed views, and partitioning. Database Engine Tuning Advisor in SQL Server 2005 replaces the Index Tuning Wizard of SQL Server 2000. This tool provides two user interfaces: a graphical user interface (GUI) and the dta command prompt utility.

Permanent link to this post (252 words, estimated 1:00 mins reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Administrator SQL Server 2008, MCITP Database Developer, MCITP Database Developer SQL Server 2008, MCITP Database Developer-2005, MCITP Microsoft SQL Server, MCP, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2005, MCTS SQL Server 2008

Tags:

What are the disadvantages of database server consolidation?

August 21st, 2009

The disadvantages of database server consolidation are as follows:

  • It requires high-availability options and failover clustering.

  • It results in the performance deterioration of the server.

  • It requires a disk with high storage and high input-output capacity.

  • It requires more memory.

This is a preview of What are the disadvantages of database server consolidation?. Read the full post (165 words, estimated 40 secs reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer, MCITP Database Developer SQL Server 2008, MCITP Database Developer-2005, MCITP Microsoft SQL Server, MCP

Tags:

What are SQL Server Securables?

August 21st, 2009

SQL Server Securables contains three scopes, which are used to assign permissions to users. The securables are nested and each securable contains various other securables. The securable scopes are as follows:

  • Server: It includes server roles, logins, etc.

  • Database: It includes database users, application roles, database roles, etc.

This is a preview of What are SQL Server Securables?. Read the full post (278 words, estimated 1:07 mins reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Administrator SQL Server 2008, MCITP Database Developer, MCITP Database Developer SQL Server 2008, MCITP Database Developer-2005, MCITP Microsoft SQL Server, MCP, MCTS, MCTS Microsoft SQL Server, MCTS SQL Server 2008

Tags:

What is the IS_SRVROLEMEMBER function?

August 21st, 2009

The IS_SRVROLEMEMBER function provides information about whether or not a login is a member of a specific role. A database administrator can use this information to assign permissions to users. The syntax of using the function is as follows:

IS_SRVROLEMEMBER (’role’, ‘login’)

This is a preview of What is the IS_SRVROLEMEMBER function?. Read the full post (188 words, estimated 45 secs reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP

Tags:

Joins: Its Types and Uses

August 21st, 2009

The JOIN clause is used with the SELECT statement to retrieve data from more than one table. This clause matches data from multiple tables. This results in the creation of a table, which is a combination of columns from multiple tables.

This is a preview of Joins: Its Types and Uses. Read the full post (1053 words, estimated 4:13 mins reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP, OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g

Tags:

How to create a partition for an existing table and index?

August 21st, 2009

Take the following steps to create a partition for an existing table and index:

  1. Create a partition function: A partition function can be created by using the CREATE PARTITION FUNCTION STATEMENT. An example is given below:

    CREATE PARTITION FUNCTION myfunc
    RANGE LEFT FOR VALUES(100, 200, 300)

This is a preview of How to create a partition for an existing table and index?. Read the full post (227 words, estimated 54 secs reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP

Tags:

What are the types of capacity planning?

August 20th, 2009

The following are the types of capacity planning:

  • Preconfiguration capacity planning: This capacity planning involves the planning and implementation of hardware resources that will be used to accomplish a given task.
This is a preview of What are the types of capacity planning?. Read the full post (155 words, estimated 37 secs reading time)
  • Share/Bookmark

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP

Tags:

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.