Passing a column value to a function makes the where clause non-sargable. However, it is still possible it is rarely executed as the optimizer should know enough to test it...

Here's one with no subqueries and one rather straightforward derived table.

select  da.id, da.ActivityDate, der.Hours, der.Salary
from    DAILY_ACTIVITY da
join    (
    select ...

I lived 25 years in Los Angeles area and 5 years outside San Francisco. SF is the crazy uncle of the west coast and living in LA is like living...

Is Tim Berners-Lee being paid today to write HTML? I seriously doubt it.

I don't doubt there are physicist who can program, and program well. My point is that I can...

Not that it has anything to do specifically with DBAs, but I've noticed a lot of job ads that list every skill the company could possible want. I call them...

NOOO!!!! <sob!>

In 99.9% of the places Hungarian notation is used, it is used incorrectly. It was intended to signify the type of data a variable contained, not the datatype of...

Method 2 is my preferred way but with this slight addendum. It works better when the tables themselves adhere to a good naming convention. I prefer to give tables a...

A lot of good, sound advice. One thing you should consider no matter which way you end up going: never, EVER allow developers to dictate database design. They tell you...

It's not elegant but:

• create DawnTemp <according to new criteria>
• insert into DawnTemp <everything but identity col>

  select <everything but identity col> from DawnTest

• make sure everything went over all right
• drop DawnTest
• rename DawnTemp to...

Another suggestion is two views: one lists only the employees and one lists only the dependents. In the employee view, also have a computed column for the number of dependents...

My recommendation is to listen to JLK. Bring the data into a flat table and then fire off a sproc to break it up. You could probably do the same...

Just make the existing query into a derived table and take the sums from that:

select sum(Visitors) as VisitorCount, sum(Pages) as PageCount 
from (
    SELECT CONVERT(CHAR(10),LogDate,103) As Date_,
...

Maybe I came on a little heavy. Right now I'm working where there are dozens of servers with over a thousand databases (total -- not per each) and the use...

You keep using the words "empty" and "blank" to refer to the contents of a column. These words have no meaning in the context of a relational database. If the...

Then please post the "create table" and subsequent "insert" so we can see exactly what you did.

Come to think of it, a "select top 10 *" from the original table...