You can get the week number from the datepart() function. I think if you are showing a range of dates, get the week numbers from the first and last date,...

Excellent quote, Richard. And congrats for finding a place that works for you.

I'd disagree...

GSquared (4/22/2009)

---

Steve: You should read the first chapter of Problems of Work. The editorial reads like an excerpt from it. The book has some very good advice...

Glad you like the comics. I'll pass the word.

The water is like 8 or 9 blocks, and while it's a bit of a hike coming back, it's walking distance. Lots of hotels around, and I'm sure Gail can...

I think it speaks more to someone's inability to deal with frustration, improper presentation of their opinion, and the likelihood that he/she will inappropriately use sarcasm.

Definitely not a team player,...

Do you have a question?

The size calculation for all the indexes is the same. A little over 2x the index size since it is a transactional process.

Not sure I'm correct. Kind of throwing things out in the dark. You covered a lot of things, that was my small guess as to the issue.

That's not available in 2000. You posted in a 2005 forum, so you got answers for that.

I'll move this to 2000.

You likely need to use Profiler to find queries. Not...

No worries. I understand, and it made me rethink it a bit. It's debatable if this is worth two points, and I'm happy to have the opinions. I just eyeball...

Sorry, my bad verbiage. I meant node.

The endpoint is a server setting, and depending on how the cluster was set up, I was thinking that perhaps the endpoint didn't get...

I like Jack's solution, though I might update, delete the matches, insert the rest. Not sure which is better.

I don't think you can get a count of the failed logins per user. They're logged, but you'd need to load that into a table and query it. There might...