This gives you the information you want, along with a more detailed analysis.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

You might try it this way (I haven't tested this):

convert(nvarchar(max),convert(varbinary(max),MyBlobColumn))

If the number of unique combinations of values is not large, you might start by creating an intermediate table with the rowcount for each unique combination of values across a...

These methods work over the entire...

Getting back to the OP's question (assuming they had a reason for wanting the first and last day of the year), and if the year is passed as an integer...

Setting up and monitoring tape backups is often pushed to low level techs who do not always understand the critical importance of backups for SQL Servers.

I recently reviewed the staus...

I would ask the networking people that are asking you to use this product to explain exactly what benefit that it will provide instead of continuing to use the existing,...

You can't change getdate(), so you need to come up with a different plan.

Probably the most important thing to do would be to ask exactly what they are trying to do, what information they need, and why they think adding this column will...

We are also looking for a financial auditing expert who can troubleshoot our financial records without making people uncomfortable about violating financial accounting standards and inconvenient laws and and who...

“We want someone who knows how to do things right, but don’t want them to actually do things right or try to get anyone else to do things right. ...

Situation normal, all F'd up.

Posted 2008-03-06 11:41 Eastern US time

For complex searches or reports with many optional parameters dynamic SQL is often the best solution. I would carefully evaluate the query plans that you get with dynamic SQL...

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

http://www.w3schools.com/sql/default.asp

You should ask Microsoft that question.