Skip to main content

Posts

Showing posts from March, 2015

Asp code to call home page on logout button,reset password of user

Asp code to call home page on logout button Make script code this way Put this code in vb-script tag sub home() document.frm.submit() end sub //to call function on click event this way onclick="home()" Asp code to reset password of user If you want to reset password or change password of particular user and you can login page then you can get hint or help to set this code in your form. set con=server.CreateObject ("ADODB.CONNECTION") set rs=server.CreateObject ("ADODB.RECORDSET") con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database Path" Response.Clear () set rs = con.Execute ("select * from logtable where Username='" & Request.Form ("logid") & "' and pwd = '" & Request.Form ("oldpassword") & "'" ) if rs.RecordCount <=0 then Response.Write "invalid password" end if if Request.Form("che

Example of New operator overloading,Call by value function and reference in c++

Example of New operator overloading in c++ const int maxnames = 5; class Names { char name[25]; static char Names::pool[]; static short int Names::inuse[maxnames]; public: Names(char* s = 0) { if (s) strncpy(name, s, sizeof(name)); } void* operator new[](size_t) throw(std::bad_alloc); void operator delete[](void*) throw(); void display() const { std::cout << name << std::endl; } }; // Simple memory pool to handle fixed number of Names. char Names::pool[maxnames * sizeof(Names)]; short int Names::inuse[maxnames]; // Overloaded new[] operator for the Names class. void* Names::operator new[](size_t size) throw(std::bad_alloc) { int elements = size / sizeof(Names); // Find the first empty element (if any). int p = -1; int i = 0; while ((i < maxnames) && (p == -1)) { if (!inuse[i]) p = i; ++i; } // Not enough room. if ((p == -1) || ((maxnames - p) < elements)) throw std::ba

Get Missing Index details from Activity Monitor Screen in SQL to get more performance

Create Missing index using SQL Activity Monitor to process improvement If you want to improve performance of application then keep view on activity monitor in SQL and go to long executed query line then you can see from recent expensive query window screen . You can see the average duration of query execution. To get Missing Index details from Activity Monitor Screen in SQL to get more performance you can do following steps. /* Missing Index Details from ExecutionPlan1.sqlplan The Query Processor estimates that implementing the following index could improve the query cost by 93.6536%. */ /* USE [DB_TEST] GO CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>] ON [dbo].[GENERALJOURNALACCOUNTENTRY] ([CREATEDTRANSACTIONID]) GO */ Once you get index you can create index by directly executing query or you can create index manually. You can create index in query execution process time is very high.