Viewing 15 posts - 4,381 through 4,395 (of 7,429 total)
quote:
Overall, do you think that it would be faster to complete the delete from tSecondaryStagevia method 1:
1.) delete from tSecondaryStage where ID...
November 7, 2002 at 4:01 pm
Just ignore that peice. I was thinking thru all the constraints and that is usually a trigger thing. I use references to control tables where they have a set range...
November 7, 2002 at 3:52 pm
No data files do not make reference or have have references in the Registry. SQL does have a reference to master data and master log that is stored in the...
November 7, 2002 at 3:49 pm
Have you try DBCC CHECKTABLE, could be damaged in some way. More info available in SQL BOL.
November 7, 2002 at 3:43 pm
quote:
a) What are the performance ramifications, if any, of having to use triggers to enforce common data integrity across multiple databases...
November 7, 2002 at 3:04 pm
Actually I think you issue is the nature of dealing with DELETE statment more so.
Bulk Insert will not be logged to the transaction log so the process will go...
November 7, 2002 at 2:57 pm
I preferred the shared approach. Common data can be best handled that way while still allowing you to generate table names for specific applications that make since. For instance an...
November 7, 2002 at 2:47 pm
Ok, I cannot test tonight but will try to in the morning when at my COmputer at work.
November 7, 2002 at 2:42 pm
Does it happen in EM or QA. If not then can you post an example of the code behind the ASP page? Also, have you looked at the execution plan...
November 7, 2002 at 2:41 pm
I may have confused you here.
When you reinstall SQL you can safely move the data files into place. They do not care about the registry settings. SQL only requires the...
November 7, 2002 at 2:37 pm
Ok, so let me make sure I understand. You app runs a stored procedure, this procedure in turn runs the package?
November 7, 2002 at 2:33 pm
Seems you are the only person to catch this, noticed your post on SQLMag forums as well. I don't believe there is a setting, I am pretty sure SQL does...
November 7, 2002 at 2:30 pm
Another way you can do it is to a DTS package file.
Saw this in another thread last night and started to script it to generate and run against all my...
November 7, 2002 at 2:15 pm
Backup. Your first query would result in a cartesian table as a result of a full join. You have no information explaining how the tables themselves relate, this is why...
November 7, 2002 at 2:10 pm
No idea yet, I have not tried this. Can you post an example of what the application code so I can see what you are doing. Or maybe some else...
November 7, 2002 at 2:00 pm
Viewing 15 posts - 4,381 through 4,395 (of 7,429 total)