Viewing 15 posts - 2,671 through 2,685 (of 7,429 total)
Most times caching will handle the job just fine as is better to allow. The tables if accessed very often will generally behaved as thou pinned without the downside of...
July 26, 2003 at 9:22 am
Well that has a lot of factors for that. Yes experience will be a big bennifit in that you can get higher placement positions. But what they may be can...
July 25, 2003 at 8:05 pm
The Sub SELECT TOP 1 gave me a bit of trouble but try this.
SELECT
tblB.[ID],
tblB.[T1xD] t1a,
tbl2a.Volume
FROM
(
SELECT
T1x.[ID],
T1x.[Date] T1xD,
MAX(T2x.[Date]) T2xD
FROM
Table1 T1x
LEFT...
July 25, 2003 at 7:55 pm
The problem with certification alone is you may get the job but when the experience fails to show thru (which you may be someone who can apply concepts in a...
July 25, 2003 at 5:09 pm
quote:
Does anyone have a reference for log error codes? My (supposedly successful) installation recorded error codes of 2 and 997 which...
July 25, 2003 at 4:02 am
With ADO and VB to keep pooling alive (means the connection is open until an expire time for any object needing that conection) only close the connection object. As Steve...
July 25, 2003 at 3:57 am
Actually I won a copy and gave it to another group. I don't use anything to constantly monitor as I have foudn the extra loads unacceptable. I have been testing...
July 24, 2003 at 6:41 am
With just SP4 it is 7.00.1063
July 24, 2003 at 4:11 am
I will say I mostly delete the EMails. I didn't even realize the answer was there next day until it was pointed out.
However, I agree with other comments made here....
July 24, 2003 at 3:26 am
But since Table Variables cannot push except to the Page File when memory is needed 1,000,000 file can be an issue and severly degrading to server performance. Table Variables are...
July 23, 2003 at 5:02 pm
I have not seen anything on .NET but I believe you are correct. However VC++ 7 (which is in .NET) can as long as you don't use the .NET framework...
July 23, 2003 at 4:59 pm
Actually a Clustered index scan is fine for all as that is what would happen. But to get the seek I would do like so
DECLARE @id...
July 21, 2003 at 5:22 am
We have 2 Oracle instances taht we hit but mostly query developement is all I do. ALthough I have a Dev copy I have used from time to time.
July 21, 2003 at 5:11 am
Please do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14358&FORUM_ID=9&CAT_ID=1&Topic_Title=Installing+SQL+Server+2000+On+Windows+2003&Forum_Title=General
July 21, 2003 at 5:09 am
I have not tried yet but I can this evening most likely. But I have not heard any specific complaints and know of two instances here that were brought up...
July 21, 2003 at 5:08 am
Viewing 15 posts - 2,671 through 2,685 (of 7,429 total)