Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,187 total)

  • RE: Identity Reseed

    Not so easy for me -- I got it wrong by picking 13. I thought that despite reseeding the INSERT would add one to the current max ID in the...

    May 24, 2011 at 7:33 am

    #1329054

  • RE: Login Properties

    Yay, I got this question right! (I know, I know, 50-50 chance....)

    I do have one follow-up question. One of our dev servers returned 1900-01-01 00:00:00.000 when I ran SELECT loginproperty('sa',...

    May 5, 2011 at 7:24 am

    #1320365

  • RE: Length

    Cliff Jones (4/8/2011)

    Hey, April Fools was LAST Friday!

    This gets my vote for best post in this thread.

    - webrunner

    April 8, 2011 at 8:13 am

    #1309191

  • RE: Length

    UMG Developer (4/7/2011)

    Argh! How does something this simple and wrong make it through. Did nobody actually run the code prior to posting the question? :w00t:

    Steve, oh Steve, Cleanup on isle...

    April 8, 2011 at 7:17 am

    #1309142

  • RE: You Don't Know Enough

    Steve Jones - SSC Editor (4/6/2011)

    Doh! I do need some QA. I must have typo'd it while adding the image.

    Here's the URL: http://www.schneier.com/blog/archives/2010/10/hacking_trial_b.html

    Thanks, Steve! I already wake up every day...

    April 6, 2011 at 7:25 am

    #1308008

  • RE: Dating for DBAs

    This was a great question. I got it wrong but appreciate the information. Thanks!

    - webrunner

    April 6, 2011 at 7:15 am

    #1308000

  • RE: Foreign Keys

    Peter Maloof (4/5/2011)

    mtassin (4/5/2011)

    I got this right, but the answer should be reworded that the LAST INSERT will fail. The first one works fine.

    Mark:

    Good point. Thanks for bringing it...

    April 5, 2011 at 9:00 am

    #1307502

  • RE: The Chance of Failure

    Steve Jones - SSC Editor (4/1/2011)

    Michael Valentine Jones (3/31/2011)

    Don't think of it as a failure.

    Think of it as a chance to start over without the burden of all that legacy...

    April 1, 2011 at 9:32 am

    #1306573

  • RE: The Chance of Failure

    Keith Langmead (4/1/2011)

    I think most IT people know they should be planning for failure, but until they have their first one it can hard to really take it seriously and...

    April 1, 2011 at 7:23 am

    #1306468

  • RE: The Chance of Failure

    Thanks for the good reminder, Steve, and the links.

    This may be covered in the links (haven't read them yet), but I recall reading a similar topic where it mentioned that...

    March 31, 2011 at 7:40 am

    #1305968

  • RE: Property Owner is not available for Database - root cause?

    Thanks, everyone, for this helpful information. I will go with setting the owner to sa as you recommended.

    - webrunner

    March 17, 2011 at 4:16 am

    #1299845

  • RE: Property Owner is not available for Database - root cause?

    CirquedeSQLeil (3/16/2011)

    webrunner (3/16/2011)

    CirquedeSQLeil (3/16/2011)

    Typically this error occurs for one of two reasons.

    1. The owner of the database was a domain account that is no longer valid (such as a...

    March 16, 2011 at 1:54 pm

    #1299630

  • RE: Property Owner is not available for Database - root cause?

    CirquedeSQLeil (3/16/2011)

    Typically this error occurs for one of two reasons.

    1. The owner of the database was a domain account that is no longer valid (such as a user's domain...

    March 16, 2011 at 1:21 pm

    #1299617

  • RE: NoSQL is Not the Answer

    I agree with everyone who's posted so far. I think the sensible approach is to see where NoSQL fits in and where SQL fits in and use the best tool...

    March 14, 2011 at 7:51 am

    #1298322

  • RE: Valentines Day

    OK, who voted for PostgreSQL?

    - webrunner

    February 14, 2011 at 2:52 pm

    #1286764

Viewing 15 posts - 661 through 675 (of 1,187 total)