Microsoft SQL Server

Effective ways for retrieving millions of records from a table?

I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each. Software/Hardware used: SQL Server

Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this? ...

Why should I use SSAS for Predictive Analytics?

We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us? Software/Hardware used: SSAS 2008, Microsoft SQl Server 2008, Windows Server 2008

Does something similar to Oracle's optimizer hints exist in SQL Server ?

In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?