Resource Responses

Search Guest Response by Email:
Total 4 responses found.
Delete VS Truncate
True Truncate is also a logged operation, but in a different way. It logs the deallocation of the data pages in which the data exists.

I forgot to update the article here whereas in 2006 itself I wrote a blog post on that in my blog. Seems hyperlinks can't be posted here :)
Author: Vadivel Mohanakrishnan      Posted Date: 06 Aug 2011
TO avoid divide by zero problem in sql server
http://vadivel.blogspot.com/2007/04/workarond-for-divide-by-zero-error.html
Author: Vadivel Mohanakrishnan      Posted Date: 30 Dec 2007
To Get Table name and its count from database
For this to work statistics needs to be up to date. Also I have blogged about this http://vadivel.blogspot.com/2006/07/faster-way-to-find-row-count-of-table.html where I have provided solution for SQL Server 2005 also.
Author: Vadivel Mohanakrishnan      Posted Date: 28 Dec 2007
Fastest way to retrieve number of records in a table
For this to work statistics needs to be up to date. Also I have blogged about this http://vadivel.blogspot.com/2006/07/faster-way-to-find-row-count-of-table.html where I have provided solution for SQL Server 2005 also.
Author: Vadivel Mohanakrishnan      Posted Date: 27 Dec 2007



Top Contributors
Today
    Last 7 Daysmore...

    Awards & Gifts

    Online Members

    Williams
    More...
     
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India