Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

Browse by Tags

All Tags » Manageability &... » Development & Programming   (RSS)
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 Read More...
New Best Practices Article
Scale-Out Querying with Analysis Services Using SAN Snapshots Read More...
Check out the exciting new SQL Server Best Practices website.....
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...
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 Read More...
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. Read More...
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 Read More...
Page view tracker