I believe the question was what was causing the deadlock, which was indeed the HOLDLOCK hint. Your comments are indeed accurate, but did not address the question, which specifically asked what was causing the deadlock error. Of the answers given, there was only one really correct choice.
2003-06-10
Hello nafshan, quote: Can someone will give me some hints in searching millions and billions of record very fast. if you can estimate your db will contain that much records, I agree with mromm that one can write a book on how to get maximum performance. It starts with hardware, moves over to software (OS, […]
2003-06-10
In reponse to Slange's post. I must be classed as a DBA/DBO/Developer as I'm doing all the responsibilities you mentioned! I think it actually works quite well, being the DBA and the Developer. This sure has been an interesting topic and just goes to show that every shop is different.
2003-06-09
1 reads
Exec Master..xp_fixeddrives will give you free space avail. in MB MW
2003-06-09
1 reads
Do not understand some of questions here but system table sysperfinfo may be the one you are looking for.
2003-06-09
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
Wanda, I think you have been using an incorrect SQL. Use OR instead of AND in your SQL and try again. (LEDef_ActiveInd = 1 OR LEDef_Cd Like '10-%) Ram
2003-06-09
Steve - thanks for your reply. I just tried it and got the following message: Error 14539: Only a Standard or Enterprise edition of SQL Server can be enlisted into an MSX. I think that answers the question. LarryC
2003-06-09
Here is the conversion, it is written in Pascal: Please note that I have not been able to place a plus sign that can be seen in the preview, for some reason the plus sign dissapears; I have placed (Plus sign) instead. function ConvertStringStreamToHex(aString: String): String; var x: Integer; begin Result := EmptyStr; for x […]
2003-06-09
2003-06-09
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers