Hello Everyone, I have this deadlock graph from one of our systems. The deadlock seem to be happening with dbo.ScoreNote table. I can use all the...
Hello Everyone, This is the deadlock graph I have from one of our systems. I will use all the help I can get. <deadlock-list> <deadlock...
Probably this section might not be the right one for this topic but it's definately the right site regarding the performance difference. Can you give...
I am not clear about the RETURN within the trigger ( IF UPDATE (user_modified) OR UPDATE (date_modified) RETURN) of this part. How is this trigger...
I believe it's not a good idea at all but I am exploring the possibility of generating a unique random numbers with fixed length barcode for every...
I am assuming that the SQL still evaluates IF condition even if the @debug = 0, within the stored procedure, while executing the SP. Is there any...
Use DatabaseName GO SET NOCOUNT ON CREATE TABLE #TestMaxLength (mxlen_id int identity(1,1), mxlen_desc text) INSERT INTO...
Probably this is a vague question. I need to write a generic script/sp that will generate scripts for existing TRIGGERS from all tables and execute...
A man suspected his wife was seeing another man, so he hired the famous Chinese detective, Chen Lee, to watch and report any activities while he...
I don't think it's a good idea to have index on this column. Anyone disagree? I am trying to optimize the indices on existing tables and seen some...
I am trying to post a new topic at main forum section but it's taking forever to open and eventually times out. Name --------- Dilli Grg...
I don't know if it is only with my browser or anyone has experienced the same thing. Most of the time when I go to the...
I am trying to generate cross tab report similar to this example. Any idea if it can even be achieved at all. Basically, I will be passing the...
I am trying to export results into Excel sheet by creating temporary linked server and executing the SP. It is throwing this error. Any suggestion on...
What is the best way to store whole xml contract in the database table? I know in 2005, we can define as xml data type column in a table to store...
The following isolation level(which is inside the SP and also necessary) is causing the deadlocks. Once this transaction is committed, should I set...
How can I evaluate more than 2 columns with the where condition? For example, I have table A which has FName, MName, LName (is a unique constraint)...
I was trying to create a unique constraint on these fields for this table, I am getting this warning. Will this give problems in the insert/update...
I need to update (remove) some data from a column which contains special character. For instance, a column called DESCRIPTION contains: 'MAIN ||...
I am getting SPAM on my emails from this site with the following email address. Can you please take care of this user and protect member's email from...
Separate names with a comma.
