Forget the missing index results for now and focus on working through the two articles Gail posted. Adding missing indexes is great and all but what if the real...

I see what you're looking for now. Sounds like Paul's solution will work.

Is the backup part of a job or maintenance plan? Might be easier to notify you via email when the backup completes. Never used a 3rd party backup...

I've seen stuff like this before. It can be a real pain in the butt to manage and locate the objects you need when their scattered all over a...

Data and log files on a network share is not possible by default. See if this helps.

http://support.microsoft.com/kb/304261

Product_Interest is a character column(char, nchar etc.). Are you mixing numeric and character data together? Probably a bad idea.

Try to put single quotes around the 0.

select *

from customers.dbo.lead

where...

From my understanding of how that would work, you wouldn't. If you wanted to see if a typed password matched what was hashed...

LOL, that's a good idea.

Sean and Michael touched on where I was going with my last question. If the datepart function returns data that doesn't match your company's definition of a week then...

Err, never mind. Lowell beat me to it. My solution doesn't take into consideration duplicate IncidentID's. Not sure if they will repeat or not.

Is this what you're...

Do your weeks start on Sunday then? So 1/1/2011 was in week 52, not week 1?

Oh, I see what you're talking about now. That's the equivalent of this.

select datepart(wk,'12/25/2011')

Do you want iso_week instead?

Select datepart(iso_week,(Select SalesWeekStart from fn_PrevSalesWeek(getdate())))

I have only played around with partitioning on a local database, never in a production environment. It may be best if I just point you in the direction of...

May have to explain more for someone to help you out. Sample data, ddl scripts, and expected output help. Hard to say without seeing under the hood...

Have you looked into table partitioning? Or are you like me, stuck on standard edition?