Viewing 15 posts - 1 through 15 (of 42 total)
Does anyone have any input on this?
April 10, 2012 at 6:53 am
It looks like a no for this then?
Perhaps a slightly different question then: What do you use to replay a load with realistic timings against a database? Are there better...
December 19, 2011 at 6:07 pm
A belated thanks for the feedback. The developers feel it is an auto-generated query (they wern't sure). I've set up a more detailed session next week to review all the...
December 15, 2011 at 7:50 pm
Hi Paul, thanks for pointing me in a few directions. As far as I know this is an auto-generated query but I will be meeting with the developers today to...
December 14, 2011 at 4:39 am
My question is simply why would someone use a tablockx hint as was done in the query I gave.
My comment about READ COMITTED isolation was because I do not...
December 13, 2011 at 8:06 pm
I've seen data migration projects do this where you were generating a new lookup table for migrating many environments into one. Each environment would get a seed number and then...
June 25, 2011 at 9:29 pm
No, the Internet didn't really turn up much for me either unfortunately. Thanks for your comments, I'll bump this up on Monday and see if anyone else has any input...
June 25, 2011 at 3:36 pm
You sold me the rights to use your software. I can't resell it, but I'm damned well sure I'm not going to let it blindly thrash around in my...
June 25, 2011 at 10:20 am
Thanks, but really not what I am asking about.
For anyone else not sure what I am talking about take a look here: http://msdn.microsoft.com/en-us/library/ms190768.aspx
I'm talking about potential performance issues of...
June 25, 2011 at 1:37 am
Jayanth_Kurup (6/24/2011)
http://msdn.microsoft.com/en-us/library/aa214297%28v=sql.80%29.aspxRead this for a better understanding on collation
Thank you, but I think there is a misunderstanding on what I am asking, perhaps this is my fault. It is not...
June 24, 2011 at 2:48 pm
Does anyone else have any input?
June 24, 2011 at 12:37 pm
Jayanth_Kurup (6/24/2011)
June 24, 2011 at 4:01 am
Before I ran it this morning I put a clustered index on field2. However the client doesn't think it needs to do this now so this is on hold for...
May 5, 2011 at 12:18 pm
Here is the table def for the table inquestion including indexes. The query is still chugging away on 300,000 rows after 45 mins. Any suggestions on how to speed this...
May 5, 2011 at 5:43 am
Yes I thought about the filter on field3 after I posted that, I think you are right. I think I may have left out the field1=0 from my first reply...
May 4, 2011 at 5:18 pm
Viewing 15 posts - 1 through 15 (of 42 total)