Checksum vs. Hashbytes What is Checksum? Checksum is a function available in sql server 2005 and sql server 2008. It is intended to build a hash index based on an expression or column list. Determining if two rows or expressions are equal can be a difficult and resource intensive process. This can be the case where the update was conditional based on all of the columns being equal or not for a specific row. Without checksums it is a long process of using innerjoins to identify the exact row to u...
Read More
There are three ways to find who is connected to a database in sqlserver. First one: Use the SQL SERVER Management Studio -- Management -- Activity Monitor This gives a list of users, database names, status, command, transactions, application with which they are using the database, CPU, IO and Memory usage, Login time etc. Second One : Use the built in stored procedure called sp_who2 Run the command exec sp_who2 This gives a list of users, database names, status, command, program with which they...
I have attended a cloud camp that was held in Auckland on Feb 26th 2010. Here are some points sent by Ben the Cloud camp organiser. Here's some post-CloudCamp reflections and some posts from different people about the event. I posted a roundup here giving my thoughts on the event. Thanks to all our sponsors who made the event possible - Gen-i, enStratus, Microsoft, salesforce, vmware, Intergen, the University of Auckland and Zendesk. Thanks also to Anne Bilek for doing a great job of helping to ...