Irfani Firdausy Live Journal

Month: May 2012

Calculating Mbps

The MATHEMATICAL maximum transfer of 1Mbps full duplex (megabit per second, or Mb/s) is roughly 320 gigabytes per month in each direction (320GB in and 320GB out). This is calculated from the number of seconds in a 30-day month multiplied by the number of bits in a megabit.

Continue reading

Move a Database Using Detach and Attach (Transact-SQL)

This topic describes how to move a detached database to another location and re-attach it to the same or a different server instance in SQL Server 2012. However, we recommend that you move databases by using the ALTER DATABASE planned relocation procedure, instead of using detach and attach. For more information, see Move User Databases.

Continue reading

© 2019

Theme by Anders NorenUp ↑