select *
from msdb..suspect_pages
Friday, October 15, 2010
upgrade existing SQL server 2005 standard edition
SQL Server 2008 R2 suppports backup compression, resource governor, restriction of user accessing.
What's New in SQL Server 2008 R2 EditionsWith SQL Server 2008 R2,
Microsoft continues to be the value leader, offering rich functionality to support OLTP and BI workloads out of the box at a low cost of ownership relative to competitors. With increasing hardware innovations, SQL Server continues to be the only major database vendor who does not price per core for multi-core processors.
What’s New in SQL Server 2008 R2 Editions
Built on SQL Server 2008, SQL Server 2008 R2 delivers higher mission-critical scale, more efficient IT, and expanded reporting and analytics through self-service business intelligence. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large scale datacenters and data warehouses.
SQL Server 2008 R2 Datacenter
SQL Server 2008 R2 Parallel Data Warehouse
New Premium Editions
Datacenter
Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure. Datacenter helps enable organizations to cost effectively scale their mission-critical environment.
Key features new to Datacenter:
Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances
Highest virtualization support for maximum ROI on consolidation and virtualization
High-scale complex event processing with SQL Server StreamInsight™
Supports more than 8 physical processors for highest levels of scale
Supports memory limits up to OS maximum
Parallel Data Warehouse
SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance-based solution. Parallel Data Warehouse delivers performance at low cost through a massively parallel processing (MPP) architecture and compatibility with hardware partners – scale your data warehouse to tens and hundreds of terabytes.
Key features new to Parallel Data Warehouse:
10s to 100s TBs enabled by MPP architecture
Advanced data warehousing capabilities like Star Join Queries and Change Data Capture
Integration with SSIS, SSRS, and SSAS
Supports industry standard data warehousing hub and spoke architecture and parallel database copy
Investments in Core Editions
SQL Server 2008 R2 Enterprise
SQL Server 2008 R2 Enterprise delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings—helping enable the highest service levels for mission-critical workloads.
The following capabilities are new to Enterprise:
PowerPivot for SharePoint to support the hosting and management of PowerPivot applications in SharePoint
Application and Multi-Server Management for enrolling, gaining insights and managing up to 25 instances
Master Data Services for data consistency across heterogeneous systems
Data Compression now enabled with UCS-2 Unicode support
High-scale complex event processing with SQL Server StreamInsight™
SQL Server 2008 R2 Standard
SQL Server 2008 R2 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications—helping enable effective database management with minimal IT resources.
The following capabilities are new to Standard:
Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups *
Can be managed instance for Application and Multi-Server Management capabilities
High-scale complex event processing with SQL Server StreamInsight™
What’s New in SQL Server 2008 R2 Editions
Built on SQL Server 2008, SQL Server 2008 R2 delivers higher mission-critical scale, more efficient IT, and expanded reporting and analytics through self-service business intelligence. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large scale datacenters and data warehouses.
SQL Server 2008 R2 Datacenter
SQL Server 2008 R2 Parallel Data Warehouse
New Premium Editions
Datacenter
Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure. Datacenter helps enable organizations to cost effectively scale their mission-critical environment.
Key features new to Datacenter:
Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances
Highest virtualization support for maximum ROI on consolidation and virtualization
High-scale complex event processing with SQL Server StreamInsight™
Supports more than 8 physical processors for highest levels of scale
Supports memory limits up to OS maximum
Parallel Data Warehouse
SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance-based solution. Parallel Data Warehouse delivers performance at low cost through a massively parallel processing (MPP) architecture and compatibility with hardware partners – scale your data warehouse to tens and hundreds of terabytes.
Key features new to Parallel Data Warehouse:
10s to 100s TBs enabled by MPP architecture
Advanced data warehousing capabilities like Star Join Queries and Change Data Capture
Integration with SSIS, SSRS, and SSAS
Supports industry standard data warehousing hub and spoke architecture and parallel database copy
Investments in Core Editions
SQL Server 2008 R2 Enterprise
SQL Server 2008 R2 Enterprise delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings—helping enable the highest service levels for mission-critical workloads.
The following capabilities are new to Enterprise:
PowerPivot for SharePoint to support the hosting and management of PowerPivot applications in SharePoint
Application and Multi-Server Management for enrolling, gaining insights and managing up to 25 instances
Master Data Services for data consistency across heterogeneous systems
Data Compression now enabled with UCS-2 Unicode support
High-scale complex event processing with SQL Server StreamInsight™
SQL Server 2008 R2 Standard
SQL Server 2008 R2 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications—helping enable effective database management with minimal IT resources.
The following capabilities are new to Standard:
Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups *
Can be managed instance for Application and Multi-Server Management capabilities
High-scale complex event processing with SQL Server StreamInsight™
Business opportunity
Looking for company in the Yellow pages ( which lists entries according to business type) and the White pages ( which lists telephone entries by surname or business name )
录像：视频网站独家
学校介绍， 大学，tafe中学，小学，幼儿园。培训机构。 （给中国留学中介机构,可以以中介机构的名义进行拍摄节约客户资金）
澳洲房产按照城市进行调查做报告
澳洲房产中介在国内销售房屋可以直接给客户拍摄现场资料
定制客户拍摄。
留学生工作状态，餐馆。杂货店。私人侦探。
美食之旅 悉尼各个区。 （其他区域找代理） 给东方电视台 ，地方电视台，留学省较多的省份。
选举美食小姐，逛街购物节日小姐。（网络发帖招募）。
录像：视频网站独家
学校介绍， 大学，tafe中学，小学，幼儿园。培训机构。 （给中国留学中介机构,可以以中介机构的名义进行拍摄节约客户资金）
澳洲房产按照城市进行调查做报告
澳洲房产中介在国内销售房屋可以直接给客户拍摄现场资料
定制客户拍摄。
留学生工作状态，餐馆。杂货店。私人侦探。
美食之旅 悉尼各个区。 （其他区域找代理） 给东方电视台 ，地方电视台，留学省较多的省份。
选举美食小姐，逛街购物节日小姐。（网络发帖招募）。
Thursday, October 14, 2010
Tuesday, October 12, 2010
Cost Comparison on Cursor Location
Client-Side Cursors
Client-side cursors have the following cost benefits compared to server-side cursors:
Higher scalability:
Faster scrolling:
Highly portable:
Client-side cursors have the following cost overhead or drawbacks:
Higher pressure on client resources:
Support for limited cursor types:
Only one active cursor-based statement on one connection
Server-Side Cursors
Server-side cursors have the following cost benefits:
Multiple active cursor-based statements on one connection:
Row processing near the data:
Less pressure on client resources:
Support for all cursor types:
Server-side cursors have the following cost overhead or disadvantages:
Lower scalability:
More network round-trips:
Client-side cursors have the following cost benefits compared to server-side cursors:
Higher scalability:
Faster scrolling:
Highly portable:
Client-side cursors have the following cost overhead or drawbacks:
Higher pressure on client resources:
Support for limited cursor types:
Only one active cursor-based statement on one connection
Server-Side Cursors
Server-side cursors have the following cost benefits:
Multiple active cursor-based statements on one connection:
Row processing near the data:
Less pressure on client resources:
Support for all cursor types:
Server-side cursors have the following cost overhead or disadvantages:
Lower scalability:
More network round-trips:
Cursor Type (SQL Server )
Keyset-Driven Cursors
Dynamic Cursors
Forward-Only Cursors:
1. operate directly on the base table
2. suppport DML operations
3. support forward scrolling only (FETCH NEXT)
4. Fast_Forward (forward_only + read_only cursor)
Static Cursors:
1. operate on the snapshot in the tempdb database.
2. data is retrived from the underlying table(s) when the cursor is opened.
3. support all scrolling options: FETCH FRIST, FETCH PRIOR, FETCH LAST, FETCH ABSOLUT n, and FETCH RELATIVE n.
4. read-only, changes (DML ) made to the underlying table(s) are not reflected in the cursor.
Dynamic Cursors
Forward-Only Cursors:
1. operate directly on the base table
2. suppport DML operations
3. support forward scrolling only (FETCH NEXT)
4. Fast_Forward (forward_only + read_only cursor)
Static Cursors:
1. operate on the snapshot in the tempdb database.
2. data is retrived from the underlying table(s) when the cursor is opened.
3. support all scrolling options: FETCH FRIST, FETCH PRIOR, FETCH LAST, FETCH ABSOLUT n, and FETCH RELATIVE n.
4. read-only, changes (DML ) made to the underlying table(s) are not reflected in the cursor.
JDBC and JDBC Architecture
Layers of the JDBC Architecture
Type 1 JDBC-ODBC Bridge.
Type 2 JDBC Architecture
Type 3 Java to Network Protocol Or All- Java Driver.
Type 4 Java to Database Protocol.
http://www.roseindia.net/jdbc/jdbc.shtml
http://www.roseindia.net/jdbc/understanding-the-jdbc-architect.shtml
Type 1 JDBC-ODBC Bridge.
Type 2 JDBC Architecture
Type 3 Java to Network Protocol Or All- Java Driver.
Type 4 Java to Database Protocol.
http://www.roseindia.net/jdbc/jdbc.shtml
http://www.roseindia.net/jdbc/understanding-the-jdbc-architect.shtml
Client-side VS Server-side Cursors in Microsoft world
http://msdn.microsoft.com/en-us/library/aa266531(VS.60).aspx
Subscribe to:
Posts (Atom)