Home

Previous 20

Sep. 15th, 2008

with battery, child, sleepy, childhood

Cool tip: finding all FKs to disable them for a bulk load

SELECT

C,C,KCU,C2,C2,C2,KCU2,RC,RC,C,C2

C.TABLE_CATALOG [PKTABLE_QUALIFIER], .TABLE_SCHEMA [PKTABLE_OWNER], .TABLE_NAME [PKTABLE_NAME], .COLUMN_NAME [PKCOLUMN_NAME], .TABLE_CATALOG [FKTABLE_QUALIFIER], .TABLE_SCHEMA [FKTABLE_OWNER], .TABLE_NAME [FKTABLE_NAME], .COLUMN_NAME [FKCOLUMN_NAME], .UPDATE_RULE, .DELETE_RULE, .CONSTRAINT_NAME [FK_NAME], .CONSTRAINT_NAME [PK_NAME], CAST(7 AS SMALLINT) [DEFERRABILITY]

FROM

 INFORMATION_SCHEMA

.TABLE_CONSTRAINTS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU ON C.CONSTRAINT_SCHEMA = KCU.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON C.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = RC.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS C2 ON RC.UNIQUE_CONSTRAINT_SCHEMA = C2.CONSTRAINT_SCHEMA AND RC.UNIQUE_CONSTRAINT_NAME = C2.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU2 ON C2.CONSTRAINT_SCHEMA = KCU2.CONSTRAINT_SCHEMA AND C2.CONSTRAINT_NAME = KCU2.CONSTRAINT_NAME AND KCU.ORDINAL_POSITION = KCU2.ORDINAL_POSITION

WHERE

C.CONSTRAINT_TYPE = 'FOREIGN KEY'

from: http://www.mssqltips.com/tip.asp?tip=1151
with battery, child, sleepy, childhood

No schema compare!





Also, https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=365718

Oct. 20th, 2007

with battery, child, sleepy, childhood

Trying CouchDB: Day 1

http://localhost:8888/$utils/peek.html

Create DB: A database must be named with all lowercase characters (a-z), digits (0-9), or any of these characters `_$()+-/` and must end with a slash in the URL.

1> [info] [<0.152.0>] HTTP Request: PUT /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","0"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.152.0>] HTTP Response Code:201

Create document:

1> [info] [<0.165.0>] HTTP Request: POST /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","142"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"content-type","text/xml; charset=UTF-8"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.165.0>] HTTP Response Code:201

  <?xml version="1.0" ?>
- <doc id="60CF2C862F0EB074646574E28DD71919" rev="D4BA5040" xmlns="http://couchdb.org/doc">
- <field name="FirstName">
  <text>Apoorv</text>
  </field>
- <field name="LastName">
  <text>Shrivastava</text>
  </field>
  </doc>

Create table:

/* Tables are just special documents, but don't forget to give them unique names! */

* Set the table statement. You can use the fabric language for that.
     * Note that every field has to start with $table_ !
     */
select statement: select *

Oops!

  <?xml version="1.0" ?>
- <doc id="1" rev="F2CD1E07" xmlns="http://couchdb.org/doc">
- <field name="$table_$table_1">
  <text>select *</text>
  </field>
  </doc>

now:

Table id : 60CF2C862F0EB074646574E28DD71919
Table name : keeda_tablewithidsameasanotherexistingdocument
Select Statement : select *

1> [info] [<0.214.0>] HTTP Request: POST /try1/ HTTP/1.1
Header:[{"cache-control","no-cache"},
        {"connection","Keep-Alive"},
        {"content-length","171"},
        {"host","localhost:8888"},
        {"user-agent",
         "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0
.50727; .NET CLR 3.0.04506; .NET CLR 1.1.4322; MS-RTC LM 8)"},
        {"accept-encoding","gzip, deflate"},
        {"ua-cpu","x86"},
        {"content-type","text/xml; charset=UTF-8"},
        {"referer","http://localhost:8888/$utils/peek.html"},
        {"accept-language","en-us"},
        {"accept","*/*"}]
1> [info] [<0.214.0>] -HTTP Error-
        Response Code: 409.
        Error id: conflict
        Error message: conflict
1> [info] [<0.214.0>] HTTP Response Code:409

Oct. 1st, 2007

with battery, child, sleepy, childhood

Haiku Operating System

 

Haiku Operating System rocks! Absolutely!!

Always wanted to try the BeOS ... read a lot, couldn't touch it. Great work!

with battery, child, sleepy, childhood

Interesting timeline

 

Share This : Timeline — Google, Yahoo!, Microsoft, & Amazon

Sep. 20th, 2007

with battery, child, sleepy, childhood

Orkut's new limit on album size

OrkutNewAlbumSize 

Orkut has increase the maximum number of photos in an album from 12 to 25.

Sep. 10th, 2007

with battery, child, sleepy, childhood

Looks like Mariners can only win over the Tigers!

Mariners score 13 runs in first 4 innings against Tigers and cruise to 14-7 win

with battery, child, sleepy, childhood

I, Simpsonized

I, Simpsonized

with battery, child, sleepy, childhood

Nerd Test 2 details

Your Score Summary

For Science/Math:

4% scored higher,
0% scored the same, and
96% scored lower.

For Computers/Technology:

1% scored higher,
1% scored the same, and
98% scored lower.

