SQL Server Perceptions - SQL Server 2000

SQL Server 2000

DTLoggedExec v 0.1.3.2 Released: After a while I've realeased a new version of DTLoggedExec, the DTExec replacement: Compiled to support 32bit and 64bit platforms (32bit and 64bit executables are available in the zipped file) Updated the ConsoleLogProvider to add a more detailed logging of OnError events. Now all properties, along with related connection properties of the erroneous task are logged. This is IDEAL for post-mortem debugging Corrected a little bug that prevented the abilility to load packages from SQL Server using SQL Authentication Display loaded package version Added Help File Added Samples Packages Added Usage Samples More info and download on CodePlex!; posted @ Tuesday, June 05, 2007 9:27 PM | Feedback (0)

Beware! SELECT TOP is BUGGED!: Yes it is true. And this bug has just been discovered by me and confirmed by the Query Optimizer Project Lead (Conor Cunningham) himself, that i have the chance to meet at SQL PASS 2005. He has been very kind and after I exposed the problem to him, after a little bit of suprise :-), in few days he confirmed that in some circustances SET ROWCOUNT, which is deprecated, is faster than the usually better SELECT TOP. You can test it yourself, downloading the script right here. I must say that the problem only shows when you need to limit the rows...; posted @ Friday, October 21, 2005 1:35 PM | Feedback (10)

New Sql Server 2000 Agent Article: A lot of people mail me question about problem with sheduled DTS Packages. This article should explain *clearly* and *finally* which account is used to run job steps: http://www.davidemauri.it/dasBlog/PermaLink.aspx?guid=bb70884a-32c8-4124-a0ab-4a33ba6d186d Update: As requested the article is also available here: http://weblogs.sqlteam.com/dmauri/articles/6914.aspx; posted @ Thursday, June 30, 2005 4:26 PM | Feedback (1)

Article Categories

Archives

Post Categories

Various