Viewing 15 posts - 6,661 through 6,675 (of 7,429 total)
You mean a subselect
SELECT collist FROM (
SELECT collist FROM tableX WHERE conditions
) AS subSelTable
Which this is a bad example. Please be more specific about what you are trying to...
March 26, 2002 at 4:52 pm
Have you tried throwing multiple queries at the same time to see if the connection doubles? Also try with another connection on a secound query fired at the same time....
March 26, 2002 at 8:54 am
ActiveX seems like a slution, but yes I would be interested in your code to see what is happening. I feel the dynamic SQL is blowing you out of the...
March 26, 2002 at 8:52 am
One may be for SQL admining the connection but I cannot find details on this. I will try to test against an Oracle machine here to see what happens. Also...
March 26, 2002 at 7:20 am
Check your db for the proper indexes (look at the query's execution plan), make sure you have the statistics to make proper index choices, post you DDL for the table...
March 26, 2002 at 7:11 am
Can you provide a sample of your data and the DDL of the tables involved. Also give me the steps to recreate this problem as I have no issues.
"Don't roll...
March 26, 2002 at 7:05 am
If you know the maximum lenght is 4000 then varchar should be able to support you. Try it in another table with these characters. If not then ntext will support...
March 26, 2002 at 6:52 am
If the indexes cannot be dropped you may want to try an index rebuild and reset the fill factor so there is space in the index files to accomadate the...
March 26, 2002 at 6:10 am
How are you try to export, BCP, DTS some other. With the BCP and DTS you can specific " as a delimiter for each column of data and it shoudl...
March 26, 2002 at 5:57 am
I don't know of anyway you can do this thru PerfMon. You can however use Profiler to capture scans and sql statements to try and pinpoint these. I usuaully setup...
March 26, 2002 at 5:49 am
Yes, a little more detail about the table involved and how the data is related could help us understand how to get to your solution or point you down the...
March 26, 2002 at 5:31 am
Exactly what I you trying to do. I am afraid doing anything to some of the system tables like this could potentially blow you processing times out of the water...
March 26, 2002 at 5:28 am
I use several, mostly when job stuff fail. Also, server conditions exist that are not healthy. A number of replication alerts, log file full, Insufficient Resources (which has never occurred...
March 26, 2002 at 5:23 am
This is untested and I do not guarantee it will work but it may.
Run sp_helpsort to see the current information about sort order / collation however this is just for...
March 26, 2002 at 5:15 am
No it is not legal, see this from SQL site
quote:
Processor license. Requires a single license for each CPU in the computer...
March 26, 2002 at 4:54 am
Viewing 15 posts - 6,661 through 6,675 (of 7,429 total)