#DateForumTypeThreadPost
517 Apr 2013 @ 11:55 PDTDatabaseReplyRevoking All Access Rights For UsersREVOKE ALL PRIVILAGES ON database_name FROM ALL. Removes only the explicit privilages
417 Apr 2013 @ 11:26 PDTDatabaseReplySecondary indexesMultiload supports NUSI.
310 Apr 2012 @ 10:11 PDTDatabaseReplyDatatype mismatch in Joining Columns Yes, There will be performance issue because of implicity datatype conversion.
210 Apr 2012 @ 04:48 PDTDatabaseReplyHelp on 7 days average - advance sql Hi with recursive recur1(name1,d1,d2) as ( select name,date1- 7,date1 from dateex) select name,d2,count(*) from recur1 inner join dateex on name1 = name where date1 between d1 and d2 gr...
114 Feb 2012 @ 04:34 PSTDatabaseTopicProblem with DATABASE and SET SESSION DATABASE. Hi       When i run the folowing query in the sql assistant.The query didnt fetch any rows. Database database_name; select * from tablename1 left outer join ...