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.

Robert Frasca (3/4/2008)

---

"Some of these shouldn't be allowed in my mind, like RAID 0 disks, which wouldn't be in a production system. "

I don't understand this line. I've seen...

Is this thread supposed to be about something posted by Jeff Moden? What is the link to it?

I was just kidding about the correlated sub-query; I wouldn't use it.

I locked horns with Celko on this very issue about 12 years ago on the old Compuserve SQL Server...