Visual garbage Collector

A tools whic must be used by any java beginner to understand about the java object lifecycle. From Object instantiation. Object reference ,Object Destry.Object Garbage Collected.

More information can be found on the Sun website Visual GC.

SQL Server PIVOT - Magic isn't it

Ever wonders how you could present data via a select statement horizontally instead of vertically. When your columns come from the data you are retrieving from the select statement. The answer is simple in TSQL called the pivot keyword. All it would do is to use the data as the pivot to form the columns. Consider the simple schema of the employee: Product

• Name
• ID

Product Sales

• ID
• Agent ID
• Quantity
  

Agent

• Name
• ID

And lets say you want a result table which shows: Agent product year select a.name as 'Agent', p.name as "" from agent a inner join product_Sales pd on ps.agent_id=a.id inner join product p on p.id=ps.product_id PIVOT (SUM(Quantity) for Agent IN (Agent1, Agent2, Agent3)) AS pvt

Weblogic Boot up Authentication

Some trivial facts which can also be found under the weblogic documentation.

While trying to delete a few temp file from the weblogic domain. I had accidentally deleted the security directory as well.


When the server starts up it needs the authentication credentials either provided via a boot.properties file present in the server\security directory or else via the server prompt.

Storing the credentials in a file doesnt compromise security as this is then encrypted by the server as soon as it reads it for the first time.

Hence in order to avoid entering the weblogic username and password each time you want the server hosting your application to start , just store the credentials in a file called boot.properties.

the contents might look like this:

username=weblogic
password=weblogic

SQL Server Query comparing float fields

While running some queries on sql server comparing float fields I noticed the following:
For example:

I have a table temp with one column temp_value of type float.

select * from temp returns

2.395
5.678
0.36
1.987
4.65

Now let us say I had two variables:
value_a=0.21
value_b=-0.93

And I ran something like this:

select * from temp where temp_value = ((value_a+value_b)/2)

I would expect the record containing 0.36 to be returned from my query.

But No!!!!!

select * from temp where temp_value = (0.36)

I get the 1 record containing 0.36. Which is what I had expected from the previous query as well.

Lesson Learnt:

Never compare floats without considering the fact that the internal storage of floats might result in data being not comparable unless explicity rounded off before comparison.

SQL - Implicit Transactions - AutoCommit Off

One of things I always want when testing some sql scripts is a way to do undo the operation.

Its like wanting to test everything is fine and also not having to change the underlying database which you are testing.

I have found the solution , Implicit transactions. Which are transactions which do not commit any changes to the database until appropriate commands are executed.


Pros
This is helpful for testing any sql scripts, which run in a batch and we can test the integrity of the data and fix any errors by just not commiting the transaction.

Cons
Transaction take longer to process, as a lot of information is logged and stored in temp , so as to allow to commit the transaction later on.But this is not noticeable in small transactions. However if the transactions are in the range of tens of thousands, then I would use explicit transactions.


How to set query editor to perform implicit transactions

• Open SQL Server Management Studio
• Select Tools menu , options
• Select Query Execution
• Select ANSI
• Select Implicit Transactions

When this is selected , any transaction you perform thereafter on the query editors , the transactions will not be commited automatically. Its like having autocommit off.

In SQL Scripts you can achive this by manually adding the opration.
SET IMPLICIT TRANSACTIONS ON

This is a useful tip for people working on sql scripts.

Database Collation - Facts I have known

Database collation is a property of the database which defined how data is stored , compared and retrieved.

this is pretty useful in cases where your application wants to perform case sensitive search or language specific search.

For one of my projects I had to install SQL Server , by default SQL Server chooses a case insensitive collation , However I chose a case sensitive collation.

I realised that a collation affects not only the data which is stored in the database but also any of the system tables , views etc.

Any queries which have been written so far will now work only if they have referenced the tables views columns in the correct case.

However there are ways you get around this problem:

• Reset the collation of the database server by re-installing the server. This is crude but if you are facing lots of issues then this is one good option, but be sure to take backups of any databases which might have already created.
• Rewrite the queries with the correct case. This can be a tedious task , but its the correct way of sql scripting as far as I think.
• Chose the correct collation for any new database you create. This will ensure that any scripts which reference this database will need not worry about the case etc.

Since i was referencing the system tables in a very few places I had less issues.

But yes that's what I have know about collation.