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


		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.


		Export SQL Server data to an Excel file using SSIS and Visual Studio TUTORIAL - Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel.


		Five steps to event handlers in SQL Server Integration Services (SSIS) TIP - Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.


	VIEW ALL IN THIS TOPIC


	SQL SERVER AVAILABILITY from SearchSQLServer.com


		Tips for moving from SQL Server local disk storage to SANs TIP - Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.


		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.


		SQL Server 2005 log shipping setup using the wizard TIP - Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.


	VIEW ALL IN THIS TOPIC


	SQL SERVER CLUSTERING from SearchSQLServer.com


		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.


		FAQ: SQL Server comparison features FAQ - In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005.


		Active/Active clusters in SQL Server TIP - Multi-instance, or Active/Active SQL Server cluster design involves optimizing high availability and performance to ensure both instances can run on a single node.


	VIEW ALL IN THIS TOPIC


	SQL SERVER PERFORMANCE AND TUNING from SearchSQLServer.com


		Migrate and consolidate Access databases to SQL Server TIP - Use Import / Export Wizard to migrate Microsoft Access databases to SQL Server and then consolidate the SQL databases and eliminate duplicate data.


		Check SQL Server database and log file size with this stored procedure TIP - Check the size of your SQL Server database with the undocumented stored procedure sp_SDS and get results beyond sp_spaceused. Also calculate log file size and monitor DB growth.


		SQL Server PerfMon counters for access methods and buffer manager SCREENCAST - SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.


	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