programming
Get flash to fully experience Pearltrees
Scale Fail (part 1) [LWN.net]
Companies hire me to "fix the database" because they think it's the source of their performance and downtime problems. This is very rarely the case. Failure to scale is almost always the result of poor management decisions — often a series of them.
AdviceAnimals announcements AskReddit askscience atheism aww bestof blog funny gaming IAmA movies Music pics politics science technology todayilearned videos worldnews WTF edit subscriptions programming reddit is a source for what's new and popular online. vote on links that you like or dislike and help decide what's popular, or submit your own! Memory allocation functions can give you more memory than you ask for, and you are welcome to use the freebies too, but watch out for the free lunch ( blogs.msdn.com )
programming
Welcome to LWN.net [LWN.net]
The kernel may be the core of a Linux system, but neither users nor applications deal with the kernel directly. Instead, almost all interactions with the kernel are moderated through the C library, which is charged with providing a standards-compliant interface to the kernel's functionality. There are a number of C library implementations available, but, outside of the embedded sphere, most Linux systems use the GNU C library, often just called "glibc." The development project behind glibc has a long and interesting history which took a new turn with the dissolution of its steering committee on March 26. Last week's Kernel Page included an article on Peter Zijlstra's NUMA scheduling patch set.
A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data. In other words, only values that are supposed to appear in the database are permitted. For example, say we have two tables, a CUSTOMER table that includes all customer data, and an ORDERS table that includes all customer orders. The constraint here is that all orders must be associated with a customer that is already in the CUSTOMER table. In this case, we will place a foreign key on the ORDERS table and have it relate to the primary key of the CUSTOMER table.
SQL Foreign Key
There are two different ways to implement inserting data from one table to another table. I strongly suggest to use either of the method over cursor. Performance of following two methods is far superior over cursor. I prefer to use Method 1 always as I works in all the case. Method 1 : INSERT INTO SELECT This method is used when table is already created in the database earlier and data is to be inserted into this table from another table.
SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE « Journey to SQLAuthority
dotnet
Try some of the best and most useful bookmarklets for Firefox, Google Chrome, Safari, IE, Opera and other web browsers. These bookmarklets help you do stuff without installing any add-ons. This guide will help you understand the advantages of bookmarklets over add-ons, how to install bookmarklets followed by a list of essential bookmarklets that should work across all popular browsers including Google Chrome, Firefox, Opera, IE and Safari. Why Use Bookmarklet over Add-ons
