Browse by Tags
All Tags »
Manageability & Serviceability (RSS)
SQLCAT members have published several tools on Codeplex and other places. They are all consolidated here at SQLCAT.com. http://sqlcat.com/toolbox/default.aspx
Read More...
As anyone working with partitioned tables knows by now, the process of creating stand-alone ‘staging’ tables to support switching data into or out of a partition can be a management challenge, especially if the design of the partition table or its indices
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...
It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And all of these rules have rich documentation telling you what need to know.
...
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...
If you are view the XMLA script that is generated for an Analysis Services database, you will notice that there are both ID and NAME attributes. The reason Analysis Services has this differentiation is so one could rename an Olap database (which you could
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...
Question 1: How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2: Can I recover a single object such as a table or specific partition(s) from a partitioned table? Answer: The question is how to get the greatest flexibility,
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...
