Internals Of Indexing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

Internals Of Indexing

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-03 : 08:01:58

Moloy writes "Sir,
plz. elaborate

1.what is the internal mechanism of Indexing.
2.Types of Trigger.

Moloy Sarkar"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-05-03 : 08:24:00

Well there was Trigger the horse...

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-05-03 : 09:39:14

From Books Online:
"The fundamental unit of data storage in Microsoft® SQL Server™ is the page. In SQL Server 2000, the page size is 8 KB. This means SQL Server 2000 databases have 128 pages per megabyte."
Indexes are additional pages which list Bookmarks for easy reference to the records. Again, from Books Online:
"Bookmarks allow consumers to return quickly to a row. With bookmarks, consumers can access rows randomly based on the bookmark value."
Note, the index pages are typically allocated at the end of the data structure, and should not be confused with the header table, (also called the table of "contents"), located at the beginning of the data structure.

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2006-05-03 : 15:52:08

The wonderful thing about Triggers
Is Triggers are wonderful things
Their tops are made out of rubber
Their bottoms are made out of springs
They're bouncy, trouncy, flouncy, pouncy
Fun, fun, fun, fun, fun
But the most wonderful thing about Triggers
Is I'm the only one

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2006-05-04 : 03:13:17

There are quite a few types of trigger - see here

[url]http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml[/url]
[url]http://en.wikipedia.org/wiki/Trigger[/url]
[url]http://www.positro.net/trigger/[/url]
[url]http://www.freakytrigger.co.uk/[/url]
and last but cetainly not least
[url]http://www.roadsideamerica.com/pet/trigger.html[/url]

I'm sure I've missed a few too

steve

-----------

Oh, so they have internet on computers now!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources