Business Intelligence, Data wharehousing and Microsoft SQL Server services for BI Impelmentation SSIS , SSAS , SSRS
The wait is over. SQL Server 2008 has been released and is ready to deliver
TechNet Plus subscribers can find
RTM versions now available for download.
Be aware when you deal with the nvarchar(MAX) as a source data for the SSIS OLE data Source as in the large number of data the temp files couldn't be generated so the migration fails. i had a case with 48 columns nvarchar(MAX) with 45000 rows and the migration failed. but converting them to 50 length it worked...!!!
instead of profiling if you want to know just the services that runs currently on the Engine. choose the database master and run in the query editor " exec sp_who" this will list for you all the running activities with it's status on the server now
Finally,
The SQL Server 2008 is RC0 but available so far only on the MSDN and technet subscribers
http://reddevnews.com/news/article.aspx?editorialsid=9946
well, SSIS is the most critical stage in developing a Business Intelligence Project. so tips is always important. have a look on this
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1282913,00.html
when you try to empty the whole table especialy in SSIS DON'T use delete from [Table] cause it takes time untill the query runs and delete the whole table instead use Truncate table [table] cause truncation empty the table at once
Jun 8th microsoft CTPed SQL Server Katmai, with main feature of Polices and how to enforce polices on databases.
we are waitting for CTP2 will be released this month.