Autonomy

Comments Off on 6 Tips on how to boost Autonomy Indexing Speed

6 Tips on how to boost Autonomy Indexing Speed

Autonomy is great for increasing performance on queries, but you may find it takes time to Index Data into Autonomy, below I share some tips on how to increase the performance of Autonomy Indexing. 6 Tips on how to increase Autonomy Indexing Speed 1. Setup IDOL and Connectors on 2 different boxes this should increase […]

SQL (Structured Query Language)

Comments Off on How to get only date from data field SQl server t- sql

How to get only date from data field SQl server t- sql

Following line gives you the short date  from long date time field. ie. From a date time field of Sql server field if you need to extract only date use the the following method. Replace GetDate() with your date field name. Cast(Floor(Cast(Getdate() as float)) as datetime

Database

Comments Off on Some information about databases

Some information about databases

Database is a set of rows and columns. We use database to store information in it and we can retrieve that information on demand. To manipulate database we use SQL (Structured Query Language.) There are many database or DBMS (Database Management System) are available few re-known are Oracle, SQL Server, MySql, Sybase etc. Which database […]