Showing posts with label SQL Server 2005 New Features. Show all posts
Showing posts with label SQL Server 2005 New Features. Show all posts

SQL Server 2005 : What's New in ADO 2.6

›
ADO MD CubeDef.GetSchemaObject Method ADO MD objects can now be retrieved using unique names, as specified by the UniqueName property. The n...

LINQ to SQL Statements Select with a Where Clause

›
public void SimpleQuery3() { DataClasses1DataContext dc = new DataClasses1DataContext(); var q = from a in dc.GetTable<Or...

simple LINQ to SQL statement

›
public void SimpleQuery() { DataClasses1DataContext dc = new DataClasses1DataContext(); var q = from a in dc.GetTable<Ord...

SQL Server Performance Tips and Guidelines

›
• As a common practice, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that...

Summary of new or improved features in SQL Server 2005

›
High Availability Failover clustering and database mirroring technology in SQL Server 2005 enables enterprises to deliver highly reliable, a...

Top Features for Business Intelligence in SQL server 2005

›
Analysis Services With SQL Server 2005 Analysis Services moves into the realm of real- time analytics. From scalability enhancements to deep...

Top Features for Development in SQL server 2005

›
Hosted CommonLanguage Runtime With SQL Server 2005 developers can create database objects using familiar languages such as Microsoft Visual ...

Top Features for Database Administration in SQL server 2005

›
Database Mirroring Extend log shipping capabilities with the database mirroring solution. You will be able to use database mirroring t...