Archive for November 2010

Black Friday Sale From uCertify

uCertify has some terrific treats for you this Thanksgiving! Check out the following incredible savings:

60% off any 6 PrepKits

55% off any 5 PrepKits

50% off any 4 PrepKits

40% off any 3 Prepkits

35% off any 2 Prepkits

This is one feast you won’t want to miss! You will pass in your first attempt or your money back. No questions asked. What else do you want?

uCertify wishes our customers a very happy Thanksgiving!

Happy Shopping & Happy Learning!

Your uCertify Team

http://www.ucertify.com

Share

uCertify Early Bird Sale

Enjoy the splendid offer given by uCertify to first 100 customers to begin feasting early! Buy 3 or more Prepkits and get 40% OFF!
I think this is the opportunity that most of you won’t miss. The best part … you won’t regret feasting! You will pass in your first attempt or your money back. No questions asked. Select any 3 PrepKits and save 40% today
See you at https://www.ucertify.com/cart/todaysdeal.php
Happy Shopping & Happy Learning!
Your uCertify Team
http://www.ucertify.com

Share

The query() method

The query() method is used to specify an XQuery against an instance of the xml data type. The result is of xml type. An instance of untyped XML is returned by this method. It has the following syntax:

query (‘XQuery’)

where XQuery is a string, an XQuery expression, that queries for XML nodes, such as attributes, elements, in an XML instance.

Share

Template Explorer window

The Template Explorer window is used to open a list of templates that allows users to create objects in the database. This template includes files that contain SQL script to create objects. Users use this template to create tables, views, indexes, stored procedures, trigger and functions.

Share

Transaction Log File

When any database is created in SQL Server then at least one file is created to store the data and system tables and another file to hold the transaction log. The transaction log is stored in one or more files with a default extension of .ldf.

If the size of the transaction log file is not specified, then the transaction log will be resized to 25 percent of the size of the data file. This transaction log file is used to store all the transactions and modifications done on the database. The transaction log file is very useful in performing the backup and restore process of the database.

Share

The sp_update_agent_profile stored procedure

The sp_update_agent_profile stored procedure is used to update the profile used by a specified agent.
The syntax for using this stored procedure is as follows:

sp_update_agent_profile [@agent_type=] agent_type, [ @agent_id= ] agent_id, [@profile_id= ] profile_id

Arguments:
[@agent_type=] ‘agent_type’: It is the type of agent and its type is int.

[@agent_id= ] ‘agent_id’: It is the type of ID and its type is int.

[@profile_id= ] ‘profile_id’: It is the ID of the profile that should be used by the agent. Its type is int.

Share

dta utility

The dta utility is the command prompt edition of Database Engine Tuning Advisor. The dta utility allows users to use Database Engine Tuning Advisor functionality in applications and scripts.

The dta utility analyzes a workload and suggests physical design structures to enhance server performance for that workload. The workload can be a SQL Server Profiler trace file or a table, or a Transact-SQL script. Physical design structures comprise indexes, indexed views, and partitioning. After examining a workload, the dta utility produces a suggestion for the physical design of databases and can produce the necessary script to implement the suggestion.

Share

Native mode

Native mode is the default mode for report server instances. In this mode, a report server is a stand-alone application server that provides all viewing, management, processing, and delivery of reports, and report models. A user can install a native mode report server that is configured during setup or configure it for native mode operations after Setup is finished.

Share

SharePoint integrated mode

SharePoint integrated mode enables the integration of Reporting Services with the SharePoint databases and security model. These features become available when a user configures a report server to run within a larger deployment of a SharePoint 3.0 product or technology. This mode requires additional software and configuration. It also necessitates that a report server instance be dedicated for integrated operations. The benefit of doing this is a rich level of integration that allows a user to access and manage report server content types using the application pages and data stores of a SharePoint Web application.

Share