New Line Character in Java for Windows and Linux.

2009-03-20T11:22:00.001+05:30

As we all know, Java is a platform independent. But there may be some cases, when we will have to consider the platform. The new line character for Windows is CR + LF that mean Carriage Return and Line Feed. Its ASCII value is 13. But for Linux, it is '\n' and its ASCII value is 10. It might be different for MAC. So, we cannot be sure what to use for New Line in Java. One alternative might be

DLL Memory Management

2009-01-27T06:43:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } I have been a good Visual Basic Programmer during my early days in undergraduate course. VB6 is used extensively to develop desktop (windows) based applications. DLLs here mean Dynamic Link Libraries. DLLs generally store function definitions. So, when called by an application by passing input

How to block built in windows administrators from using your SQL database?

2009-01-07T22:13:00.001+05:30

The problem is terrible. You are not the windows administrator. But you have to create a database in the machine without allowing built in administrator of windows to access. Either you install the SQL Server in Mixed Mode or Windows Authentication mode, by default, built-in administrators becomes SQL Server Administrator. So, they will have access to each and every SQL database in that machine.

Default user of login mapped to role SQL Server Administrator

2008-12-31T17:25:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } The post I m writing is slightly confusing. If a SQL server login is assigned to System Administrator Server role of SQL Server 2000, then it will have rights to perform any activity in SQL Server Installation. That is what, SQL Server says. This may be problematic some times.

Remove Single Line Comments from SQL Server Procedure

2008-12-26T22:13:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you follow this blog regularly, you would have noticed that I have written logic as well as code to remove multi-line comments from SQL Server Procedure. You also can follow the link to get to that. Here, my concern is to remove single line comment from SQL Server procedure. It's a much

How to calculate rank using SQL trick?

2008-12-17T21:39:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } Suppose you have data as shown below in a table. It contains marks obtained by students in different subjects. Here, student_id and subject_id makes the primary key of the table. student_id subject_id obtd_marks

Easy way to search for database objects

2008-12-16T21:22:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you are a database administrator, you come across thousands of database objects like stored procedures, tables, views, functions, triggers, etc. So, it's not possible to remember name of each of these objects. So,

Small trick to speed up your select query

2008-12-15T22:07:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you want to select data from a database table, but somebody else is inserting data in same table, then in general case, you will have to wait till the insert completes. Your query is deadlocked. In many cases, the

User Name does not show up in Task Manager

2008-12-05T21:43:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } Through Task Manager, one can find out the services running on a windows machine. I usually use it to find out unnecessary processes and stop them or to find out the memory usage of a process. Sometimes, may be due

Faster way to get rowcount on sql table

2008-12-03T12:59:00.002+05:30

If you want to get the number of rows of a sql table, you would probably think of using count keyword of sql server. If "retailer" is a sql table, then it would look like this. select count(*) from retailer It gives the result, but it would be costlier in case of CPU usage and time as it uses an aggregate function count. The query can be optimized as follows. select

Comments in different Programming Languages

2008-12-01T23:29:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } Comments are helpful medium for storing useful information in application codes while developing it. A successful software is not only represented by how well it does it task but also by how well it is documented and how well it's programming logic can be understood by a new comer. So, the

Unexpected T_VARIABLE or T_ECHO variable error in PHP

2008-12-01T23:26:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you are newbie in PHP programming, you may have encountered to above problem. It is just a minor error. But, the nature of error message is some tricky. Generally, the message comes like this. Parse error: parse

Create SQL Job to shrink database

2008-11-21T22:16:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you are a newbie in SQL database, this post may be helpful for you to create SQL job in SQL Server 2000. SQL Jobs are similar to Windows Scheduled job. It also can be scheduled to run hourly, daily, weekly or monthly as per required, provided that SQL Server agent is on and no other external

Convert Amount into Words according to Indian or Nepali Numbering Style.

2008-11-15T21:32:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } In the post http://techcreeze.blogspot.com/2008/11/convert-amount-into-words-according-to.html, I have talked about the converting amount (in number) to amount in words according to English Numbering Style. I am including here, source code of functions required for converting Number into

Compare records of Same SQL Table

2008-11-13T23:13:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you have to compare a record of SQL table to another record (which could be any), you would probably think of a nested while loop. Nested while loop is ok, but it may costlier. Here, I am discussing a trick to avoid loop to compare results.

Transport SQL Data from a server to another server

2008-11-11T22:01:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } Sometimes, you may want to copy data from a table of a server to another table to another server which is not connected to source server. What will you do? In fact, it is not much a deal. It can be easily done with

How to use data of another SQL Server?

2008-11-11T21:46:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } If you are inside a database server and want to use data from another database server, then, it is possible through linked servers. Link server links two servers. Through the use of link server, you can execute any queries in another server. You will have to map a local login (or all) to remote

Use calculated field in Excel Pivot Table

2008-11-08T22:05:00.002+05:30

Excel Pivot Table is an excellent tool for analyzing business data. I am talking here to discuss on a facility provided by Microsoft Excel. If you use Excel Pivot Table frequently, sometimes you may require data that can be obtained only from figures of pivot table and not from source data. Consider an example shown below. It simply shows the actual amt, plan amt, change amt and change

What is SQL Server Index?

