Viewing 15 posts - 16 through 30 (of 36 total)
Fergusson,
have you had a look at the query plan when the "compile" time was so long? It must have been a litte complex, but try to check if it used...
November 6, 2003 at 7:15 am
Ludo, I haven't analysed your comnplete work, but three things came to my mind which may be helpful:
1) Split your Transactions into smaller chunks, so you can commit multiple parts....
October 16, 2003 at 2:05 am
Sorry, but I am confused by your code. Maybe I am just used to a different syntax, maybe this is the reason for your problem: To me it seems you...
October 16, 2003 at 1:55 am
What makes the query so complicated that you can not use index hints? If it is complicated, how does a simple query behave ? Is it slow or fast if...
October 16, 2003 at 1:41 am
Thank you all for your help. I have ordered the 10K Disks and asked my dealer for info on the write-cache-enabler. Seems to make sense to invest <500$ since the...
October 16, 2003 at 12:50 am
why are you so hungry for a bigint? You can have an ID which spreads over two columns.
October 13, 2003 at 10:15 am
dplittle, have you had any success so far?
Two things came to my mind when looking at your code:
1) your WHERE clause is weak, i.e. the "like" part does not...
October 13, 2003 at 10:06 am
loks like your tables do internal restructuring after the delete. What are your Indexes and their fillfactors ? I would experiment with different values for the fillfactor on the clustered...
October 13, 2003 at 9:52 am
quote:
I was able to solve this message in one instance by increasing the amount of time in the login time-out (seconds)
August 14, 2003 at 7:08 am
quote:
This doesn't return the state in a quick enough manner to the slower PC's to allow EM to know that everything...
August 14, 2003 at 5:14 am
quote:
When I try to connect to the server in EM, I get the following message:The SQL Server \\servername is not known...
August 14, 2003 at 1:53 am
quote:
IMHO it is better to investigate why the optimizer preferred the clustered index to the index that you felt was more...
May 2, 2003 at 1:02 am
quote:
is it possible the query using the substing(30) might cross a line from using RAM to using HDD for storage?
May 2, 2003 at 12:41 am
rickzan,
I suspect your varchar-column runs across some kind of page-border when you change the substring from 20 to 30 characters. This may make a comparison more difficult for the server...
April 30, 2003 at 10:43 am
I remember our developer group trying the same thing about 5 years ago. They just wanted to avoid the overhead of transaction logging where it's not really necessary. After a...
March 10, 2003 at 2:48 am
Viewing 15 posts - 16 through 30 (of 36 total)