Viewing 15 posts - 8,191 through 8,205 (of 18,926 total)
... done.
February 17, 2010 at 7:32 am
nevermind... I saw his other "questions" from this morning...
if you can waste time posting why not use google!!!
February 17, 2010 at 6:56 am
Wow you guys look like a***** right now...
I'm glad to not be a part of this anymore!
It seems like a legit question to me. If you think this is...
February 17, 2010 at 6:54 am
Never heard of that being possible.
The only close possibility is to use replication of the db to a 2nd instance.
However since more than 1 application can connect to the same...
February 17, 2010 at 6:52 am
I'm sure gail will be able to complete my answer with usefull code... but make sure you update ONLY the stats that needs to be updated.
That way you probably cut...
February 15, 2010 at 2:49 pm
I'm working with a world class erp (ms dynamics Nav). And it handles all the integrity stuff in the application. As far as I can tell it's bullet...
February 15, 2010 at 6:52 am
FK is for dri which means only integrity of data. On the other hand, having unique constraints (for the parent table) will help the optimizer pick a faster plan...
February 15, 2010 at 6:15 am
Cut down further to what? 4 ms to call a sp is pretty darn fast and you'll never get any complaints about that.
From then on assuming you may need...
February 15, 2010 at 3:49 am
Lynn Pettis (2/5/2010)
Ninja's_RGR'us (2/5/2010)
How about not enough ram to process all the data?
I can keep on guessing but we need more info!!!
Xml Execution plan would...
February 5, 2010 at 11:31 am
How about a simple lock?
How about not enough ram to process all the data?
I can keep on guessing but we need more info!!!
Xml Execution plan would be nice.
February 5, 2010 at 10:18 am
Good catch... but it's only true if we're seeing the whole picture... it's rare that we have the real query here. Quite often we are missing columns in the...
February 5, 2010 at 7:32 am
Any way to compile the reports every day or every few hours and show the saved version?
If not you can always look at replication on a dedicated server than can...
February 5, 2010 at 7:03 am
Not enough info to help you significantly.
What error are you getting?
What are the expected results?
What are the current results?
What is the table definition?
What data do you have in thsoe tables?
The...
February 5, 2010 at 6:58 am
Joy Smith San (2/3/2010)
February 3, 2010 at 2:32 am
Viewing 15 posts - 8,191 through 8,205 (of 18,926 total)