Viewing 15 posts - 1 through 15 (of 104 total)
This is very interesting, as it confirms something I saw and raised with Microsoft about a year ago. At the time, the UK support people claimed ignorance, however you've...
February 12, 2003 at 2:02 pm
What a load of cols...actually very useful, but tell me, have you ever seen a query plan with index intersection happening? I never did, are there any settings that...
February 6, 2003 at 5:07 am
EM uses OLE DB to communicate with the server, which ISQL doesn't. Therefore, can you use OSQL to run a simple query on the server in the DMZ? ...
February 5, 2003 at 8:08 am
Sackcloth and ashes etc. Sorry to upset the situation, I misread your suggestion on the table inserts stuff as being something frivolous.
Anyway, on the subject of memory, I agree...
February 5, 2003 at 5:03 am
Well one quick answer would be to use SUBSTRING(), or LEFT() in your SELECT statement to truncate the data you select.
February 5, 2003 at 4:10 am
I also have 1.5Gb of RAM on my desktop, but then it doubles as a development system as well. Whilst 1Gb of RAM is not much these days, there...
February 5, 2003 at 2:23 am
Well I would look at the execution plan of your top queries and slowest performing queries and take it from there. I am old-fashioned, and have an unhealthy suspicion...
February 4, 2003 at 2:44 am
Well when you say 'speed things up' this is a very open-ended request. My initial reaction is speed up from what? Do you have a perception that your...
February 3, 2003 at 2:54 pm
Can you tell us about service packs and patches that have been installed on this set-up? Have you for example enabled Automatic Updates?
Incidentally, ipecacuanha is an ingredient in cough...
February 3, 2003 at 10:19 am
Makes a change to be right!! (Don't refer to previous posts for proof of that). I'm interested in this cross db ownership chaining. Does that mean that...
January 31, 2003 at 10:13 am
Have you looked at the security settings using DCOMCNFG to ensure that Everyone can access your newly created object? I'm not sure the implications of trying this with .net...
January 31, 2003 at 9:30 am
Now the guru has gone and put a spanner in the works...doesn't this relate to the debate here a few weeks ago concerning obtaining row numbers or row id's? ...
January 17, 2003 at 10:31 am
Yes, perhaps I should have made my comments a bit more contentious to encourage a wider debate...come to think of it, what do other forum members think of my comment?...
January 17, 2003 at 9:28 am
I knew I'd get shot down in flames!! Well it was worth a try. I thought there might be a comment about the result set crossing the network... ...
January 17, 2003 at 9:00 am
Whilst not being the answer that you want, could I suggest that you firstly tell us why you need this, and then perhaps my second comment could be more relevant,...
January 17, 2003 at 8:26 am
Viewing 15 posts - 1 through 15 (of 104 total)