Skip to main content

Posts

Showing posts from February, 2013

SQL Server Transaction per interval

If you are wondering how much SQL transaction is happening on your database, run the below query. DECLARE @First INT DECLARE @Second INT SELECT @First = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'SQLServer:Databases' -- Change name of your server AND counter_name = '%Transactions/sec%' AND instance_name = '_Total'; -- Database name -- delay time WAITFOR DELAY '00:00:01' SELECT @Second = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'SQLServer:Databases' -- Change name of your server AND counter_name = '%Transactions/sec%' AND instance_name = '_Total'; -- Database name SELECT (@Second - @First) 'TotalTransactions' GO If you are having some problem in execution, please confirm the OBJECT_NAME and instance_name by running select * FROM sys.dm_os_performance_counters . You can change the WAITFOR DELAY time to meet your time interval requirement. I have used curren...

Postal Code for Bhutan

To know your postal code, go to this link -> http://www.bhutanpost.com.bt/postcode/postcode.php . Postcode is a code of digits added to postal address to facilitate mail delivery. Each country has its own coding system and in some countries it is referred to as Zip Code. Bhutan Post has 5-numeric digits code that indicates the following: 1. The first digit indicates the Region . 2. The second digit indicates the Dzongkhag 3. The third digit indicates the Dungkhag under a Dzongkhag 4. The last two digits indicate the delivery area, i.e, General Post Office (GPO)/Post Office (POs),Community Mail Office (CMOs)