Datetime Data
Repost from 26th March 2004
Did the last of my current series of webcasts this morning. Think I'm finally getting the hang of it. Seemed to go smoothly :-)
We also had our 2nd SQL Servers User Group meeting in Brizzie last night. Went great. We were up to 46 attendees (from 25 1st meeting). Rod Colledge gave a summary of securing sql server. Rob Risetto presented a session on using sql profiler to detect a wide variety of issues when managing a large number of server. (He and his group currently manage over 90 servers with around 4000 databases).
One topic that came up in the discussions on the dotnet mailing list yesterday though was how to send datetime data to sql server. The absolute best reference I've seen on this is my mad Swedish mate Tibor Karaszi's article on it here:
http://www.karaszi.com/SQLServer/info_datetime.asp
Highly recommended reading! It dispels a number of myths about this.
Last night Rob also very clearly made the point about prefixing stored procedures with their owner (eg EXEC dbo.MyProc rather than EXEC MyProc) to avoid cache misses. Worth checking!