Viewing 15 posts - 391 through 405 (of 530 total)
Kelvin:
quote:
Having a non clustered index on the date column will NOT HELP with this query. SQL probably wouldn't even use the...
November 21, 2003 at 6:06 am
BanzaiSi:
quote:
This is because ADDING an index will almost certainly not reduce performance of any existing queries
November 21, 2003 at 5:45 am
quote:
Which of the following could be done to improve performance?
happycat59: It does not speak at...
November 21, 2003 at 3:35 am
Loosing unique constraint by doing that is right, but the question was:
quote:
Which of the following could be done to improve performance?
November 21, 2003 at 3:11 am
...and of course you could directly go into Properties of the DTS package and set the Priority Class to 'Low'.
Regards, HansLindgren
November 6, 2003 at 6:48 am
P.S You must be in QA and use CTRL+L or as Chris said, turn on the Showing of the Query Plan (not estimated which you will get with the shortcut)
...
October 15, 2003 at 3:00 am
Hello everyone!
One suggestion could be to dump your records into and ADO recordset and do a BatchUpdate to a temporary table, insert the non-violating records into your Main table and...
October 8, 2003 at 9:10 am
Please stick to one Thread or atleast point out that you are posting this more then once 😉
September 30, 2003 at 3:54 am
Hello Zizo!
If I have understood it correct you have already filled the new column with arabic data on your Development server and you watn to add these columns as well...
September 30, 2003 at 3:45 am
Hi Ferguson!
Looking in BOL for executing UDFs it says that you can use the WITH RECOMPILE keywords and indicates that a new plan will be forced to be compiled. If...
September 26, 2003 at 8:07 am
Hello!
What do you actually mean by this:
quote:
All general statements are false
You are saying...
September 26, 2003 at 2:26 am
Have you looked at the execution plan? If there is alot of RIs that are not indexed in 'target' tables, there can be ALOT of table scans even if you...
September 25, 2003 at 8:41 am
Jonathan:
Thanx, I didn't think about the possibility that it might not be transaction safe.
Regards, Hans!
September 18, 2003 at 7:36 am
Hi Frank!
Thank you 🙂 I never saw that resource for what it actually is. It seems actually to be very close to what I was thinking about (maybe with a...
September 18, 2003 at 6:16 am
Viewing 15 posts - 391 through 405 (of 530 total)