Tips for SQL Query Optimization
Tips for SQL Query Optimization The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’. For Example: Write the query as SELECT id, first_name, last_name, age, subject FROM student_details;…
Tips for Database ConnectionStrings of Various Provider
Tips for Database ConnectionStrings of Various Provider Microsoft SQL Server // ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = “Dsn=DsnName;” + “Uid=UserName;” +…
Tips for beginner programming mistakes
Fear and lack of self-confidence The number one mistake you can make as a beginner programmer is to think you’re not good enough, not smart enough: that you have the wrong type of brain, and you’ll just never get it. I believe that anyone can learn to…
Tips for performance tuning of databases
Database statistics The most important resource to any SQL optimizer is the statistics collected for different tables within the catalog. Statistics is the information about indexes and their distribution with respect to each other. Optimizer uses this…
How to Check your browser supports IndexedDB or not
Browser supports IndexedDB The very first thing we should do is check for IndexedDB support. While there are tools out there that provide generic ways to check for browser features, we can make this much simpler since we’re just checking for one…
What is IndexedDB in HTML5 ?
IndexedDB provides a way for you to store large amounts of data on your user’s browser. Any application that needs to send a lot of data over the wire could greatly benefit from being able to store that data on the client instead. Of course storage is…
Creating Simple Event with MySQL
Creating a First Event Creating an Event is somewhat like creating stored procedure or user defined function in MySQL. You will have DELIMITER, BEGIN, DO and END keywords. As mentioned earlier we can define the execution time for the event while creating…
How to renaming a sqlite table programatically in iphone?
How to renaming a sqlite table programatically in iphone? SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table, to rename a column within a table, or to add a new column to an existing…
How to create sqlite database programmatically?
How to create sqlite database programmatically? SQLite isn’t the only way to persist data on iOS. Besides Core Data, there are lots of other alternatives for data persistence, including Realm, Couchbase Lite, Firebase, and NSCoding. SQLite does have some…
How to Add Identity Column to Table Based on Order of Another Column
How to Add Identity Column to Table Based on Order of Another Column USE tempdb GO -- Create Table CREATE TABLE TestTable (Col1 INT, Col2 VARCHAR(100)) GO -- Insert Data INSERT INTO TestTable (Col1, Col2) VALUES (33, 'Ranjan'); INSERT INTO TestTable…