Forum Replies Created

Viewing 15 posts - 7,366 through 7,380 (of 7,484 total)

  • RE: Rules!

    Scott Coleman (11/20/2009)

    You could quibble that the complete rule is not stored in sysobjects, since the rule definition is in syscomments. But sysobjects is the best answer of the...

    January 23, 2010 at 7:26 pm

    #1107861

  • RE: Easy Licenses

    Why might anyone contemplate using individual user CALs rather than server side per CPU licensing for anything other than a system with a very small numbert of users? Especially...

    January 23, 2010 at 7:18 pm

    #1107858

  • RE: Let's Talk Ownership (and SQL Jobs)

    Rob Fisk (11/24/2009)

    Yeah. I'd be really worried about the security implications of this.

    I thought it was a great article highlighting the problems that can arise from personally owned jobs.

    Pity it...

    January 23, 2010 at 12:59 pm

    #1107807

  • RE: A time and a place for the SQL Server Maintenance Plan Wizard

    Glad you changed your mind about the maintenance plan wizard - I would hate to be a raw new DBA without it.

    I make very little use of the maintenance plan...

    January 23, 2010 at 12:46 pm

    #1107803

  • RE: Cast as datetime question

    It's quite a good question, but I think the explanation of the answer could have been a bit better, since some may have reached the right answer for the wrong...

    January 22, 2010 at 2:20 pm

    #1107594

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Nice article, Gail, and a nice end to a nice series. The more I read the more I want to read more, because in articles like yours there is...

    January 22, 2010 at 1:46 pm

    #1107568

  • RE: REPLACE Multiple Spaces with One

    Paul White (12/5/2009)

    TheSQLGuru (12/5/2009)

    Oh dude, wouldn't that be SWEET! Now watch them say "yep, it's a bug, but we aren't gonna fix it because ..." 🙁

    True, true, true. ...

    January 22, 2010 at 12:08 pm

    #1107498

  • RE: REPLACE Multiple Spaces with One

    Michael Meierruth (11/18/2009)

    There is a recursive effect going on which I'm still trying to understand from a methematical point of view, i.e. for a given N+1 spaces what is the...

    January 22, 2010 at 9:25 am

    #1107420

  • RE: REPLACE Multiple Spaces with One

    C# Screw (11/18/2009)

    Hi Old Hand

    I hope you don't mind I wrapped you up in function

    >code cut>

    And here you are :

    Beginning execution loop

    Batch execution completed 10000 times.

    SQL: using ||*9*9||

    6570

    SQL: Jeffs...

    January 21, 2010 at 6:24 pm

    #1107046

  • RE: Is C# Better?

    What can you do in one that you can't do in the other? Well, that's a stupid question - both languages are Turing-complete, so apart from limitations imposed by...

    January 20, 2010 at 9:15 pm

    #1106461

  • RE: Consolidating Again and Again and Again

    The editorial is quite readable and sensible, but...

    I read the referenced article (actually just a quick skim read) and thought it was rather poor. Sure, we have to get...

    January 20, 2010 at 8:28 pm

    #1106455

  • RE: Introduction to Indexes: Part 2 – The clustered index

    GilaMonster (1/20/2010)

    Gentlemen, can you drop this please. It's not appropriate for the thread's topic and I'd rather not have Steve come and lock this because it got out of hand.

    Thank...

    January 20, 2010 at 6:36 pm

    #1106429

  • RE: Introduction to Indexes: Part 2 – The clustered index

    talltop-969015 (1/20/2010)

    I have gotten people fired in the past who say "it depends" all the time. Either give me a straight non-convoluted answer, or keep quiet or just say I...

    January 20, 2010 at 6:32 pm

    #1106428

  • RE: Latitude, Longitude and the nautical Mile

    Steve Jones - Editor (11/11/2009)

    It's a bit of trivia related to spatial information. If you work with data on the oceans, this can be valuable. It's not something most of...

    January 19, 2010 at 10:59 am

    #1105583

  • RE: A Better Way To Install Updates

    Steve Jones - Editor (11/11/2009)

    That might be true, though I don't think the Event Viewer actually queries for more up to date info. It would be good if you could...

    January 19, 2010 at 10:38 am

    #1105564

Viewing 15 posts - 7,366 through 7,380 (of 7,484 total)