|
That's the impression I had, but I wanted to ask some more experienced heads in case I was missing something.
Thanks for the reply, Bob.
Software Zen: delete this;
|
|
|
|
|
While using ADDNEW in MySQL it is creating huge Temp files?
The file size will be more than 2GB as data in the server grows.
Is there any way to reduce or stop them to create thoes files.
|
|
|
|
|
I got the answer
AddNew will create a temp file as it will insert the data into a temp file before storing it into the main Database.If you are try to inseret the data in a sorted order or if your maintaing the Indexes it will generate teh huge tmp files.
So instead of AddNew just use Insert statment it will help you to insert the data directly in to the table where u want.
|
|
|
|
|
I am using SQL Reporting Services to create reports.
The report contains limited number of rows in the middle of the report page along with the different information on the entire page.
For eg:- If there are 10 rows in the dataset, then the report should contain 5 rows on 1 report page along with other information and the remaining 5 on other page along with the same information.
Can anyone help me with this?
Thanks in advance.
|
|
|
|
|
 How to comare two database,and find out difference?
|
|
|
|
|
Use the sys tables or information_schema and compare your objects on the schema, table name, and column name.
|
|
|
|
|
I found "sql delta" and "D-Softs DBC" can do this job
|
|
|
|
|
I'm getting an error calling a stored proc, and the error is about attempting to update a view, but I cannot find the location of the update, as the stored proc call calls other stored procs, etc. many, many levels deep. I've tried searching syscomments for all procs that contain the view name, and narrowed it down to nine procs, and thought I removed any updates from those procs, but I'm still getting the same error. Is there any other way to solve this rather than manual inspection?
|
|
|
|
|
Have you tried using Profiler to trace the SQL/procedures executed?
|
|
|
|
|
I'm only getting the top level procedure call in profiler.
|
|
|
|
|
Did you try tracing additional events such as SP:Starting, SP:Completed, under Stored Procedures, and SQL:StmtStarting under TSQL, or are you just accepting the default events for tracing?
|
|
|
|
|
I did now, with no joy. The execution plan isn't too helpful either because I can't search it.
|
|
|
|
|
Put a try - catch block in the starting SP and use the ERROR_PROCEDURE() function.
Thanks.
|
|
|
|
|
That's cool to know, thanks, but in this instance ERROR_PROCEDURE() returns null. 
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT ERROR_PROCEDURE() AS EP
END CATCH
|
|
|
|
|
Sorry, at the moment I don't really have any other suggestions. I've usually had pretty good luck with Profiler. Are you filtering anything out? Perhaps try saving the trace to a text file and searching that?
|
|
|
|
|
Thanks anyway. It turns out that the one proc actually loads dynamic SQL from a table and executes it.
|
|
|
|
|
Well, that's just cheating. 
Anyway, glad you found it.
|
|
|
|
|
Why CTT*.tmp files are generating in %temp% while runing MySQL with ODBC connectivity.
The CTT*.tmp are growing in size as records are growing.
It is reaching upto 2GB.
Due to this my C drive is filling up and leading to crash.
Please help me out by telling what are CTT*.tmp files?
and why are they generated?
|
|
|
|
|
Hi,
Anyone here successfully able to install SQL Server on Vista? I can't seem to install the Databae Engine component. Each time the install finishes, I can't find the service in SCM. Anyone been through the same experience?
(I have Windows Vista Enterprise SP1 and I am trying to install SQL Server 2005 Enterprise)
TIA!
----------------------------------------------------------
Every nation state's armed forces call themselves 'Defence',
makes me wonder why there are conflicts in the world.
modified on Monday, July 7, 2008 9:29 AM
|
|
|
|
|
Hmm - unfortunately I can't give you other help then yes - I've installed SQL Server (developer edition) on my Vista (x64).
I did not have any such problems as you mention - but I do recall there was a large service pack (for SQL Server 2005 for Vista.
Don't know if that might be the way to go
|
|
|
|
|
student table
id stu
1 s1
2 s2
subject table
id sub
1 sub1
2 sub2
student-subject table
id sid subid marks
1 1 1 100
2 1 2 100
3 2 1 100
My question is what shall be the query for those students who did not appear in all exams
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
SELECT stu
FROM student
WHERE id IN (
SELECT sid
FROM [student-subject]
GROUP BY sid
HAVING COUNT(*) < (SELECT COUNT(*) FROM subject)
)
|
|
|
|
|
Hello,
I have a table with one column "Product" which is primary column .
I want to make another table with fields TimePeriod, Qty and the products from Product table.
Product
Shirts
Trousers
Tie
Belts
Now I want to make this Table with following fields
TimePeriod Qty Shirts Trousers Tie Belts
Is there any query that I can write or I will have to hardcode the product names into the table
Regards
Pritha
|
|
|
|
|
Look up Pivot Tables.
Before you implement this, I suggest you decide why you want the table this way, and what might happen if you have, say, 40,000 records in your Products table.
|
|
|
|
|
Hello,
Thanks for your reply
But I am not going to have more than 10 products .
Is the Pivot Tables a link .
But it does not work
Regards,
Priya
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
