MSSQLTips

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

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/