Try this instead:

Update Billing

SET Billing.AcctID = Family.AcctID

from Billing inner join Family

on Billing.Student = Family.Student

UPDATE Family

SET FAMILY.CHARGES = B.Charge,

 FAMILY.payments = B.Payment

FROM (SELECT AcctID, SUM(CHARGE) Charge, SUM(payment) payment...

The HAVING clause is a filter AFTER the GROUP BY has been perfomed on the select statement. In other words, the filter affects the result of the aggregation only; and...

You could try this experiment yourself, but my guess is that the column with all null values would be slightly quicker.

In any case, the question you should be asking is...

Try setting the database to 'single user' mode before detaching. More info can be found here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=169084

You may be using an alias instead of its original attribute name.

Not quite sure if there is an easier way, but if you are using the wizard, there is an option to edit the [Create Destination Table] SQL script, where you can...

You will be limited by the flavor of Windows OS. Have a read of this article for more info:

http://www.sql-server-performance.com/awe_memory.asp

You're pretty much there! By breaking the problem down to its lowest denominator, you could:

1. Loop through the 'string' attribute to extract each pair of text, place this into a working...

A number of contributors have added some useful monitoring check list to supplement this good article. Great work everyone!

One thing I would be interested in finding out: what happens next? For example,...

Since you are using an aggregate function, the @@rowcount will always return one record. Alternatively, use sp_executesql stored proc with an OUTPUT parameter to return the number of records based...

According to the Trace properties entry for ApplicationName: it is the client application that created the connection to SQL Server; in addition, what's been displayed can be reset by the...

Steve,

A well written article with some interesting points. I particularly like your introductory segment dealing with preparing a list of pros/cons and mulling over for a couple of weeks about...

Hi Sean,

I'm not sure that I agree with your analysis on the appropriate (or inappropriate) use of language at an interview. I think that it is safer not to second-guess what is...

Assuming that (i) the average length of the data within the two wide fields are relatively large (ie occupying most of the 4000 varchar field and is a common occurrence...