Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 18,923 total)

  • RE: Delete Query

    Raghavender (4/26/2011)

    Hi All,

    We need to delete some millions of rows from a table.

    And we need this should not affect transactional log file.

    Is there a way to achieve this ?

    Impossible.

    The best...

    April 26, 2011 at 5:52 am

    #1315789

  • RE: NEED HELP= Monthly SQL database growth calculation script

    Did you actually run my script? It gives you the date you're going to runout of space on EACH drive on the server + the next autogrowth event.

    Also it...

    April 25, 2011 at 4:38 pm

    #1315647

  • RE: OUTPUT & NEWID()

    Jason Selburg (4/25/2011)

    It is a question of semantics. You are guaranteed to have ANY of those values and NONE of them at the same time. There is no guarantee, and...

    April 25, 2011 at 11:37 am

    #1315523

  • RE: NEED HELP= Monthly SQL database growth calculation script

    GilaMonster (4/25/2011)

    Ninja's_RGR'us (4/25/2011)

    You're the 3rd one here pointing that out to him in the last few days. Maybe he'll get it THIS time.

    You, me, Jeff, Lowell, Tara (from SQLTeam)...

    April 25, 2011 at 10:47 am

    #1315511

  • RE: NEED HELP= Monthly SQL database growth calculation script

    Jeff Moden (4/24/2011)

    Syed Jahanzaib Bin hassan (4/24/2011)

    Check this script if you have any problem or modification required then tell me

    Did you read this statement in the end of my post

    Regards,

    Syed...

    April 25, 2011 at 10:36 am

    #1315506

  • RE: NEED HELP= Monthly SQL database growth calculation script

    hydbadrose (4/25/2011)

    Thank you so much for your help- I will try and let you know. Thanks!

    Here's how I tackle the problem. Read the backup history and using the logged...

    April 25, 2011 at 10:30 am

    #1315503

  • RE: OUTPUT & NEWID()

    wware (4/25/2011)

    Interesting question. I had no problem with the semantics of the question or answer.

    Wondering if anyone can think of a real world example where one might...

    April 25, 2011 at 7:31 am

    #1315421

  • RE: OUTPUT & NEWID()

    roger.plowman (4/25/2011)

    Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?

    Unless I'm crazy you can't insert...

    April 25, 2011 at 7:15 am

    #1315411

  • RE: Landing My First Job

    David Burrows (4/25/2011)

    Oh! And BTW I have seen some DBAs I would not like as my last line of defence :w00t:

    I've seen 300+ employees companies with a network admin I...

    April 25, 2011 at 6:27 am

    #1315392

  • RE: cluster Index and non cluster index

    Or even simple option :

    sp_helpindex 'TblName'

    sp_help also has nice info.

    April 25, 2011 at 6:25 am

    #1315390

  • RE: Landing My First Job

    David Burrows (4/25/2011)

    GilaMonster (4/22/2011)

    With no IT experience, it's not likely you'll be able to land a DBA job. Developer, maybe.

    Wow Gail! Not sure whether, as a developer, I should feel...

    April 25, 2011 at 5:52 am

    #1315382

  • RE: OUTPUT & NEWID()

    Echoing here... since you're talking about garanteed # of rows, none is the only possible answer.

    April 25, 2011 at 5:50 am

    #1315381

  • RE: SQL Server Agent jobs not running as scheduled

    Syed Jahanzaib Bin hassan (4/23/2011)

    Hey Ninja Turtle,you are again talking about non sense and stupid but why Ninja Turtle why

    I'll be listening on this thread... I've had that problem once...

    April 23, 2011 at 9:28 am

    #1315137

  • RE: SQL servers are no longer visible on our network

    Syed Jahanzaib Bin hassan (4/22/2011)

    whats the problem with you guys,I dont know why guy interrupting me,do your own work

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE...

    April 22, 2011 at 4:35 am

    #1314831

  • RE: SQL servers are no longer visible on our network

    Syed Jahanzaib Bin hassan (4/21/2011)

    If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe....

    April 21, 2011 at 7:48 pm

    #1314773

Viewing 15 posts - 6,691 through 6,705 (of 18,923 total)