March 12, 2009 at 11:21 am
Just saw this one:
prvreddy (3/12/2009)
Hi all,1)Why a table have maximum one clustered index ?
2)Please give me basic definitions of clustered and non-clustered indexes!
3)What is fragementation and defragmentation?
Please help me in this regard.
Thanks in advance
vijay
And I have to admit to having a terrible temptation to answer with:
Tell your interviewer:
1. Duh! Because!!!11one!!
2. They're indexes that are clustered, or non-clustered.
3. Fragmentation is what grenades do. Defragmentation is what military doctors do after grenades have done it.
Maybe I'm too cynical, but I do have to admit to temptation on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 12, 2009 at 11:24 am
Roy Ernest (3/12/2009)
Barry, You have kept us in the dark about this till now. Time to reveal it..:)ABCD puppies?
LMNO puppies!
SDR, CMPN?
That one was translated. Look back a few few pages, you'll find it.
It's "Abe, see the puppies?" "H--l them no puppies!" "Yes they are, see them peeing." Loosely, anyway.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 12, 2009 at 11:36 am
GSquared... I liked this one.... :hehe:
3. Fragmentation is what grenades do. Defragmentation is what military doctors do after grenades have done it.
-Roy
March 12, 2009 at 11:44 am
... 1)Why a table have maximum one clustered index ?
Answer:
Unfortunately, you can only order the data by one set of columns at a time. This may change at a later date as computer technology evolves. After "Cloud" computing we may see a versions of SQL server that run in parallel dimension. Running in a different universe may offer that capability. I believe that was demonstrated on Star Trek TNG.
🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 12, 2009 at 11:47 am
I'm just glad they're coming here instead of Google first 🙂
March 12, 2009 at 11:52 am
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂
Yeah. You can buy pork chops in bulk now and get a much better price.
😛
I know, it's better for them to come here where they have a better chance of getting the right information.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 12, 2009 at 11:58 am
Why would people encrypt the stored proc when there are so many tools out there that can decrypt??:blink:
-Roy
March 12, 2009 at 12:05 pm
Roy Ernest (3/12/2009)
Why would people encrypt the stored proc when there are so many tools out there that can decrypt??:blink:
It's often done in 3rd party apps to make it if not impossible to change the proc, more difficult. Also many people don't know that is is possible to decrypt. They see the word ENCRYPTION and think it's like the encryption used by SSL and similar. Near-impossible to decrypt in reasonable time if you don't have the encryption key.
Of course, it can't be that strong. The DB engine has to be able to decrypt the procedures otherwise it wouldn't be able to run them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2009 at 12:55 pm
GilaMonster (3/12/2009)
Of course, it can't be that strong. The DB engine has to be able to decrypt the procedures otherwise it wouldn't be able to run them.
Heh, I could just see it... someone calls the consultant in to figure out why the SQL server isn't working. The consultant pulls up the stored proc and sees...
%$T^*(JHW@#E#@ER$#RDF (plus all the other funky characters that come up in encrypted text)
Now that would be a pain to fix a server that was suddenly not working because of code/table changes that messed up the encrypted stored procedure. You'd never know what to fix to get things working again.
-- Kit
March 12, 2009 at 1:14 pm
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂
As an MVP aren't you disappointed they didn't use Live search?:P
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 12, 2009 at 1:17 pm
Roy Ernest (3/12/2009)
Barry, You have kept us in the dark about this till now. Time to reveal it..:)ABCD puppies?
LMNO puppies!
SDR, CMPN?
Bob already got 95% of it, but here you go:
Abbie, see de Puppies?
'ell, 'em 'en no Puppies!
'es de are, see 'em pee'n?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 12, 2009 at 1:36 pm
Jack Corbett (3/12/2009)
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂As an MVP aren't you disappointed they didn't use Live search?:P
Live what?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2009 at 1:47 pm
Hey Gail, where does your signature line come from? Is that original?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2009 at 1:52 pm
Bob Hovious (3/12/2009)
Hey Gail, where does your signature line come from? Is that original?
Hardly original.
We walk in the dark places no others will enter
We stand on the bridge and none may pass
We live for the One
We die for the One
Entil'zha Veni
In Valen's Name
It's the Ranger oath from Babylon 5. The Rangers (Anla'shok in one of the Minbari tongues) were sworn to guard against the Shadow, no matter the cost.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2009 at 1:54 pm
I just went to an interview and...
full backup of the database filegroup is just like getting a full backup of the database
http://www.sqlservercentral.com/Forums/Topic674621-357-1.aspx
If he demonstrated that attitude in an interview, I wouldn't hire him either, never mind the distinction between full and filegroup backups
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 2,521 through 2,535 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply