Viewing 15 posts - 16 through 30 (of 31 total)
Paul White NZ (4/1/2010)
Thanks, everyone. Glad I am not the only one to find this whole area fascinating.
Yes, I do too [for reasons unfathomable]
And I'm glad I kinda kicked...
April 1, 2010 at 9:47 am
Tom.Thomson (3/20/2010)
vk-kirov (3/20/2010)
Tom.Thomson (3/19/2010)
But a single select statement may write more pages than can be held in RAM and this means that dirty pages get to disc"Insert statement", I believe?
Yes,...
March 29, 2010 at 11:29 am
On a restore, first all data pages are restored; then the log entries included in the backup are used to
a) roll forward any transactions that were committed while the backup...
March 17, 2010 at 9:09 am
I didn't know that CUBE and ROLLUP were non-standard in 2005 but are different in 2008. That's good; I've learned something.
Also, if Itzik says that something about SQL Server...
October 2, 2009 at 7:05 am
... other types of database that would not necessarily be suited to operation under the Full Recovery Model include ... databases that experience discrete infrequent modifications.
I cannot agree with you...
September 21, 2009 at 3:59 pm
From the title of this article, I was expecting much more on why I should be using the Full Recovery Model. Instead, I got an introduction to data loss...
September 21, 2009 at 3:51 pm
If you would like the default recovery model to be Full, then change the recovery model on the model database.
September 21, 2009 at 3:43 pm
William Vach (10/15/2008)
This appears to more of an advertisement than an article. There are some down sides to oursourcing the DBA function and those are not mentioned.
I agree with...
October 15, 2008 at 7:23 am
It's nice to see zipped files being used by SSIS, and most of the article was good, but surely there's a bug in this code:
If Len(strDay) = 1 Then
strMonth =...
September 22, 2008 at 10:05 am
There are two facts needed to answer this question correctly:
1) RANGE LEFT is the default.
2) Partitions start numbering at one, not zero.
I was only half-way there.
August 11, 2008 at 9:49 am
I have to admit, I was totally distracted by the caret, and didn't even consider bitwise ops. Nice distraction.
There are problems with the question, though.
Why is @b-2...
August 7, 2008 at 8:23 am
An average article. From the title I expected much more than brief mention of two new features. And no, the splash screen doesn't count.
Pasting screenshots of cool features does...
July 30, 2008 at 12:25 pm
I have struggled to understand this article not because of the technical content but because of the strange punctuation, inconsistent tenses, and pathetic grammar. Either English is not your...
May 23, 2007 at 6:36 am
Badly written? I must agree.
If one of your intended incorrect answers is "There is a error in Statement X" then you must make absolutely sure that there is no error...
August 11, 2005 at 12:57 pm
Answer # 3: @var LIKE '[0-9,A-Z]%'
This matches strings whose first character is a digit, a letter, or a comma, followed by anything.
[Ignoring for now the discussion about collation]
June 2, 2005 at 9:07 am
Viewing 15 posts - 16 through 30 (of 31 total)