|
Do you understand how a deadlock occurs?
Steve
|
|
|
|
|
A deadlock happens because two processes are locking ojects that the other needs. Essentially neither can continue until the other has completed. Since neither process can continue, then also neither process can complete. SQL Server will detect this and choose one process as the victim and cancel its transaction.
To prevent this happening in the first place you should try and ensure that all access to objects (e.g. tables) happen in the same sequence in all transactions. That is, if you have a transaction that updates table A then table B it will potentially deadlock with another transaction that updates table B then table A.
|
|
|
|
|
Hi,
i am geting this warning when i am sorting table through storedprocedure.
Warning: The table '#MM' has been created but its maximum row size (8186) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Plz help me out it's urrgent
|
|
|
|
|
SQL Server does not allow a row to span multiple physical file pages, which are 8KB in size. Therefore the row must be smaller than 8KB, minus a certain amount of per-page overhead, to fit on a single page. Temporary tables can potentially still be written out to disk, they just end up in tempdb's files.
The total size of all fixed-size fields, plus the maximum size specified for nvarchar, varchar and varbinary fields (plus a little overhead taken by nullable columns and the lengths and offsets of variable-length fields), exceeds the maximum allowed size. However, this is not in itself an error, because it's rare to use the maximum size of all variable-length fields in a single record. If you do, however, any INSERT or UPDATE statement where the lengths of the actual fields exceeds the limit will fail.
Solutions: reduce the number of fields in the table, reduce the maximum lengths of the fields, or change some fields to text, ntext or image types (which are allowed to be stored outside the page containing the rest of the row data).
|
|
|
|
|
I have SerialNumber(SN) ,city ,Country,version ,Region,,,etc in
parent table
For each SN in connectrix table there are multiple switch in
switch_header table. the details of switches are stored in
switch_details table.
For each switch we have different Frus that is stored in Fru table
that has information about fru details
I need to display Connectrix information along with their switches
and fru information as per search criteria.
When I Joined above 4 tables I am getting all the parent column as
repetation which I don't want to happen.
But some how user should understand the situation such that records
should return single SNO, and multiple switchsns ,multiple frus
I tried to populate data in heiarchial HTML table mannar using DataSet
But Gave up.
Is there any methodology from back end?
Any ideas on this?
Thanks in advance.
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
This sounds to be more of a question for .NET group or something.
One option in SQL Server would be to output more than one recordset from a procudure or something, but you are still dealing with a display issue which has everything to do with the application and nothing to do with SQL Server.
Since it is in the ADO group. Look into Nested Repeaters and you should find your answer there.
|
|
|
|
|
i need to wirte these stored procedures
1-
Add recored to the table
2-
use the above sp's to add the full data for the item in the tables(ks_media_item ,ks_media_item_content)
3-
update the data in the table ks_media_item
-if the value of item_no not found print msg "record not found "
-the columns (update_By , Udated_Date)willfill
4-
Rturn the all data Based on the Item_No from the tow tables
the tables are :
Ks_Media_Item(Item_no,Description,Added_Date,
Added_By,Update_By,Updated_Date)
2-
Ks_Media_Item_Content(Item_no,content,Text_Length)
i hope to answer me
thank you all
yazan_shalabi
|
|
|
|
|
yazan_zahi wrote: i hope to answer me
I'm still looking for the question.
|
|
|
|
|
sounds to me like you are hoping someone will do your work for you?
|
|
|
|
|
Sage wrote: sounds to me like you are hoping someone will do your work for you?
Answering people's questions is not my work. I do it voluntariliy because I enjoy helping people. However, people must first help themselves before I can help them.
|
|
|
|
|
You know that that post had been directed to Yazan dont you? I also enjoy helping others, learn that is. I dont enjoy helping other people do their work, unless I am getting paid.
|
|
|
|
|
Sage wrote: You know that that post had been directed to Yazan dont you?
I wondered about that. You replied to my message though (so I got the email notification), not Yazan's message.
|
|
|
|
|
we write the stored procedure in sqlserver2000
(update,insert,select)that better than write the statment it in asp.net code why ???
|
|
|
|
|
SP is a set of precompiled code.
It imporoves performance of the application
SPs can be reusable.
If any DB logic changes it's ok if we change in procedure it self rather than modifying all the queries.
SP makes maintainability also easier
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Also, if you revoke access to the actual tables to the users and do everything through Stored Procedures then you increase the security of the application because then the the users can only do what is specified in the Stored Procedure and cannot do anything else.
|
|
|
|
|
add recored to the table ks_Media_item
-if the same Item_no Value Found in the table Print msg"Record found"and exit the procedure
-the columns (Updated_by,Updated_Date)will be null
the tabel columns (Item_no,Decription,Added_Date,
Added_By,Updated_by,Updated_Date)
thank you;
yazan_shalabi
|
|
|
|
|
Sorry, your question is....?
|
|
|
|
|
why we shouled using the stored procedure vs asp.net ??
yazan_shalabi
|
|
|
|
|
yazan_zahi wrote: why we shouled using the stored procedure vs asp.net ??
Um. Stored Procedures are used in databases. asp.net is a framework for writing web-applications.
I think you need to phrase your question better.
|
|
|
|
|
we write the stored procedure in sqlserver2000
(update,insert,select)that better than write the statment it in asp.net code why ???
yazan_shalabi
|
|
|
|
|
yazan_zahi wrote: we write the stored procedure in sqlserver2000
(update,insert,select)that better than write the statment it in asp.net code why ???
Different developers will tell you something different.
Personally, I always use stored procedures. It keeps the database separate from the application, which to my mind makes maintaining the websites easier. It also allows the DBA to optimize the database end without having to change and redeploy the application.
|
|
|
|
|
add recored to the table ks_Media_item
-if the same Item_no Value Found in the table Print msg"Record found"and exit the procedure
-the columns (Updated_by,Updated_Date)will be null
the tabel columns (Item_no,Decription,Added_Date,
Added_By,Updated_by,Updated_Date)
thank you;
|
|
|
|
|
And also stored procedure are pre comiled thing so not compiling it everytime you execute that unlike normal sql queries.
Best Regards,
Apurva Kaushal
|
|
|
|
|
And also don't repost..
Best Regards,
Apurva Kaushal
|
|
|
|
|
why we shouled using the stored procedure vs asp.net ??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
