Browse by Tags
All Tags »
Manageability &... »
Performance and Scalability (RSS)
I’m happy to announce availability of an updated version of the SQL Server Partition Management tool – now offering full support for SQL Server 2008 as well as improvements in handling SQL Server 2005. The tool is available along with source code at http://www.codeplex.com/SQLPartitionMgmt
Read More...
The database system in a company that is growing internationally must support multilingual characters in tables with Unicode data types. Existing d atabases that support only non-Unicode information must be migrate d from non-Unicode data type to Unicode
Read More...
When a business grows internationally, its database system must support multilingual characters in tables. Businesses that previously needed to manage only non-Unicode information must now support database tables that include non-Unicode data types such
Read More...
Scale-Out Querying with Analysis Services Using SAN Snapshots
Read More...
Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads
Read More...
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise
Read More...
SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: In Part 1, we outlined the behavior of SQL
Read More...
Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: A common requirement as business requirements evolve over time is managing schema changes.
Read More...
SQLCAT Blog: Question: How can SQL Server 2005 help me evaluate and manage indexes? (1) How can I find out whether my indexes are useful? How are they used? (2) Do I have any tables or indexes that are not used (or rarely) (3) What is the cost of index
Read More...
In workloads that involve expensive long-running queries and reports, or complex batch operations, you frequently want to see the SQL statements and associated query plans that are active on the system or that consume the most resources. SQL Server 2005
Read More...