For Sci-Fi/Comic:

44% scored higher,
5% scored the same, and
51% scored lower.

For History/Literature:

24% scored higher,
4% scored the same, and
72% scored lower.

For Dumb/Dork/Awkwardness:

54% scored higher,
15% scored the same, and
31% scored lower.

with battery, child, sleepy, childhood

Nerd Test 2

NerdTests.com says I'm a Nerd God.  What are you?  Click here!
with battery, child, sleepy, childhood

Nerd test 1

I am nerdier than 90% of all people. Are you a nerd? Click here to find out!

Sep. 9th, 2007

with battery, child, sleepy, childhood

Vista blocks IE

 

Vista blocks IE

Aug. 9th, 2007

with battery, child, sleepy, childhood

Jabra BT620s - Stereo Bluetooth headset for music phones and iPod, MP3 players

 

My 

Jabra BT620s - Stereo Bluetooth headset for music phones and iPod, MP3 players

rocks :-)

Jul. 28th, 2007

with battery, child, sleepy, childhood

Saw "Star Trek: Nemesis" today

 

Star Trek: Nemesis - Wikipedia, the free encyclopedia

Quotable quotes:

Data: I will always be puzzled by the human predilection for piloting vehicles at unsafe velocities.

Jean-Luc Picard: [while being shot at during a car chase] I think it's time to try some unsafe velocities!

Data: I must deactivate you.
B-4: For how long?
Data: Indefinitely.
B-4: How long is that--
Data: A long time, brother.

Jul. 26th, 2007

with battery, child, sleepy, childhood

Radio is good

 

http://66.238.65.109/bollywood

Windows Media Audio V2
16 kbps, 16 kHz, stereo

Jul. 17th, 2007

with battery, child, sleepy, childhood

Zen TV Experiment

 

A good read ...

Some nice observations:

  1. When you turn the TV on, in effect, you turn the world off. The TV is only two feet high or so, yet we are fooled into thinking we are watching life-sized things. How is it that everything on it appears real and life-like?
  2. To watch TV programs is to be lifeless and unresisting. This is the state that allows the commercials to take full effect and operate our minds for us.
  3. As one formula puts it, Media Power = Political Power Squared The TV has shown us that politicians can't be trusted but TV can. That is, according to Joshua Meyrowitz in No Sense of Place, implicit in showing us this about politicians is the message, "We who are showing you this, the TV, can be trusted." We can trust TV, and the institution of TV, to reveal how politicians and the institution of politics can't be trusted.
  4. In the words of Mat Maxwell, "Television becomes the world for people... . The world becomes television."

Is the future of video games too? In particular, the parallels?

Zen TV Experiment

Jul. 16th, 2007

with battery, child, sleepy, childhood

Slow down and enjoy the Vista animations

 

Slow down and enjoy the Vista animations

Slow down and enjoy Vista ... and I thought I was the only one thinking about how Vista Animations slow you down!

Jul. 15th, 2007

with battery, child, sleepy, childhood

Johjima's GS Breaks It Open for Mariners - Forbes.com

 

Kenji Johjima hit a game-breaking grand slam off Kenny Rogers, and Miguel Batista held the highest scoring team in the major leagues to one run in six innings as the Seattle Mariners beat the Detroit Tigers 6-4 on Saturday night.

I was there, and though I don't know a lot of the rules, I enjoyed the game thoroughly.

Thank you MAQ

Johjima's GS Breaks It Open for Mariners - Forbes.com

-128w_2551

Jun. 20th, 2007

with battery, child, sleepy, childhood

GUID Generator

 


TommyCarlier wrote:


Applications like this are EVIL! Everybody just keeps producing GUIDs like crazy. And one day, we'll run out of GUIDs, and we'll be doomed to wander the planet GUIDless. You'll see.

I know you weren't being serious but still.
Let's say I generate one billion (1,000,000,000) GUIDs per second. That makes 31,536,000,000,000,000 GUIDs per year.
Then it would still take me 2128 / 31,536,000,000,000,000 years = 10,790,283,070,806,014,188,970 years 193 days 3 hours 23 minutes and 51 seconds (not accounting for leap years) before I can generate them all.
So something tells me we needn't worry that much.
(This reminds of that article where MSDN columnist Dr. GUI claimed that there were more GUIDs than atoms in the universe, and someone mailed him proving that the sun alone already contains more than 2128 atoms thus proving him wrong rather spectacularly )

GUID Generator

Jun. 16th, 2007

with battery, child, sleepy, childhood

Doolwind's Game Coding Site

 

Your programmer personality type is:
DHTB

You're a Doer.
You are very quick at getting tasks done. You believe the outcome is the most important part of a task and the faster you can reach that outcome the better. After all, time is money.
You like coding at a High level.
The world is made up of objects and components, you should create your programs in the same way.
You work best in a Team.
A good group is better than the sum of it's parts. The only thing better than a genius programmer is a cohesive group of genius programmers.
You are a liBeral programmer.
Programming is a complex task and you should use white space and comments as freely as possible to help simplify the task. We're not writing on paper anymore so we can take up as much room as we need.

Doolwind's Game Coding Site

Previous 20

with battery, child, sleepy, childhood

September 2008

S M T W T F S
 123456
78910111213
14151617181920
21222324252627
282930    

Advertisement

Syndicate

RSS Atom
Powered by LiveJournal.com