Viewing 15 posts - 7,291 through 7,305 (of 7,484 total)
Jeff Moden (2/22/2010)
Loner (2/22/2010)
JeffWhy don't you post your 'perfect' answer?
I can tell you why... people would simply memorize instead of taking the time to figure it out. 😉
Well,...
February 22, 2010 at 9:36 am
Jeff Moden (2/21/2010)
February 22, 2010 at 9:15 am
A nice question.
It's pretty appalling that 8% of people chose the "error message" answer, though.
I'm much less surprised about the 17% who got it wrong to...
February 22, 2010 at 7:40 am
For customer systems we would agree each outage with the customer. Customer contracts provided for down time for security updates and general maintenance monthly, but some customers were very...
February 21, 2010 at 3:58 pm
A good question.
It took me a while to work out because it relies on the fact that ','+d.Colors doesn't have a column name so that for xml path...
February 21, 2010 at 3:33 pm
Steve Jones - Editor (2/15/2010)
The question has had the version added.
But it still says SSRS, which surely is the name used from SQLS 2005 onwards, not the one used in...
February 18, 2010 at 10:02 am
This is a very good article indeed. Something every new DBA or would-be DBA should read and take to heart.
The only thing that doesn't come across clearly is just...
February 18, 2010 at 9:42 am
It varies from databse to database. There are in-house databases and databases at the customer sites, databases that change rapidly and databases that change rarely and databases that are...
February 18, 2010 at 9:06 am
Steve Jones - Editor (2/11/2010)
This is definitely a place where the OS and SQL should align the partitions and align the cluster/page size when you create a DB as well.
Also...
February 17, 2010 at 5:38 pm
Rune Bivrin (2/12/2010)
If you do
SELECT @var =...
February 17, 2010 at 5:01 pm
Allen Nugent (2/9/2010)
Nice work, Mark.
I'll second that - a very nice article indeed.
Of course, there are weird and wonderful techniques for fitting data to nonlinear functions, but it might...
February 17, 2010 at 1:23 pm
Steve Jones - Editor (2/17/2010)
February 17, 2010 at 12:45 pm
paul.knibbs (2/9/2010)
Problem is, they're local admins--they can get round stuff like that!
It's extremely difficult, probably impossible, on a properly configured modern Windows system - Group Policy settings can be made...
February 17, 2010 at 6:08 am
The startling thing in the editorial, for me anyway, is the line
And if they logged onto Windows as "administrator", you won't know who they are.
That makes me ask why...
February 17, 2010 at 5:58 am
Viewing 15 posts - 7,291 through 7,305 (of 7,484 total)