Programmer Collection
Programming Tips and Tricks
Thursday, November 20, 2014
Byte Units
›
byte = 10 ^ 0 kilobyte = 10 ^ 3 megabyte = 10 ^ 6 gigabyte = 10 ^ 9 terabyte = 10 ^ 12 exabyte = 10 ^ 15 zettabyte = 10 ^ 18 yottabyt...
Sunday, July 13, 2014
[MSSQL] Access Denied attaching a database when permissions are inherited
›
If you attempt to attach a database, and the mdf/ldf files are in a directory where your user account has privileges only through a group, ...
[MSSQL] SQL Server tablediff command line utility
›
Problem One problem that DBAs often face is maintaining lookups tables across multiple servers or sites. These tables could either be re...
[MSSQL] Why Primary Keys can be important on large tables
›
By Ben Kubicek , 2014/06/30 An easy answer to this question, why primary keys can be important, is: because if you don't have a ...
[MSSQL] How to Create Linked Server for a MySQL database using SQL Server Management Studio
›
Creating a Linked Server in SSMS for a MySQL database Install MySQL Connector Download the MySQL ODBC driver from mysql.com Install MyS...
[MSSQL] Deleting Large Number of Records
›
By Lynn Pettis , 2011/02/18 (first published: 2009/09/15) Introduction One of the frequent questions asked on forums is how to delete...
›
Home
View web version