Pinterest • The world’s catalog of ideas

Sql Exists

@codegirlcode - i think i will win at life for wearing these two beauties everyday! sorry for not being able to meet with you while time-traveling to nyc this week but happy enough that exists. thank you for inspiring me and thousands of others Laura (@codergirl_). you truly rule and the first round will be on me! #programmer #programming #coding #code #coder #computerscience #developer #codingquotes #tech #setup #php #python #html #css #java #javascript #webdev #coderlife…

Big Data refers to a large set of data too complex to be handled by conventional database management tools. It’s data that exists beyond your web analytics, ERP, or CRM databases. It often exists outside of your organization, think of customer sentiment and social sharing data owned by Facebook, Twitter and Pinterest, or competitive pricing data from comparison shopping engines.


Stairway to T-SQL DML Level 12: Using the MERGE Statement: How many times have you built logic in your code that first checks for the existence of a row, then based on the outcome of that existence check you either perform an INSERT statement (if the row doesn’t exist), or an UPDATE statement (if the row already exists)? With the release of SQL Server 2008 Microsoft introduced the MERGE statement to make that task a lot easier. In this article I’ll be discussing how to perform insert, update…

Avoid Using COUNT() in SQL When You Could Use EXISTS()

Yesterday's webcast, Backup made easy with SQL Safe Backup Webcast, is in the archive. Take a look: