Yeah, maybe that's what I read too. I know I saw that it's going to more and more standard, if not required. So I'm working it into my code now....

I'd say it's a good habit to get into. If you use CTE's you must use a semi-colon terminator on the statement preceding the CTE. Microsoft has said they're going...

Roy Ernest (12/11/2008)

---

Kishore.P (12/10/2008)

---

Gauthama Kolivad (12/10/2008)

---

Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

As Gail Shaw mentioned if...

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.