Viewing 15 posts - 8,191 through 8,205 (of 18,923 total)
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
Following those thaughts. Try downloading the reports once they are deployed to the server... I just can't find any way to do it at the moment (web access, or...
January 31, 2010 at 8:49 pm
Either that or the solution is so obvious that we totally missed it!
January 31, 2010 at 8:41 pm
amarshall-568002 (1/29/2010)
I'm using sql 2008, and as others have stated, if I do SET NOCOUNT ON and then run the queries, I get 0,1. Without it, I get 1,1.Amu
Yes...
January 29, 2010 at 6:42 am
Viewing 15 posts - 8,191 through 8,205 (of 18,923 total)