Viewing 15 posts - 1 through 15 (of 327 total)
majorbloodnock (1/16/2013)
patrickmcginnis59 (1/15/2013)
If the interviewee is going to fool a completely competent and prepared interviewer, he's going to fool the...
January 16, 2013 at 8:56 am
Let me try working through a few variables on this one!
If the interviewee is going to fool a completely competent and prepared interviewer, he's going to fool the SQL forums...
January 15, 2013 at 1:21 pm
One characteristic of "big data" I've noted seems to be that the dataset isn't easily contained and managed in a single server instance. "Sharding" comes to mind, and once you...
January 9, 2013 at 10:03 am
This is just opinion about why I disagree with the article and its conclusions.
Theres a test that fails, but its a test. By its very definition, its a bit of...
January 7, 2013 at 4:27 pm
CELKO (12/27/2012)
I guess PK means “NOT NULL PRIMARY KEY”, but a good SQL programmer never uses IDENTITY for a key.That's hilarious. Care to explain why?
I would like to second this...
December 28, 2012 at 1:31 pm
GilaMonster (12/28/2012)
patrickmcginnis59 (12/28/2012)
GilaMonster (12/28/2012)
patrickmcginnis59 (12/28/2012)
I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.
The RID is nothing more than...
December 28, 2012 at 1:07 pm
hakim.ali (12/28/2012)
patrickmcginnis59 (12/28/2012)
Sounds like a pretty efficient index to me 🙂
If it were an index, then why would the database scan every record in a heap when you were searching...
December 28, 2012 at 12:54 pm
GilaMonster (12/28/2012)
patrickmcginnis59 (12/28/2012)
I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.
The RID is nothing more than an 8-byte...
December 28, 2012 at 12:39 pm
hakim.ali (12/28/2012)
December 28, 2012 at 10:22 am
DaleB (12/24/2012)
December 24, 2012 at 8:13 am
Let's assume there is no clustered index on this table. This makes it a heap, meaning the rows are not physically written to disk in any particular order. When you...
December 24, 2012 at 6:28 am
samalex (12/20/2012)
dwain.c (12/19/2012)
Have you considered using MERGE?http://technet.microsoft.com/en-us/library/bb510625(v=sql.105).aspx
Thanks, but I already looked at MERGE, and I don't think it'll work for me, at least not using a single statement. It...
December 20, 2012 at 10:00 am
GSquared (12/19/2012)
December 19, 2012 at 9:44 am
GSquared (12/19/2012)
From: http://websters-online-dictionary.org/definition/technology
Technology is a broad concept that deals with a species' usage and knowledge of tools and crafts, and how it affects a species' ability to control...
December 19, 2012 at 9:12 am
GSquared (12/19/2012)
tech·nol·o·gy[ tek nóll?jee ]tech·nol·o·gies Plural
NOUN
1. application of tools and methods: the study, development, and application of devices, machines,...
December 19, 2012 at 7:17 am
Viewing 15 posts - 1 through 15 (of 327 total)