Tuesday, August 24, 2010

The ultimate Wedding Query... (SQL Style)

I am running the following SQL query among the databases instances I managed in different MS SQL servers for fun....

At that point, I should say that the desired "tuple" has not yet been found :-( . . . .




Details of the SQL query follow:

--
-- Funny query
-- Date: 25 August 2010
--
-- The ultimate Wedding Query................ (SQL Style)

-- HUSBANDS QUERY

CREATE PROCEDURE MyMarriage(BrideGroom Male (25),Bride Female(20) )
AS BEGIN
SELECT Bride FROM Beautiful_ Brides
WHERE FatherInLaw = 'Millionaire'
AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA, PHD) AND Having Brothers= Null
AND Sisters =Null


SELECT Gold, Shares, Cash, Car, BankBalance
FROM FatherInLaw
UPDATE MyBankAccout
SETMyBal = MyBal + FatherInLawBal
UPDATE MyLocker
SET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES('Porsche')
END
GO

-- Then the wife writes the below query:
DROP HUSBAND;
Commit;

-- (-:

Tuesday, August 17, 2010

My Super Server - version 2010

The server that is presented is as worth as the car below (second hand)! Next, see some snapshots I took from the Operating System (Windows Server 2008 RC2 64 bits).





The monster: HP Proliant ML570R G4 server



RAM: 16 x 4 GB = 64 GIGABYTES !!!!! I may tell you with this you will not have problems with multi threading.




STORAGE of 12 x 1000 Gigabytes (1.0 TB) = 12 Terrabytes !!!! = > 12.0 TB
Additional storage of 1.0 TB for C and D drives. See snapshot below.



Happy surfing!