Stithaprajyna

I use this blog to jot down what ever comes into my mind or get to see anything I feel is important.

Saturday, December 31, 2005

Photographs - Apunka Choice






Photographs - Apunka Choice

I will upload some of the photographs I felt has really come out good. A photographer's touch ;).

Lake Livingston

Picnic to Lake Livingston was very good. The place was really exotic. We really enjoyed the picnic. The photographs taken @ the lake are uploaded and the link is

Lake Livingston

Friday, December 30, 2005

Trip to San Antonio

Been to San Antonio for the two days (26th and 27th).
Visited the Natural Caverns, Wild life Ranch, Downtown, Wax Musuem in Alamo Plaza, Ripley's Believe it or not, the Haunted adventure, Tell a Tale and the River Walk.

The photos shot there are uploaded to the links below -

Natural Cavern

Ripley's Believe it or not

River Walk

The downtown

Tell a tale

The wax musuem

The wildlife Ranch

Saturday, December 24, 2005

SQL Server QOD

You are building a stored procedure for a quote generator in SQL Server 2000.
You have this stored procedure, but seem to be having trouble with quote 1, but not quote 2. What's wrong:

create procedure spQuoteGrab
@quoteid int
as
declare @quote varchar(100)
select @quote = convert( varchar, quotetext)
from
quotes
where
quoteid = @quoteid

select @quote 'quote'
return

Tuples of the table quotes

quoteid quotetext
------- --------------------
1 Now is the time for all good men to come to the aid of their country
2 Seize the day

Answer:
The first quote is truncated because no size is specified in the CONVERT function.SQL 2000 takes the length to be 30 by default
For further reading:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_7tpu.asp

Thursday, December 22, 2005

Anotheq SQL Question

declare @x as int -- for counter
declare @y as float -- for max counter
set @x = 0
set @y = 10
while @x <= @y
begin
print @xset @x = @x + 1
set @y = @y-0.67
end

What would be the result?? Do not run this. Just do an educated guess.

Answer: (Selected the below text as I am using the same text color as the background)

0, 1, 2, 3, 4, and 5 in separate rows

Speeding up the VS User Interface Load Time

By doing this, the load time would be faster.
This is applicable for both VS 2003 and 2005 but more appropriate for 2005

You can change the property of the shortcut to the IDE, as
"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" -nosplash

SQL Server QOD

This is the Question that appeared in SQL Central -

SELECT COUNT(*) AS OrderCount,
MONTH(OrderDate) AS OrderMonth,
YEAR(OrderDate) AS OrderYear
FROM Orders
GROUP BY OrderDate
ORDER BY OrderDate

Assume that the column and table names are correct and that OrderDate is a dateTime column. What is wrong with this query?

Answer:
The query will run without error, but will give the count of orders by order date, not summarized by month and year

Tuesday, December 20, 2005

Ancient Maya Mural Unveiled

U.S. archaeologists have discovered the "Sistine Chapel" of the Maya civilization — a finely painted, well preserved mural depicting the Maya creation myth and the crowning of a king.

Monday, December 19, 2005

Photographs taken in Houston

Photos of Houston Lake visit


Photos taken @ Galveston, Nasa Space Center and Keemah Board Walk


Photos taken @ Meenakshi Temple, Pearland


Photos taken @ Galleria mall, Downtown

Bill and Melinda Gates along with Bono named "Persons of 2005"

The richest man in the world, Bill Gates, and his wife, Melinda, were named Time magazine’s “Persons of the Year” along with Irish rocker Bono for being “Good Samaritans” who made a difference in different ways.