Ars Technica

SQL: UPDATE on the results of another query - help please

This is driving me CRAZY...<BR><BR>I need to do two things:<BR>1 - SELECT all the records out of an employee history table where the employee ID appears for the FIRST time. (Every x time period a new ...
Ars Technica

T-SQL A tiny attempt at making a dynamic update with local variables

This is an attempt at making a slightly dynamic query to modify in bulk a CMDB at work. Using SQL Server 2008. I'm trying to update a column with a specific value. I want the table, the column and the ...
Redmond Magazine

Troubleshoot Slow-Running Queries In SQL Server

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...
Visual Studio Magazine

Retrieve and Update Entity Framework with Dynamic Queries

You don't have to give up on creating dynamic queries just because you're using Entity Framework. Entity SQL and ObjectQuery will let you generate queries at runtime and still let you update your data ...