There's a couple of definite row estimate discrepancies.

The ad-hoc query shows an estimated 697 rows from the att_patient table, while the function shows just 1. Which sounds more correct?

There's no...

Could you post the actual plan for...

am (2/19/2009)

---

It is a SAN disk, is it advisable to have all the data files for the 4 databases on single disk and log files. Should tempdb be always on...

Lynn Pettis (2/19/2009)

---

Talking about interviewing, I would love to be in the same place at the same time as Jeff, Gail, Grant, Gus, Matt, and Jack and have a mock...

Please read through this - Managing Transaction Logs[/url]

GSquared (2/19/2009)

---

Personally though, I would rather have a smart, motivated person with very little knowledge but the ability and eagerness to learn, than a moderately knowledgeable person with no willingness...

How?

Can you,...

That sounds just like parameter sniffing. (http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/)

Post the code and exec plan?

Does it have to be a function?

For detach/attach, probably the same as SQL 2000, using the sp_detach_db and sp_attach_db procedures (see Books Online for details)

As for shrinking the log, why do you want to? Shrinking's a...

Please post unrelated questions in a new thread....

What number do you want back for the dates given?

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic660187-146-1.aspx

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic660190-338-1.aspx

Then spend time here. On this forum you'll see hundreds of problems and questions,...

From prior experience working with people like that, as...