MSSQLTips

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

In the next link, http://www.mssqltips.com/tip.asp?tip=1541 , there is a paragraph where it mentions that clustering in SQL server is about availability, opposite about others setups about incresasing power processing; Is there something about it (clusters for add power processing) in SQL Server (perhaps...

Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...

Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...