Browse by Tags

Tagged Content List
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: SQLCAT.com consolidated index of Whitepapers

    In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years. While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking. Hopefully...
  • Blog Post: Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

    The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of...
  • Blog Post: Why can't I attach a database to SQL Server 2008 R2?

    Recently, a problem was presented to me by a DBA using SQL Server 2008 R2. He could not attach a database whose files had been copied from another server. This blog talks about the situation and the solution. Here are the steps he went through to arrive at his situation. DBA #1 logs into a remote...
  • Blog Post: Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008

    Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance. If you choose this upgrade strategy, you should be aware that you cannot detach an msdb database from a SQL...
  • Blog Post: New Version of Partition Management Utility Available

    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 . If you’re...
  • Blog Post: SQLCAT Toolbox

    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
  • Blog Post: New Partition Management Tool Available on Codeplex

    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 change over time. A staging table for new data...
  • Blog Post: New Best Practices Whitepaper published: "Best Practices for Migrating Non-Unicode Data Types to Unicode"

    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 data type. This paper summarizes best practices...
  • Blog Post: SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!

    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...
  • Blog Post: New Best Practices Whitepaper Published: The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode

    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 as CHAR or VARCHAR. As the business grows internationally...
  • Blog Post: New Best Practices Article

    Scale-Out Querying with Analysis Services Using SAN Snapshots
  • Blog Post: Renaming Olap Databases Issues within Analysis Services

    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 not do officially within Analysis Services 2000...
  • Blog Post: SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments

    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 the Distribution database, delivers and applies...
  • Blog Post: Managing Schema Changes (Part 2)

    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 Server 2005 schema changes. In Part 2...
  • Blog Post: Managing Schema Changes (Part 1)

    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. While SQL Server 2005 supports the changing...
  • Blog Post: How can SQL Server 2005 help me evaluate and manage indexes?

    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 maintenance vs. its benefit? ...
  • Blog Post: How can SQL Server 2005 OnLine Piecemeal Restore improve availability?

    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, manageability, availability and recoverability...
  • Blog Post: Obtaining Statement-Level Query Plans

    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 makes available the query plans and SQL text...
Page 1 of 1 (19 items)