Browse by Tags

SQL Server Web Edition - What is this new edition?

Published 26 September 8 2:27 AM | SqlServer-QA.net

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's...

Filed under: sql server, high availability, web, data mining, intelligence, reporting services, business intelligence, integration services, data warehouse, scalability, editions

TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300)

Published 3 August 8 8:37 AM | SSQA.net

Event: SQL Server 2008 Performance and Scalability Technologies Level: 300 SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize...

Filed under: sql server, performance, webcast, enterprise, support, events, scalability

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Published 2 May 8 9:12 AM | SSQA.net

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...

Filed under: sql server, performance, ssas, features, 2008, whitepaper, Analysis Services, scalability

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability