Microsoft SQL Server 2012: Creating Programming Objects and Optimizing Queries
SQL Server 2012 allows programming objects to be created to group multiple statements together. These objects work with data in the databases. One type of programming object is the stored procedure. ...
Microsoft SQL Server 2012: Database Monitoring and Performance Tuning
To keep SQL Server 2012 databases running as efficiently as possible, there are a variety of performance tuning and monitoring tools. The SQL Server Profiler enables you to use trace files and logs ...
Microsoft SQL Server 2012: Installation and Upgrade
SQL Server 2012 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, the SQL Server Database Engine, Integration Services, ...
Microsoft SQL Server 2012: Instance Configuration and Database Creation
SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. ...
Microsoft SQL Server 2012: Managing Database Data
SQL Server 2012 provides various features and utilities to manage data stored in the databases within a SQL Server instance. This includes support for storing large unstructured data, such as files ...
Microsoft SQL Server 2012: Managing Databases and Automating Tasks
Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files ...
Microsoft SQL Server 2012: Managing Indexes, Full-Text Search and Partitions
SQL Server 2012 provides features to allow administrators to ensure that data is accessed efficiently, this includes the use of indexes, table and index partitions, and full-text search. Indexes in ...
Microsoft SQL Server 2012: Managing XML Data
XML has been integrated into SQL Server 2012 so that XML data can be stored within databases using the xml data type. SQL Server 2012 also allows for relational data already stored in a database to ...
Microsoft SQL Server 2012: Manipulate Data Using Operators and Functions
Microsoft SQL Server 2012 Transact-SQL offers advanced query techniques, such as built-in aggregate, analytic, scalar, and ranking functions, as well as common table expressions, or CTEs and derived ...
Microsoft SQL Server 2012: Querying Basics and Modifying Data
SQL Server 2012 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use ...