I agree with Hugo that whether you update part of a file or re-write the entire file, the data in the file is updated. The bits may be in a...

When the question specifies the version of SQL Server, you should double check that the selected article in BOL is for that version. The Local Help search in BOL lists...

The type of organization could dictate how conservative or risky a leader can be. In banking, you can't appear to be taking risks. In tech, cutting edge risk taking is...

I got the question wrong, but after searching some more found out I WAS wrong. It would put the information into the restorehistory table if you used the LOADHISTORY option....

Although the question mentions that the snapshot will grow quickly, there is no mention of trying to shrink the size of the snapshot or running out of disk space. It...

Even...

The most valuable lesson I learned from my Dad when I was growing up was 'Look it up!' If I had a question, he wouldn't tell me the answer, he...

You can take a look at this about coupling Outlook to SQL Server:

http://www.sqlservercentral.com/articles/DTS/couplingoutlooktosqlserver/1693/

SELECT @@Rowcount AS RowsAffected

If a product can only be in one family and a family can only be in one category, you should have a category id in the family table as a...

Database optimization is a subset of performance tuning.

The problem isn't the COALESCE, you are adding each subsequent letter to the beginning of the string:

SELECT @string = COALESCE(letter + ' ', '') + @string from #test

To add to...

So, if the applicant is...

The clustered index contains the data pages. If you update the data pages, you are updating the clustered index.

If you drop the 'Friday' and the commas, then

SELECT CONVERT(varchar(10), CONVERT(datetime, 'August 15 2008 7:30 pm', 100), 101)