Viewing 15 posts - 166 through 180 (of 204 total)
Currently on the history & log tables respectivley (as they have the same structure) I am doing the following:
Clustered
Index is on the Stamp...
June 29, 2007 at 2:50 am
Hi. The reason that I drop the indexes is for performance as the HISTORY table is only used for reporting by administrators. So the only time I do any inserts...
June 28, 2007 at 7:40 am
Thanks for your advice.
Andy can I ask why you don't agree with what I am doing?
June 28, 2007 at 3:40 am
I do want to try and resolve the deadlock issue but this seemed a nice way of trying to handle it until I can find out whats causing it and...
June 4, 2007 at 5:10 am
Hi, I was using the TRY CATCH method described in this article http://msdn2.microsoft.com/en-us/library/aa175791(SQL.80).aspx which suggests that you can use TRY CATCH to catch a deadlock and prevent your...
June 4, 2007 at 3:56 am
Thanks for all your responses.
It seems splitting up the current proc into numerous different queries defeats my original purpose of writing one generic proc in the first place and...
May 24, 2007 at 6:17 am
Thanks for the responses.
At the moment the current query handles multiple types of name search.
Candidate Name: (could be empty or full name or partial name)
There is an option on the...
May 24, 2007 at 3:21 am
As I said in my previous post the table with 100% fill factor does not recieve any inserts/updates throughout the day.
Once a night I drop all the indexes, insert all...
May 3, 2007 at 8:37 am
Nope, sorry I was wrong when I said that.
I have the main log table which accepts inserts througout the day. I think the fill factor is 60% (off top of...
April 30, 2007 at 5:07 pm
I used exactly the same parameters on both Dev / Production.
The amount of data within each DB is drastically different as its a user log table that holds hundreds of...
April 30, 2007 at 9:42 am
i could do but the reason I want to reset the identity is that its almost certain that the identity col will reach its limit before long (Even with bigint,...
April 3, 2007 at 10:19 am
Rewind...scrub that
What I meant to say was that I would like the illusion of having an identity field for RecordNo seeded from 1 at the start of each day. I...
April 3, 2007 at 8:31 am
Ok thanks for both of those I will try them out soon and compare the Plans.
February 22, 2007 at 9:32 am
Yes I read that in BOL as well. But I thought you might be able to GRANT the user specific permissions just for that proc. I thought maybe theres a...
February 1, 2007 at 7:26 am
Viewing 15 posts - 166 through 180 (of 204 total)