Viewing 15 posts - 481 through 495 (of 673 total)
Craig Farrell (2/7/2011)
February 7, 2011 at 12:15 pm
Steve Jones - SSC Editor (2/7/2011)
February 7, 2011 at 11:59 am
RichB (2/7/2011)
What with them being inherently, disgracefully insecure.
Are you talking about the fact that they have to be stored in plain text in connection strings that are at the...
February 7, 2011 at 11:31 am
Nice question even if it was long winded. IMHO: Two points is a lot for a question that should be asked and answered correctly at any DBA interview.
This was...
February 7, 2011 at 9:35 am
To me this sounds like every IT project that was taken on by a manager that did not understand the technology or how to implement it and then outsourced. ...
February 7, 2011 at 9:25 am
gmby (2/7/2011)
I cannot seem to find any examples. I wonder if we are the only ones using config files in this fashion?
February 7, 2011 at 9:13 am
Ther is realy not enough information to form an intelligent answer. How do I know your system can properly handle a single DB file of this size without knowing...
February 4, 2011 at 9:40 am
rmechaber (2/4/2011)
February 4, 2011 at 9:15 am
Hugo Kornelis (2/4/2011)
There are other reasons for a checkpoint to not clear a VLF.
I also selected the right answer for the "wrong" reason. :w00t:
http://msdn.microsoft.com/en-us/library/ms345414.aspx
My new question today is does...
February 4, 2011 at 7:48 am
Craig Farrell (2/3/2011)
SanDroid (2/3/2011)
I was reading someplace that in MS SQL, the leaf level of a nonclustered index contains the clustered key columns that point back to the...
February 3, 2011 at 3:13 pm
Hugo Kornelis (2/3/2011)
SanDroid (2/3/2011)
There really isn't the concept of a clustered index that determines the physical order of records. Internally, Oracle uses a multi-part identifier called a...
February 3, 2011 at 2:44 pm
Chris Harshman (2/3/2011)
Indexes in Oracle don't quite work the same as they do in SQL Server.
I can imagine that they don't... 😛
There really isn't the concept of a...
February 3, 2011 at 10:51 am
Tom.Thomson (2/3/2011)
Hugo Kornelis (2/3/2011)
Great question!I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.
yes, it's a good questiopn. And yes, that half of the answers are...
February 3, 2011 at 9:24 am
Richard M Karpel (2/3/2011)
[/i] http://msdn.microsoft.com/en-us/library/ms177484.aspx
Richard this was the same article I used to verify my answer.
The Tables and Index Data Structures Architecture sections of the SQL 2008<R2>...
February 3, 2011 at 8:59 am
OCTom (2/2/2011)
A 50/50 shot on groundhog day. Good guess.:-D
This was an awesome Groundhog Day question.
February 2, 2011 at 4:28 pm
Viewing 15 posts - 481 through 495 (of 673 total)