Viewing 15 posts - 3,301 through 3,315 (of 7,429 total)
Make sure you have proper indexes and you should be just fine. It would be better to look at spanning drives before splitting tables if you can but unless you...
February 27, 2003 at 5:10 am
It can if you have it set to scan all files. Make sure MDF, NDF, LDF are on the exceptions list and you shouldn't see much impact if any.
February 25, 2003 at 4:21 pm
Yeah, they lack a lot of detail. Just enough to make you read the patent statement but it still makes no sense as to what pieces specifically are in question....
February 25, 2003 at 4:19 pm
I have not run across this issue. But QA and EM function normally on machines where Client tools are the only thing installed. Also, SP3 has not caused me any...
February 25, 2003 at 4:07 am
I will try to give more details tomorrow. But in my personal preference I would move even beyond Option 2 and create a SQL Stored Procedure then use adCmdStoredProc as...
February 24, 2003 at 6:42 pm
There is always
http://www.sql-server-performance.com
http://www.planet-source-code.com
http://www.experts-exchange.com
many of these are light on the SQL side and are good forum resource lookups. Many also have links to other sites that are usefull. But all...
February 24, 2003 at 6:02 pm
I fully agree, my only issue is this is a realtime app so those support tables (which are small and used very often) have to be accessed as quickly as...
February 24, 2003 at 5:52 pm
Interesting option there Greg. My only concern with Table variables would be say you need the middle value or some other variant on an extremely large table. You would then...
February 24, 2003 at 5:50 pm
I just tried and had no issues.
Run
SELECT * FROM AppLive..sysfiles
to verify the filename as well. But the syntax causes me no issues.
February 24, 2003 at 4:50 am
Ok, both SQL 7 and SQL 2000 have the option built in to audit logins in the Server properties. The only reason not to use those is if you do...
February 24, 2003 at 4:46 am
I would say with the fact you state
quote:
It works normal after I reboot the server.
February 24, 2003 at 4:25 am
I would also add remove any Foreign Key constraints and do checking in your code. This will make it harder to understand table interactions. Relationships are dead giveaways. But of...
February 24, 2003 at 4:10 am
quote:
Doeas anybody know if Litespeed is able to work together with other backup softrwares, like TSM (Tivoli Storage Manager)?Actually we have a...
February 24, 2003 at 3:58 am
Liked it very much, spoke to the gutarist in me searching for that Platinum album. I personally have met and dealt with (a few severly) those who yell I am...
February 23, 2003 at 6:20 pm
How are they reaching the IIS box? Their netowkr may be slow outside of the two together and thus the client has a wrong perception. Use trace options to generate...
February 23, 2003 at 6:09 pm
Viewing 15 posts - 3,301 through 3,315 (of 7,429 total)