By Robert A. Patton, MCDBA, MCSD, MCSE+I, MCP+, Jennifer Ogle, MCSE, MCP+I, MCNE, Oracle DBA, and Travis Laird, MCSE, MCDBA, A+, Network+, i-Net+, CIW (Eds.)

The Microsoft .NET initiative is the way forward for e-commerce - making it attainable for organizations to construct a safe, trustworthy e-commerce infrastructure. this is often the 1st ebook to stipulate the features of SQL Server 2000, one of many key parts of .NET. SQL Server 2000 introduces robust new information mining performance designed in particular to seize and strategy buyer profiles and to foretell destiny buying Read more...

Show description

Read Online or Download Designing SQL Server 2000 Databases. for .Net ™ Enterprise Servers PDF

Best programming: programming languages books

Essential Java Fast : How to write object oriented software for the Internet

Java is a brand new and interesting object-oriented programming language that is set to remodel the realm broad internet. Java permits clients to jot down purposes which are accessed throughout varied structures and gives a good technique of development small yet strong courses that allow a big diversity of recent purposes - resembling animation, reside updating, two-way interactions and so forth.

Designing SQL Server 2000 Databases. for .Net ™ Enterprise Servers

The Microsoft . web initiative is the way forward for e-commerce - making it attainable for firms to construct a safe, trustworthy e-commerce infrastructure. this is often the 1st publication to stipulate the services of SQL Server 2000, one of many key parts of . web. SQL Server 2000 introduces strong new facts mining performance designed in particular to seize and procedure buyer profiles and to foretell destiny purchasing styles on e-commerce websites.

Additional resources for Designing SQL Server 2000 Databases. for .Net ™ Enterprise Servers

Example text

0. N u m e r o u s e n h a n c e m e n t s a n d n e w f e a t u r e s i n c r e a s e Analysis Services usability, p e r f o r m a n c e , a n d security over the previous version. Additions s u c h as n e w c u b e a n d d i m e n s i o n types provide e n h a n c e d OLAP analysis capabilities. The n e w d a t a - m i n i n g capabilities offer a n entirely n e w level of analysis t h a t h a s the ability to find t r e n d s in b o t h OLAP a n d relational d a t a sources. Analysis Services include several usability e n h a n c e m e n t s , s u c h as Windows 2 0 0 0 Active Directory integration.

Distributed partitioned views are updateable in SQL Server 2000. Microsoft u s e d updateable, distributed partitioned view technology to achieve the record-breaking TPC-C b e n c h m a r k s we disc u s s e d early in this chapter. This technique of database partitioning and load distribution utilizes a sharednothing clustering approach, which is considered superior to shared resource clustering. Shared-nothing clustering eliminates any single point of failure in the cluster and reduces bottlenecks t h a t can occur with shared resources.

The S t a n d a r d Edition of SQL Server does not s u p p o r t availability e n h a n c e m e n t s s u c h as fail-over clustering a n d log shipping as well as p e r f o r m a n c e e n h a n c e m e n t s , including distributed partitioned views, indexed views, a n d parallel index operations. Advanced Analysis Services features s u c h as HTTP access a n d linked cubes are not available in SQL Server 2000 S t a n d a r d Edition. SQL Server S t a n d a r d Edition offers a s u b s e t of the capabilities provided by Enterprise Edition a n d offers no features t h a t are not available in Enterprise Edition.

Download PDF sample

Rated 4.58 of 5 – based on 46 votes