SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Thursday, February 22, 2007

SQL Server 2005 Best Practices Analyzer

All

SQL Server 2005 Best Practices Analyzer (February 2007 CTP) is available now for Download.

Thanks
Sutha

Monday, February 19, 2007

Download Feb 2007 Books Online

There is an updated version (February 2007) of Books Online available for download.

Thanks
Sutha

SQL Server 2005 SP2 is available for download

All

SP2 is available for download now.

Thanks
Sutha

Tuesday, February 13, 2007

OLE DB Source - SQL Command

I came across something simple on OLE DB Source last week. I was using “SQL Command” as Data Access Mode. Most of source SQL statements were simple, such as

SELECT oid,baseid
FROM STG_PAS99
WHERE baseid = ?

For the above SQL I can pass a parameter without any problem.

For one reason or the other I had to write a source SQL something like this. Yes I do know that I don’t need inside parameter if I have one outside. I am using it to explain my point plus it does improve performance.

SELECT oid,baseid
FROM STG_PAS99
INNER JOIN (
SELECT MAX(loaded), oid, baseid
FROM STG_PAS99
WHERE baseid = ?
GROUP BY oid, baseid
)
WHERE baseid = ?


If I enter the above SQL into “SQL Command Text” and click on Parameters I got the following message

As the error message suggests I used the SQL Command from variable to get around that issue. If you don’t know how to do that please have a look at Jamie’s Blog

Thanks
Sutha

Monday, February 12, 2007

64 Bit Oracle Issues

One my friends has done a brilliant post on 64 bit Oracle drivers and connectivity issues. Well worth having a read.

http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html

Thanks
Sutha

Friday, February 09, 2007

One Day Maybe....

I dont like E-Bay. I think they charge too much.

Hopefully there is someone emerging in the market.

http://www.mobadoo.com/pages/home/home.aspx

Thanks
Sutha