SQL Server 2008 Books

 Location:  Home » SQL Server 2008 News  
List by Topic
All SQL Server 2008 Books
Integration Services (SSIS)
Reporting Services
Analysis Services
Data Warehouse
Spatial Data
SQL Server Software

SQL Server 2008 News

   Thu, 29 Jul 2010 02:20:08 EDT
While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database administrator - Microsoft SQL Server - Database - FAQs Help and Tutorials
Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming
Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

SQL - Database - Microsoft SQL Server - FAQs Help and Tutorials - Programming
With careful planning, DBAs can get similar functionality to Microsoft’s MDS feature -- without migrating to R2 -- by taking advantage of older SQL Server technologies.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Microsoft - Database - Database administrator
SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - FAQs Help and Tutorials - Programming
Although a pivot table is one component of Microsoft’s BI stack, it takes a lot more to create a full-fledged business intelligence solution.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Business intelligence - Microsoft - Database - Pivot table - Data Warehousing
Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - FAQs Help and Tutorials - Function (mathematics)
Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - SQL - Database - FAQs Help and Tutorials - Programming
When a database outgrows its server, DBAs have the option of either scaling it out across multiple systems or moving to a more powerful server. Here are the factors to consider.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Database - SQL - Microsoft SQL Server - Database administrator - FAQs Help and Tutorials
Self-service BI tools could empower midmarket users   Wed, 16 Jun 2010 23:00:00 EDT
Midmarket organizations may look to SQL Server 2008 R2 and Microsoft PowerPivot for upcoming BI investments.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Microsoft SQL Server - Windows Server 2008 - Databases - Microsoft - FAQs Help and Tutorials

Copyright TechTarget - All rights reserved.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com