2008-11-06T23:42:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } SQL Server Indexes are the objects used to optimize the performance of queries. It makes SQL queries select, update or delete run faster. The whole purpose of indexes is to make finding data rows in a table easier. If a table is created with no indexes, then the data rows are not stored in

Remove comments from SQL Server Stored Procedure.

2008-11-04T22:52:00.002+05:30

Comments have been a part of SQL Server procedures. If you work in ERP applications or other huge applications, then comments are even more important. They are kept for multiple purposes like to mark author, dates, causes, implications. But often, huge comments become so disgusting that, it becomes difficult to study the stored procedures. In multiple thousand line stored procedures in huge

Convert Amount into Words according to English Numbering Style.

2008-11-03T23:18:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } If you are application programmer, you may require displaying amount figures in words for user ease. For example, if the amount figure is $12445.41 then, in words, it becomes Twelve Thousand Four Hundred Forty Five and Forty One Cents Only.

Paging in Web Applications (SQL Trick)

2008-11-01T22:06:00.001+05:30

Web Applications here means the applications that are used through browsers. Web applications are tougher to develop and use as compared to windows applications. In this topic, I want to put focus on paging techniques for web applications. If you are a web programmer, you may be having problem to display a large report or data in a data grid with paging. Paging is required as it might not be

Factory Incentive Calculation System (FICS)

2008-11-01T01:10:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } Few months ago, I visited Simra for study of FICS (Factory Incentive Calculation System). It is an application implemented in that location for calculation of incentives ( additional pay besides salary) of workers in

Attendance Recording System (ARS)

2008-11-01T00:27:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } I work as a Application Support Manager in one of a leading companies of Nepal. During my visit to Simra for study of ARS (Attendance Recording System), I have prepared the following document. It includes the technical details and functional details that need to be maintained by Central IT team

Problems with Editor of Blogger.com

2008-10-28T23:45:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } If you have a little interest in blogging, then you must have heard name of blogger.com. It's the most popular blogging platform. It is owned by Google, leading company in Internet world. I have been using this since more than 2 years. In this post, I have tried to focus on a particular problem

Temporary Tables in SQL Server

2008-10-28T23:18:00.002+05:30

Temporary tables are tables used to hold data for temporary purpose. There are two types of temporary tables. 1. Local Temporary table 2. Global Temporary table Local Temporary table is a table created with "#" preceding the name of table. It exists till the connection to database, which has created it, lasts.

How to use Search in DOS mode?

2008-10-28T00:00:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } Suppose your Windows Search does not work due to some virus or malware, then how would you search for a file or folder? DOS Search is a very good utility provided by Microsoft. You will have to run the command prompt ( Start -> Run -> command) and using the following command.

Probable causes of high memory usage by SQL Server

2008-10-27T23:57:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } Under normal conditions, 2 GB RAM memory of database server dedicated to hold SQL Server databases for a multi-user application is more than enough. But, some times the memory usage becomes so high that, application users will not be able to use the application, letting system to knees. Then, the

How to find the cause of deadlock in SQL Server?

2008-10-27T23:51:00.000+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } If you are a database administrator or technical support person for a large application, you may have come across this problem. Sometimes users say that their application is hanging while doing some usual operations, like running report, fetching details, etc. The cause is due to dead lock in some

SQL: Datatype, Smalldatetime does not store second.

2008-10-25T22:37:00.002+05:30

Smalldatetime datatype is less precision version of datatime datatype. Datetime variable takes 4 bytes while smalldatetime takes 2 bytes of memory. If you do not require precision to second level then, it's ok to use smalldatetime. But problem comes when you use datetime and smalldatetime variables interchangeably.

SQL- Concatenate data in Table

2008-10-24T21:53:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } If you want to merge strings in different rows a table separated by a character (say comma[,]), then you can do so easily with a simple SQL Trick without requiring any loop. You just have to declare a varchar variable long enough to hold all data. and write a select statement for the table.

SQL: The table '#tbl_result' is ambiguous.

2008-10-24T21:40:00.001+05:30

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } If you are SQL programmer, there may be cases where you want to join same table multiple times to pull out same data. This is ok for select operation. But in case of update and delete operation, it may not be easy. The error "The table 'tablename' is ambiguos' comes while performing such update

How to change the columns of SQL Query output or table to rows?

2008-10-23T21:23:00.001+05:30

If you are database programmer, you may have come across this issue. There may be cases in which user should be allowed to enter data column wise. Here is an example. Suppose, for a manufacturing company, a user should enter plan volume to be produced in month wise basis. The screen provided should be like this.

What if your Windows Explorer Crashes?

2008-10-23T21:00:00.001+05:30

Windows Explorer is one of the major program that has to keep running always for us to use computer. But it may some times crash due to some virus, anti-virus or other threats. Then, we generally have to restart the machine. If it did not work, the other options remained are to boot in safe mode, or to start in "Last known good configuration". But these options may not work always.Some days

Warning: Null value is eliminated by an aggregate or other SET operation.

2008-10-23T11:47:00.000+05:30

If you are a programmer or database administrator, you must have come across this problem. But, this does not make a lot of difference usually. But we should be always aware of such warnings too. This problem usually comes while using multiple joins and aggregate functions like sum(), avg(), etc in SQL Server. The main cause is due to the fact the while aggregating some data may have null. And

Techreeze