Lynn Pettis (12/11/2008)

---

My daughters were leaving school on Novermber 17th (my oldest is a senior and the middle one a freshman) and were rear ended while stopped getting ready to...

You might want to try using TOP(1) with an ORDER BY. If you're referencing an index, the TOP (1) is pretty consistently faster than the MAX.

If it makes you feel better I've been hit, while stopped, not stopping, I've been sitting still, waiting, four times over the last 10 years. You're not alone.

Luckily, I drive...

You can't really filter by table in a trace. You can filter by database, which should help. You can also filter by user, which again will help. After that, you...

Classic. Little Bobby Tables.

Walking might be dangerous because when the car bounces off of Lynn... I don't have those ninja/cat reflexes. I'll just get hit.

Suresh has a good example there. Perfect.

You just have to decide if the size of the index and the added cost of maintaining it are worth the benefits you'll derive...

Yeah, what Jeffrey wrote is correct for the cast & conversion. However, I do agree with Jeff. Normally I wouldn't recommend doing this sort of formatting in SQL Server.

BTW, 2008...

I'm going with the consensus on this one... we'll walk or I'll drive. 😛

As long as it's datetime, you'll still get the time field. Try using the CONVERT with 101 and CAST to VARCHAR. That should do what you need.

Indexing is a pretty big topic that can't really be done justice in a single post.

You need to think about the fact that the SELECT statement can also affect index...

You should also check the silly stuff, default connection settings, service pack and hot fix levels, that kind of thing. There's usually something if it's not what Michael listed above.

Sounds like the second table would be joined as a LEFT join, so look up OUTER JOINS in Books Online.

Oh, I agree with Steve here. I'm hating wooden floors more & more with each year. Of course, when we've done demo's and competitions they're sometimes on things worse than...

Weird.

Here's the original link

http://www.alandallessandrokarate.com/%5B/url%5D

Pictures are on the right. I'm the luckless b*****d grabbing the guy from behind.