Hi, Below statement takes more than hour to delete a million of records. what will be the optimized way for delete. Can i delete without top...
Hi madhivanan, each time you execute the above query you will get randaom 10 numbers between 1 to 30 which is ordered in asc. try executing it. hope...
We have wrote an sp to get zero price records. It will first check in Account table for active account. then in pricehistory table and it will...
I have a DB db1. In this db there is a batch process which feeds data from external file and have it in db. It starts from 9:00 pm to 7 am.During...
Hope this what you want. Try this one and get back. select * from ( select top 10 NumberS from tempseries order by newid())a order by 1
Thank you Elisabeth. This date statement was striking in mind for a long time. I to dont have an requirement or work environmnet to to test it.
Hi. If we have a sqlserver in two different geogriphycal region and if it is connected both the server to linked server. Eg. India and US. if we...
look at this link .. http://www.sql-server-performance.com/tips/blocking_p1.aspx
if we have only one row in syscomments then your sp is working, if we have more than one rwo for an sp, it is giving error. how to handle it. do...
if we have only one row in syscomments this is working, if we have more than that it is giving error. how to handle it. can you please give a...
Ya that is very good eg from frank, Hope it will clear you now
Hi Radhika, Please refer to this article, This might answer your questions. http://www.sql-server-performance.com/tips/covering_indexes_p1.aspx
Hi Frank SELECT item, loc, qty , RANK() OVER (PARTITION BY item ORDER BY qty) AS rn FROM tablename i tryed using this query sql server 2000 , i am...
hi, use cursor and fetch the item one by one and get top 2 and store it in temp table
procedures are not from third party, we have all the soucre code of it. but the problem is we have lot of objects. and not sure the version control...
Use select top 2 from table name order by datecolumn desc. this will work .
Hi Feeza add a linked server to the two servers then put a join with a both sysobjects. you can find what are the missing objects. after that if...
Hi, I want to migrate sql server 2000 to 2005. so i am planning to run upgrade advisor wizard to fix the existing problems. now the problem here is,...
i hope we can use exec DECRYPT2K sp for decrypting. but i am not sure where to get the source of this. in google many recommend for this. if you...
hi sandhya, look at this link it wil be helpfull http://support.microsoft.com/kb/895955
Separate names with a comma.
