Dave, is this a SQL2000 SP4 or later build? If so this might help http://support.microsoft.com/kb/906344 - this behaviour was introduced in SP4 and...
You would need to convert the datetime into a varchar, but there isn't a built in style for yyyy-mm-dd, so convert to yyyy.mm.dd (which is style...
It's ok - the office converter worked a treat!
Have you got a non-2007 version for us stuck on Office 2003?
Dave, If you look in BOL, you'll see that Developer Edition carries the same features as Enterprise Edition for exactly the reason you need - so...
What's the timings like after a DBCC FREEPROCCACHE? [assuming that this isn't being tried out on a production system]
Hi all I am hoping that someone can share some real-world experience with me. I'll try and simplify the scenario. We have a Product database that...
You may have plan issues See http://www.sqlservercentral.com/articles/Performance+Tuning/2863/ for a similar issue and resolution. By changing the...
You may have plan issues. See http://www.sqlservercentral.com/articles/Performance+Tuning/2863/ for a similar issue and resolution.
Separate names with a comma.
