Wednesday, June 4, 2008
AGT : A Greener Tomorrow --->>> HATS OFF TO SUMTOTAL SYSTEMS
WED with SumTotal!!! June 5, 2008 @ 4.30 pm @ Maximus Towers, Raheja Mind Space.
WED is the Acronym for World Environment Day and is being celebrated globally on June 5th. This year, the theme is "CO2 - Kick the Habit! Towards a Low Carbon Economy".
SumTotal chooses to "Pick Right", and help conserve the environment. We need your support in spreading the awareness of "A Greener Tomorrow" through AGT.
SumTotal Systems with the support of Raheja Mindspace will be taking a Green Walk along the road to Durgam Cheruvu and back to spread message of a healthier environment.
The more the merrier. Please extend your helping hand; inform your employees and confirm your participation in reply to this email.
It costs nothing, but helps in making a greener and healthier tomorrow :)
The link below has a host of initiatives advised by the United Nations that you could take up at your end.
http://www.unep.org/wed/2008/english/Information_Material/Alphabet.asp
Request your participation to make this event a huge success, please email us at AGT-Hyd@sumtotalsystems.com if you have any questions.
We look forward to your participation.
TEAM- AGT
45-second delay when you run a full-text query
Microsoft Full-Text Engine for SQL Server (MSFTESQL) tries to load the word breaker related to the query which in turn requires an Internet connection
Also, MSFTESQL unloads a word breaker that is not been in use for 300 seconds to reduce resource consumption. Hence,from the next time that the work breaker is loaded, signature verification is required again.
Frozen rose + Hammer + Petals + Life
When your science teacher smashed a frozen rose with a hammer,
did you warm the petals to bring them back to life?
did you warm the petals to bring them back to life?
Tuesday, June 3, 2008
SQL Server : Issue with OSQL.EXE when input file is more than 12 mb
My little experience with OSQL is very annoying especially when I gave a file of more than 10 mb as a input file.
The i/p file has just set of stored procedures with drop command to drop the proc if it exists then to create the proc. But, interestingly OSQL has dropped and recreated many procedure but failed to drop one particular proc but tried to create the new one and hence the issue.
I spent several hours goggling on Google to get the data around any internal buffer limit on OSQL but ended with no luck. But able to get rid of the error by changing the order of the procedures. Frankly I don't know why it is working but hoping for it to continue to work.
Script to execute a script with OSQL:-
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>OSQL -n -S <> -U sa -P <> -d <> -i NewProcedures.sql -o Output.txt
The i/p file has just set of stored procedures with drop command to drop the proc if it exists then to create the proc. But, interestingly OSQL has dropped and recreated many procedure but failed to drop one particular proc but tried to create the new one and hence the issue.
I spent several hours goggling on Google to get the data around any internal buffer limit on OSQL but ended with no luck. But able to get rid of the error by changing the order of the procedures. Frankly I don't know why it is working but hoping for it to continue to work.
Script to execute a script with OSQL:-
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>OSQL -n -S <
Sunday, June 1, 2008
SQL Server: Index entry for rowID was not found in index ID 4, of table 2009058193, in database
The issue looks be an issue with collation of the restored data base.
Could you please verify the same and follow the instructions given in the URL to correct the issue: http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
If this doesn't works then get the table name involved in the issue by running the query @ select * from sysobjects where id=@ID from error
Then run the DBCC checktable command on the table.
dbcc checktable ('@Table Name', REPAIR_FAST)
Could you please verify the same and follow the instructions given in the URL to correct the issue: http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
If this doesn't works then get the table name involved in the issue by running the query @ select * from sysobjects where id=@ID from error
Then run the DBCC checktable command on the table.
dbcc checktable ('@Table Name', REPAIR_FAST)
Why is a manhole cover round?
http://www.allinterview.com/showanswers/15003.html
The manhole covers which are Square or rectangle can be
easily put inside the hole by holding it diagonally.
But in case of circle, it is same in all the angles and safe
to use for man holes.
Computing Stats on GTT : Oracle
It seems there is much impact with computing the stats on global Temporary tables(GTT), especially on the production environments.
Oracle 10g has some features to stop computing stats on GTT but we need to enable the dynamic sampling to allow oracle to compute the stats as and when required.
It looks to be working better now on production, at least for me. :)
Oracle 10g has some features to stop computing stats on GTT but we need to enable the dynamic sampling to allow oracle to compute the stats as and when required.
It looks to be working better now on production, at least for me. :)
Computing the stats on temporary table - Oracle
tables{GTT}.
Especailly, Oracle 10G does gr8 job. if it is able to calculate the stats on GTT instead of we doing this?
Does any one has experience with this? Any thoughts around this would help me in achieving my goal.
Especailly, Oracle 10G does gr8 job. if it is able to calculate the stats on GTT instead of we doing this?
Does any one has experience with this? Any thoughts around this would help me in achieving my goal.
Sometimes at night, when I look to the sky,
I start thinking of you and then ask myself, why?
Why do I love you? I think and smile,
because I know the list could run on for miles.
I asked God for a flower, he gave me a bouquet
I asked God for a minute, he gave me a day
I asked God for true love, he gave me that too
I asked for an angel and he gave me **********
The first satellites
The theory of satellites was simple enough - shoot something out into space at the right speed and on the correct trajectory and it will stay up there, orbiting Earth, for years - if not forever.
And if that orbit is just the right distance out in space the satellite will keep pace with the rotation of the Earth - remaining on station out there in the skies.
Theory was one thing - but achieving the vision was not so simple.
And if that orbit is just the right distance out in space the satellite will keep pace with the rotation of the Earth - remaining on station out there in the skies.
Theory was one thing - but achieving the vision was not so simple.
Subscribe to:
Posts (Atom)