Viewing 15 posts - 226 through 240 (of 285 total)
If am wrong, please correct me.
Actually as I mentioned, am not able to see parallelism in any of my servers other than in my production. However I am not able...
March 21, 2011 at 7:29 am
Please find the plan as attached.
This is a cached plan....
March 21, 2011 at 7:14 am
DOP setting is 4. We do not wanna set to 1 as am not finding any other occurances. Even I find something, I will try to make not to happen...
March 21, 2011 at 6:51 am
Thanks for your reply!!!
However, still not clear on the descrepancy of the results. Could you please correct me if my understanding is wrong...
March 18, 2011 at 9:47 am
Thank you Gail!!! It is clear now.
However a question behind is the change is applicable for the SQL version or its compatibility. In my case, Compatibility is 80 on...
February 28, 2011 at 11:05 pm
Actually, we had a trigger which used to pull data from one db to another db using Service Broker. We changed currently the entire architecture as if we found critical...
February 28, 2011 at 9:20 pm
Okei, In Paul Randal's blog, he mentioned for SQL 2005 or behind, they changed the way the trigger working. But I could not find how it works.
I would really...
February 28, 2011 at 6:31 am
Could you plese check the below link and correct me where I interpreted wrongly...
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/10/27/1248.aspx
February 28, 2011 at 6:11 am
Thanks for your comment!!!
Am really looking for an answer or confirmation as how the disabling of a trigger is working. As I mentioned, is this the way that it will...
February 28, 2011 at 5:59 am
Ohh my bad....Thank you for the correction.
February 21, 2011 at 1:32 am
Now am clear, Thank you very much!!!
February 19, 2011 at 11:49 am
Sorry for the incorrect usage "Issue" . I meant, if we are adding ROWID to eliminate the uquifier in the non clustered index(because of non uniqueness in clusterd index), the...
February 19, 2011 at 9:55 am
Viewing 15 posts - 226 through 240 (of 285 total)