Another BI & Programming Blog - Jason Yousef

Just a quick note to save time over appearance and save on memory when you start BIDS or SSMS. By adding ( -NoSplash ) switch at the end. The same trick can be applied to all versions of Visual Studio and SSMS (SQL Server Management Studio) by the way.

Today I was buying a suit online from Macys when I got hit by a bizarre unmatched recommendations. Although I wasn't logged in! Right away sqlserverdatamining.com came to my mind with their  Movie!Click  example.

Declare @Date datetime = '03/15/2011' ------- Your Date select dateadd(day,( -datepart(weekday,dateadd(day,(7)-datepart(weekday,@Date),@Date))+((7)-datepart(weekday,@Date)))+(1),@Date) AS [First_Day_Of_The_Week] Select dateadd(day,(7)-datepart(weekday,@Date),@Date) AS [Last_Day_Of_The_Week]

I Recently came accross two important that I would like to share articles regarding that topic. http://blogs.msdn.com/b/mattm/archive/2011/01/15/why-does-my-package-run-slower-in-bids-than-dtexec.aspx?wa=wsignin1.0 http://sqlblog.com/blogs/jamie_thomson/archive/2011/01/12/always-use-dtexec-exe-to-test-performance-of-your-dataflows-no-exceptions.aspx Helpful Dtexec.exe cheats: To execute an SSIS package saved to SQL Server using Windows Authentication: dtexec /sq pkgOne /ser productionServer To execute an SSIS package saved to the File System folder in the SSIS Package Store: dtexec /dts "\File System\MyPackage" To validate a package that uses Windows Authentication and is saved in SQL Server without executing the package: dtexec /sq pkgOne /ser productionServer /va To execute an SSIS package that is saved in the file system: dtexec /f "c:\pkgOne.dtsx " To execute an SSIS package that is saved in the file system, and specify logging options: dte...