Recent content by sqlsadie108

Are you on 2005?

Thanks much I used the OPTION (MAXDOP = 1) hint and it didn't do one iota of good. Yes, no more CXPACKETs, but the query still runs terribly... please see my other post under Programming

Hi, How and where do I apply the WITH (maxdop=1) hint to an update stmt? I am looking for the correct syntax. example - similar to my query in structure) UPDATE myTable a SET col1 = x, col2 = y, col3 = b -- complexity hidden FROM myTable b LEFT JOIN anotherTable... Thanks much

Hi, SQL Server 2005, SP2, 32 bit, 4 processors Stored proc runs and never finishes... I am seeing a lot of CXPACKET wait times on an UPDATE statement in a stored procedure. Research on the internet seems to point to poor usage of parallelism among the processors, or something to that effect...

Thanks SQLBill, et al So you're saying that I should 1.) apply the fix to SP2 already installed, 2.) then get the critical update from (http://go.microsoft.com/fwlink/?LinkId=85124) yes?

shoot, i installed the one from 2/7 should i bother downloading the one from ptheirault's link and re-do?

thanks mrdenny as it turns out, it just works so i don't really need to be 100% clear on how it works right now

Hi, The Microsoft web site gives 3 choices of SP2. I have no idea which version is the correct on for our server. Can someone please explain to me how I can determine which service pack to download? THANKS SQLServer2005SP2-KB921896-IA64-ENU.exe SQLServer2005SP2-KB921896-x64-ENU.exe...

Hi, I realize I am confused. Posted are seemingly 2 different methods for putting the pkgs on SQL Server. Which one should I do?

Hi, just trying to "quickly" figure out what this batch file is doing... I think it's putting a time stamp on some files, but I don't get the "FOR %%A IN (0 1 2 3 4 5 6 7 8 9)" part. Thanks much REM Use ERRTIME.EXE for a sorted date (or time) in MS-DOS 7.* ERRTIME -y > NUL FOR %%A IN (0 1 2 3...

Is there any advantage to storing the pkgs as files or on the server? That is, why would one choose one over the other? I suppose if the pkgs are on the server, you can back them up easily when you back up the msdb db, which would be one small advantage. But are there arguments for either or?

Thanks for the info, also seems like at some point microsoft will phase out support for DTS packages, yes? Although that could be a while down the line. Does anybody know?

so you're saying that .net is the way to go? aren't there equivalent tasks in ssis, for example, to perform data validation? you would think so, since they microsoft went thru the effort of removing active x tasks in ssis

i did not realize there was an sp2 for sql server 2005 out thanks for the tip!

Hi, I am converting several DTS pkgs to SSIS. Several of the pkgs contain complicated "Active X script" transformations on text files. That is, it would take me a long time to have to re-write this! In the meanwhile, do you think it's just best to use the EXECUTE DTS 2000 task until I have a...