SearchSQLServer.com | Dell Topical Info Center


	Home > Dell Topical Info Center

Dell Topical Info Center

EMAIL THIS

MUST READ


		Top 10 SQL Server Tips of 2007 Published by: SearchSQLServer.com \| 07 Jan 2008 THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2007 on topics of SQL Server database design and performance tuning to upgrading to SQL Server 2005 and stored procedures.


		Tricks to increase SQL Server query performance Published by: SearchSQLServer.com \| 28 Nov 2007 TIP - Tricks optimizing SQL Server query performance include choosing CREATE TABLE over SELECT INTO and a stored procedure method over linked server queries.


		View query execution plan in SQL Server with this method Published by: SearchSQLServer.com \| 14 Dec 2007 EXPERT RESPONSE - Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree cost.


		SQL Server clustered index design for performance Published by: SearchSQLServer.com \| 07 Jan 2008 TIP - Find why SQL Server clustered index design should be narrow and static and how clustered indexes affect many-to-many tables to improve database performance.


		Change collation to SQL Server 2005 after upgrading databases Published by: SearchSQLServer.com \| 13 Dec 2007 EXPERT RESPONSE - Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and SSIS.


	SQL SERVER DATA WAREHOUSING/BUSINESS INTELLIGENCE from SearchSQLServer.com


		Manage traces in SQL Server 2005 Analysis Services with XMLA commands TIP - SQL Profiler monitors SQL Server 2005 Analysis Services. But if you must manage numerous instances of MSAS, use XMLA automated trace with create and alter.


		Open SSIS packages without validation using these SQL properties TIP - Learn how to open SSIS packages without validation by using the DelayValidation and ValidateExternalMetadata property options.


		How to process SQL Server 2005 Analysis Services for data availability TIP - SQL Server 2005 Analysis Services offers data availability options for processing cube partitions. Learn how to decrease SQL memory, CPU and disk use for availability.


	VIEW ALL IN THIS TOPIC


	SQL SERVER AVAILABILITY from SearchSQLServer.com


		SQL Server high availability when upgrading to SQL Server 2005 TIP - Make your goal to support SQL Server high availability when upgrading to SQL Server 2005 using a secondary server. Move to a transition server and then rebuild your source system.


		How to restore SQL Server database to transition server during upgrade TIP - Part 2 in this upgrade series lists the steps to point application traffic at a transition server while the primary cluster is rebuilt to Windows Server 2003 and SQL Server 2005.


		SQL Server memory configurations for procedure cache and buffer cache TIP - SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.


	VIEW ALL IN THIS TOPIC


	SQL SERVER CLUSTERING from SearchSQLServer.com


		Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003 TIP - This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability.


		SQL Server backups using SAN database snapshots TIP - This overview on SAN snapshots for the DBA's tool belt reviews performance impact, filegroup and file layout, replication, transaction logs and snapshots for data warehouses.


		SQL Server cluster design: One big cluster vs. small clusters TIP - Clustering design in a SQL Server environment is a key strategy. You must consider options including load balancing, disk array failure, the number of nodes and instances.


	VIEW ALL IN THIS TOPIC


	SQL SERVER PERFORMANCE AND TUNING from SearchSQLServer.com


		SQL Server memory configurations for procedure cache and buffer cache TIP - SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.


		Tutorial: Migrating to SANs from local SQL Server disk storage SPOTLIGHT - Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.


		Using the OUTPUT clause for practical SQL Server applications TIP - Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.


	VIEW ALL IN THIS TOPIC

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2005 - 2008, TechTarget \| Read our Privacy Policy