todd_bulky's Q&A profile

• SQL Server SQL Server 2005 queries not using correct indexes

  Hi, I'm running into issues where SQL Server 2005 SP1 queries are not using the best indexes. A query with nested subqueries runs in 1 second and performs about 400 logical reads on TblA in the DEV environment (dual proc server). The same query takes 8 seconds and performs 180423 reads on TblA on the production server (quad proc server...basically a lot better in terms of hardware). The 2 databases have the same schema and same data. I've updated stats w/full scan on this table in PROD and issued a sp_recompile TblA. No change. If I provide an index hint on PROD, then the query runs the same way it does on DEV (413 logical reads and runs in under 1 second). Is there any way (other than by using index hints) to resolve this iss ...Show All

• SQL Server How can I get value of XML element from XML column

  I have one simple question. How can I get scalar value of en XML element from XML column ... <tag> value <tag/> ... I wont to get a result: "value" Don't forget the : exec sp_xml_removedocument @Id It is an alternative. I'm currently looking at code to try and determine whether the .nodes methods available are faster/the same/slower than OPENXML. ...Show All

• Visual C# System Tray Icon with background processes

  Hello Background I'm writing a system service style application. It consists of a NotifyIcon in the sys'tray that has several functions that are called from the ContextMenu / Event s. When the app' starts it should do nothing but sit there until the 'Start Sending' MenuItem 's Event is called. This event starts a new Thread which checks a file repository between Thread.Sleep(15*60*1000) . Problem To cut to the chase, the application is maxing out the cpu usage during a loop: while ( this .Created){ Application.DoEvents();} How to I prevent this excesive usage Do I need to access the System Idle Process This usage doesn't actually halt the server or even slow it down it just capitalizes the usage as there is no ot ...Show All

• .NET Development Reading XML from a file

  Hello All, I have the example XML file here: < xml version="1.0" > <catalog> <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description>An in-depth look at creating applications with XML.</description> </book> .....<HEAPS MORE BOOKS HERE> All I wish to do is read it into some data structure that maps the TAG . I have been told there are many ways to do this... Ive tried using XmlTextReader and this has been plain confusing - it parses line by line and onl ...Show All

• .NET Development poor oracleclient performance (System.Data.OracleClient)

  Hi all, We are just about to migrate our applications from .NET 1.1 to the 2.0 version. Unfortunatly we experience a quite big performance loss in executing database queries in the newer infrastructure. While investigating this I compared a maximum simple (no external libs, just the MS supplied Oracle Client and my simple SQL) 1.1 exe with a most simply 2.0 exe and experienced even after hitting the button multiple times so that internal data caching of the driver, etc.. can be active, a performance drop around 50%! It’s just simple SQL (SELECT * FROM table WHERE ID>10000) against a Oracle 9 Database filling a datatable that is significantly slower (6 secs come to 15 secs, 4 seconds come to 6 seconds of execution time) than on the 1.1 ...Show All

• Visual C++ mixed project help

  greets, i have a bunch of unmanaged code (c++/atl/com) that i was having an issue with creating a c# remoting service, so we've decided to write a new service in c++/clr and include our unmanaged objects (thank god i found out that c++/clr is able to use the include directive, woot).. anyway, i included the same things that the other service was including, but i'm getting weird stuff like this: 1>c:\program files\microsoft visual studio 8\vc\platformsdk\include\servprov.h(93) : error C2872: 'IServiceProvider' : ambiguous symbol 1> could be 'c:\program files\microsoft visual studio 8\vc\platformsdk\include\servprov.h(48) : System::IServiceProvider IServiceProvider' 1> or 'c:\windows\microsoft.net\framework\v2.0.50727\ms ...Show All

• Visual Studio Designer not saving a property change

  Hi, I have created a component. The component has a property which is an array of strings. If I modify this array in the property browser window then the VS designer notes that I have changed the property and saves (serializes) the changes. However if I change the string array in the component code the VS designer does not realize that the property has changed and does not save it. It seems I need to make a change using the property browser in order to ensure my changes are saved. Any ideas or comments Joe Thanks Carlos, That did the trick. Did I miss documentation on this somewhere and also do you know why this method works Thanks, Joe ...Show All

• SQL Server SSIS web service task input parameters

  There is not a way to pass parameters to input of Web Service tasks. I heard this problem is fixed with SQL2K5 SP1 and even the online doc says that one can choose either "value" or "variable" when specifying input for web service tasks, but after I installed what-I-think-is SP1, there is still no way to do this. If one can only specify values (hard-coded) as input to web service tasks, then this would be a very severe limitation. I hope I'm wrong, so could someone please give a pointer. Thanks Kevin Le SP1 can be found at:  http://www.microsoft.com/sql/sp1.mspx .  Which will take you to the path that you mentioned.  If you're unable to view the variables option aft ...Show All

• Audio and Video Development HVDVD_TS

  What does the HV in HVDVD_TS stand for Early versions of the spec referred to both HDDVD_TS and HVDVD_TS in different places, clearly someone was confused. Subsequent versions switched to HV- consistently, which I agree is counter-intuitive. ...Show All

• Visual Studio 2008 (Pre-release) Problem Hosting WCF Service on IIS

  Hi all I have a service that Is currently hosted on IIS. it has the foolowing web config file < xml version = " 1.0 " encoding = " utf-8 " > < configuration xmlns = " http://schemas.microsoft.com/.NetConfiguration/v2.0 " > < connectionStrings > << system.serviceModel > < services > < service behaviorConfiguration = " MyServiceTypeBehaviors " name = " DealEntryService.MisysDealEntryService " > < endpoint address = "" binding = " wsDualHttpBinding " bindingConfiguration = " WSDualHttpBinding_IChat " contract = " DealEntryService.IDealDataEntry " /> &l ...Show All

• Visual Basic Printing ??????

  I hope I'm asking this in the right place, I need help understanding how to setup and show a printpreviewdialog. I'm new to programing unless you count 2 months of self training, anyway... I'm trying to basically print the data that I display in a datagridview, the datagridview show the data exaclty how I would like to see it on paper, I've been all over trying to get an understanding of how to create a printpreviewdialog, but I'm Lost, Please someone show the place to find something that will help me to understand I thank you in advance......... Nightman28, According to your question, I remmend you to use the PrintDocument class. 1. Export the dataset into a text file. I suppose your data is stored in an XML file a ...Show All

• SQL Server SSIS Parallel processing of packages

  Hi, I am facing some problem's while using the FOR loop container to execute 7-10 packages in parallel. The main package has 7 FOR loop containers say F1-F7. Each FOR loop container has 2 task's T1==> exec child package C1 T2==> exec delay task Delay1. The idea is to run child packages c1-c7 in parallel ...delay for some time and then run again since there are in the FOR loop container. I am facing someproblems. 1. The execution of tasks T1-T7 is not guranteed. This means SSIS picks up any 6 tasks of T1-T7 randomly to start with. 6 is the max it processes whereas i have more than that. Can i change this setting 2. Its not guranteed that if say Task t1 of FOR loop F1 is executed the subseque ...Show All

• Software Development for Windows Vista How to Track StateMachine Workflow in Database?

  1. I tried to modify the Hands-On Lab Sample "Hosting Workflows to a StateMachine Workflow" from Sequtial Workflow to a StateMachin one , but it didn't work, the Sequntial one worked fine, and when i changed it to a StataMachine one, then the database stored nothing, and TryGetWorkflow Method always return null. Is there anything different between storing Sequntial Workflow and StateMachine one 2. If the question above resolved, can I get the running Workflow's current state's allowed Events like the Property stateMachineInstance.MessagesAllowed in Hands-On Lab Sample "Creating State Machine Workflows" 3. How to store WorkflowRuntime itself in Database and get it by somethine like Application Guid later ...Show All

• SQL Server Default values of columns not transferred in SSIS Transfer Objects Task

  I am working on a project that is creating a new application, my area of the project being the migration of data from the old application database, transforming it, and populating the new database. The transformations to the old data are done in a staging database. At the end of the process, the staging database ends up with a lot of new applications tables, populated with the migrated legacy data. We need to move these tables from the staging database to (initially) our test databases, but ultimately what will be the live database. We have tried using the "Transfer SQL Server Objects Task" in SSIS, but have ran into a problem that a lot of the database tables have default values for columns. These default values a ...Show All

• SQL Server problem on loading data to db2 destination using oledb in ms-ssis.

  hello i am performing the ETL on the as400 db2 database using ms- dts,ssis. i have built the connection b/w as400 and source to extract data from as400 to staging means in dataflow . when i have built the oledb connction for loading data to destination as oledb destination.then it will connct successfully to the db2 as destination but when execute the task then it not load data , and give provider error. what can be good solution for this. can u solve it. rep plz. You mean, your source and destination are AS400 DB2 I have no experience with DB2, but if you provide more details of your package (provider used in the OLE DB connection, error received) you will be more likely to get an answer. ...Show All