Forum Replies Created

Viewing 15 posts - 151 through 165 (of 285 total)

  • RE: DBA Concerns

    drowlfs (3/10/2011)

    TravisDBA (3/10/2011)

    I once worked with a company where the IT manager gave SYSADMIN access to all of his developers on the production db servers.

    I kind of agree with that...

    March 10, 2011 at 6:12 am

    #1297030

  • RE: Visual Studio Tools

    Jamie Thomson (3/10/2011)

    This one may be particularly useful: Visual Studio 2010 SQL Server Database Projects

    Thanks for the links - I discovered after I posted that you have a number of...

    March 10, 2011 at 5:53 am

    #1297022

  • RE: Visual Studio Tools

    mohammed moinudheen (3/9/2011)

    I had no idea about the answer, I guessed it and got it right. 🙂

    Off late, there are so many questions on Visual Studio tools in QotD section....

    March 10, 2011 at 5:25 am

    #1297005

  • RE: Sorting data issue

    Maybe this is a silly question, but couldn't you just use a stored procedure

    CREATE PROC Proc1

    AS

    SELECT b,a,c,f,g,e

    FROM Table1

    ORDER BY c

    and then ask the user to run "EXEC Proc1" to get...

    March 10, 2011 at 1:35 am

    #1296920

  • RE: ROWGUIDCOL

    Tom.Thomson (3/9/2011)

    Most of the time no-one bothers to be precise - the common feeling is something like "what's the point of complete precision" (except when writing about mathematical logic, or...

    March 10, 2011 at 1:13 am

    #1296918

  • RE: Restoring after TRUNCATE TABLE

    wware (3/9/2011)

    Good question. Please don't hesitate to submit more. I speak for the 62% who read the question as you intended and answered correctly. Our knowledge was...

    March 10, 2011 at 1:00 am

    #1296917

  • RE: Restoring after TRUNCATE TABLE

    Steve Jones - SSC Editor (3/9/2011)

    It's clear to me, and if you think there is some implication that you are restoring to some specific point in time, you are reading...

    March 9, 2011 at 9:02 am

    #1296579

  • RE: ROWGUIDCOL

    SanDroid (3/9/2011)

    Duncan,

    You are correct in all your statements.

    Unforetunately none of them had anytihng to do with the fact that the question was not incorrect in its use of the...

    March 9, 2011 at 8:28 am

    #1296551

  • RE: Restoring after TRUNCATE TABLE

    SanDroid (3/9/2011)

    Duncan Pryde (3/9/2011)

    Gobikannan (3/8/2011)

    I learned something form this question., Nice question.

    Thanks, glad you liked it.

    Duncan

    Duncan,

    I learned something also.

    I learned I am not the only person that was...

    March 9, 2011 at 8:16 am

    #1296542

  • RE: ROWGUIDCOL

    SanDroid (3/9/2011)

    Tom.Thomson (3/8/2011)

    SanDroid (3/8/2011)

    Tom.Thomson (3/8/2011)

    The right answer of course is "each of them can (but only one at a time)" so of the options provided 3 is closest to correct....

    March 9, 2011 at 8:11 am

    #1296533

  • RE: Restoring after TRUNCATE TABLE

    SKYBVI (3/9/2011)

    Duncan Pryde (3/9/2011)

    SKYBVI (3/9/2011)

    Good question

    i would like to ask, we can restore at 9:15 right?

    But not after that?

    Regards,

    Sushant

    No, TRUNCATE TABLE doesn't affect point-in-time restore, so you can restore to...

    March 9, 2011 at 7:42 am

    #1296506

  • RE: Restoring after TRUNCATE TABLE

    mvelic (3/9/2011)

    It's true. Besides, it's causing a good amount of discussion here about how point-in-time restores work, so even if it wasn't clear up front, people are still learning. Thanks...

    March 9, 2011 at 6:53 am

    #1296474

  • RE: Restoring after TRUNCATE TABLE

    mvelic (3/9/2011)

    Well, I got this wrong but I think I would have worded it differently. If you don't take a tail of the log backup after the TRUNCATE TABLE (or...

    March 9, 2011 at 6:40 am

    #1296462

  • RE: Restoring after TRUNCATE TABLE

    SKYBVI (3/9/2011)

    Good question

    i would like to ask, we can restore at 9:15 right?

    But not after that?

    Regards,

    Sushant

    No, TRUNCATE TABLE doesn't affect point-in-time restore, so you can restore to any time you...

    March 9, 2011 at 6:37 am

    #1296460

  • RE: Restoring after TRUNCATE TABLE

    Jim Sleeman-388184 (3/9/2011)

    Trick Question and answer

    It certainly wasn't meant to be. Thanks for the feedback though.

    March 9, 2011 at 6:36 am

    #1296459

Viewing 15 posts - 151 through 165 (of 285 total)