Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Maim
  • Order by date
  1. Maim

    Replication issues (sql server 2005)

    Yeah, medenny, I was hoping not to have to run the change scripts manually but there doesn't seem to be any other choice... hehe. Gotta love the job :D ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof...
  2. Maim

    Replication issues (sql server 2005)

    Hi, We have a pretty large database with Transaction Replication to a secondary server (pull subscription). Some tables are starting to get pretty large so I want to partition them. On some tables, I have to recreate the primary keys with a new column used for the partition schema. The...
  3. Maim

    Extremely slow delete

    Ah, sometimes we overlook the simplest things! I was rechecking the indexes on the child tables and noticed the clustered index was created as a covering index (3 fields) with the aforementioned foreign key. So what happens when the foreign key runs its check? It won't use the index fully...
  4. Maim

    Extremely slow delete

    I'm deleting the children before deleting the parent records. Nonetheless, it still runs a clustered index scan on the child records when deleting the parent. Do you know of a way to force index use on foreign key checking? Incidentally, I ran some tests on my beta db. with foreign key on the...
  5. Maim

    Extremely slow delete

    Hi, The child tables have ParentValID as a clustered index. Should the index be switched for a non-clustered one? Thanks ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe...
  6. Maim

    Extremely slow delete

    Bump! Anyone? ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rich Cook
  7. Maim

    Extremely slow delete

    Hi, I have a table (ParentVal) with four child tables (ParentValA, ParentValB, ParentValC, ParentValD) each with foreign key constraints. ParentVal has 15000 records ParentValA has 1000000 records ParentValB has 2000000 records ParentValC has 15000000 records ParentValD has 30000000 records...
  8. Maim

    Adding files/filegroups to server - what's the best way?

    I'm wondering if I'm going about this correctly... I have a data file on the PRIMARY filegroup located on drive H: (100gb 1/0 etc...) The data file is getting close to 100gb so I had IT add another drive to the server. What I want to do is stop the growth on the H: drive and start writing to...
  9. Maim

    xml modify, any way to check attribute exists before inserting?

    I have a record with an xml data type field. The value starts out raw, basically just a "<mynode />". I also have some procedures that handle related records (in the thousands) and it checks whether to perform taskA or taskB and add an attribute to the xml. Does the xml dml have some way of...
  10. Maim

    Stopping the debugger crashes the IDE

    Yup, and it also makes the IDE disappear or lockup on occasion. Wierd hunh? Also, source control is enabled with VSS, maybe this has something to do with it? There isn't anything in the event viewer for this either. ----------------------------------- &quot;Programming today is a race...
  11. Maim

    Stopping the debugger crashes the IDE

    Hi, I'm running this fairly large web project (aspx/c#) on VS2003. The issue I'm having is when I debug and attempt to stop debugging, two things can happen... 1. The IDE disappears as if I clicked on the X instead of just the "stop debugging" button. 2. When the IDE doesn't disappear (after...
  12. Maim

    importing vb ActiveX,, CreateInstance returns &quot;Class not registered&quot;

    IonFilipski, thanks for all your suggestions but I figured out what was failing after having the olap guru check the references in the vb dll. Seems this dll calls SQLDMO (for olap processing) by CreateObject rather than a reference so the linking fails at runtime because I don't have those...
  13. Maim

    importing vb ActiveX,, CreateInstance returns &quot;Class not registered&quot;

    That's not it. The class name is correct in the registry and it has the correct Clsid (HKCR\CLSID\...) ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce...
  14. Maim

    importing vb ActiveX,, CreateInstance returns &quot;Class not registered&quot;

    That's not it. I thought that perhaps there were other of the same dlls elsewhere so I searched the HDs to delete all files (only one) I found except the one in the vb directory (binary compatibility), I ran regsvr32 /u dll, scrubbed the registry for the classes, recompiled, ran regsvr32 dll...
  15. Maim

    importing vb ActiveX,, CreateInstance returns &quot;Class not registered&quot;

    I'm maintaining some legacy code that doesn't seem to work correctly... An ActiveX dll was created a while ago in VB6 to process some data in the database. This dll is imported into a VC++ (visual studio .net 2003) project with the #import directive, but when it attempts to create an instance...
  16. Maim

    Is there a Microsoft Script Debugger app for ws 2003?

    Anyone? ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.&quot; - Rich Cook
  17. Maim

    Is there a Microsoft Script Debugger app for ws 2003?

    I am wondering if there's something similar to what's on 2000 that'll give me some minimal server side debugging capabilities. I don't want to install vs.net on the machines running simulated production environments but it would greatly help if I could somehow see what's going on in the...
  18. Maim

    Can't delete folder with &quot;reserved word&quot; for a name (Nul)

    Never mind, I'm copying all the data to another drive and formatting it. Thanks for the suggestions anyway. ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to...
  19. Maim

    Can't delete folder with &quot;reserved word&quot; for a name (Nul)

    Tried scripting, nothing. Tried to "net use" the drive to a machine with visual basic and use fso to delete the folder, I get "permission denied" when I run "fso.DeleteFolder pathToNulFolder, true" or "path not found" when I try to "fso.GetFolder(pathToNulFolder)"...
  20. Maim

    Can't delete folder with &quot;reserved word&quot; for a name (Nul)

    longhair: Doesn't work The ~ only works when you create a file/folder that doesn't fit the 8.3 rule. example, go to your c: drive, run dir /x, you should see: <DIR> DOCUME~1 Documents and Settings <DIR> PROGRA~1 Program Files <DIR> WINNT Notice the WINNT doesn't have an 8.3 format...

Part and Inventory Search

Back
Top