Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

CAMBRIDGE, United Kingdom--(BUSINESS WIRE)--Red Gate Software has released a new tool called SQL Object Level Recovery Native that enables individual database objects to be recovered from native SQL ...

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31. Microsoft SQL Server's ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

We've been focused on learning about the upcoming versions of SharePoint 2010 and Office 2010. But Microsoft also has another product just out as a CTP (community technology preview) -- SQL Server ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Note: The SQL procedure displays the variable labels as stored in the view. However, because you are referencing a view descriptor, you must use the SAS variable names in the WHERE clause, not the ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

Do you ever tune SQL? See how OakTable network member, Oracle ACE Director and Pro Oracle SQL author Karen Morton combines real-time profiling with a Visual SQL Tuner to find and fix performance ...