Geeks With Blogs
My Place For SQL Lets Talk SQL

It looks abnoxious when as MS MVP I advocate MOF/MSF Database Designs for customers and USers but still one of our main System Databases named MSDB has columns which are related to Datetime have been kept as INT...

WHo Designed this Database and WHo pruned it... I wish to meet them .. God... It wasted my extra time and Extra resources to get them casted , So that my RDL can just  publish the report on SYSJOB and SYSJOB HISTORY..

RUN_DATE and RUN_TIME why are they int  type  ?? By any standard both should have been Datetime Types.

It is not a BUG but a Flaw in Database Design Understanding???

 

 

 

 

 

Posted on Thursday, May 24, 2007 8:39 PM CHECK it | Back to top


Comments on this post: Who designed MSDB ??

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Veer Ji Wangoo | Powered by: GeeksWithBlogs.net