Viewing 15 posts - 9,631 through 9,645 (of 49,571 total)
rani_rahbani (3/17/2014)
I am already trying to create a dynamic trigger.
No, don't try to create triggers which use dynamic SQL to do anything anywhere. That's going to kill performance, maintainability and...
March 17, 2014 at 9:35 am
From a presentation on design I did recently:
Business Analysis/Conceptual design
Process of gathering requirements
Identify entities
Identify attributes
Identify business rules
Produces a conceptual model
Logical Design
Refining of the conceptual model
Define the full set of entities...
March 17, 2014 at 9:26 am
Jeff Moden (3/17/2014)
First, having the 80 files won't degrade performance. It won't enhance it, but it won't degrade it.
Too many data files can degrade performance. What too many is...
March 17, 2014 at 9:22 am
Books Online (the SQL help file) -> ALTER TABLE
March 17, 2014 at 8:41 am
Remove the error handling (database side and client side, since both hide the errors) and have a look at exactly what is being returned
Also try running the stored proc from...
March 17, 2014 at 8:36 am
paul.knibbs (3/17/2014)
GilaMonster (3/17/2014)
March 17, 2014 at 8:11 am
You need a script to drop the constraint and another script to enable it, then some component in your SSIS package which checks that the constraint was indeed recreated and...
March 17, 2014 at 8:08 am
altana (3/17/2014)
GilaMonster (3/17/2014)
What errors are you getting?p.s. A catch block which just discards the error is not exactly good coding practice.
I doesn't give any error.
Probably because the catch block...
March 17, 2014 at 8:05 am
What errors are you getting?
p.s. A catch block which just discards the error is not exactly good coding practice.
March 17, 2014 at 7:52 am
And does that requirement have a reason other than 'because I said so'?
You'll have to drop the constraint entirely and then hope you can add it back successfully. Be...
March 17, 2014 at 7:50 am
Switch to delete instead of truncate. Removing the constraint is risky, as it leaves a window where data can be inserted which would violate the constraint.
March 17, 2014 at 7:42 am
yuvipoy (3/17/2014)
When i delete the TableB with TableA record exists the query is taking long time thats why i came across Not Exists Vs Not IN.how about leftouter join?
Very slightly...
March 17, 2014 at 7:16 am
Siberian Khatru (3/17/2014)
assumed the log was truncated as part of the log backup procedure.
It is. Truncate means to mark portions of the log as reusable. It happens on...
March 17, 2014 at 7:15 am
I just love the way a couple of heavy IO operations turns my (5 month old) laptop into a paperweight. Busy shrinking one DB and zipping the backup of another...
March 17, 2014 at 6:45 am
Viewing 15 posts - 9,631 through 9,645 (of 49,571 total)