Forum Replies Created

Viewing 15 posts - 256 through 270 (of 459 total)

  • RE: DBCC IND - how can I run it when there is a locked row in the table I am looking at?

    cb (7/12/2009)

    Thanx for your suggestions!

    ...I have clients who "bolt-on" stuff to the database, usually via triggers. Sometimes however, they cause queues of locks. Also, sometimes users leave locks open e.g....

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 13, 2009 at 7:23 am

    #1023861

  • RE: No Google

    When the Cloud ("All hail the Cloud, it is merciful and just. It will envelope all of us in it's calm embrace.") comes, it will be too late! ...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 13, 2009 at 7:10 am

    #1023851

  • RE: DBCC IND - how can I run it when there is a locked row in the table I am looking at?

    Paul White (7/10/2009)

    ...As for a business case, who cares? What possible difference does it make?...

    :laugh:

    Paul

    Hi Paul, I heartily agree with your sentiment. Nothing wrong with using undocumented features,...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 10, 2009 at 9:05 am

    #1023118

  • RE: Using Run As to make your life simple

    smurphy (4/13/2009)

    This script seems interesting and a smart way to do repetitive tasks but I don't understand one thing, where does this batch file run from? Does it run...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 10, 2009 at 7:54 am

    #1023030

  • RE: getdate() in an update query vs. datetime variable

    Gaby Abed (7/9/2009)

    Dave Ballantyne (7/9/2009)

    getdate() will return a consistant value within a statement. it doesent matter how long it take for the statement to execute.

    edit : See here for...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 1:52 pm

    #1022646

  • RE: getdate() in an update query vs. datetime variable

    Dave Ballantyne (7/9/2009)

    getdate() will return a consistant value within a statement. it doesent matter how long it take for the statement to execute.

    edit : See here for more info...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 1:40 pm

    #1022641

  • RE: Are the posted questions getting worse?

    GSquared (7/9/2009)

    Gaby Abed (7/9/2009)

    For all you lovers of English, here is a sentence without punctuation:

    that that is is that that is not is not that that is not is not...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 11:35 am

    #1022571

  • RE: Are the posted questions getting worse?

    For all you lovers of English, here is a sentence without punctuation:

    that that is is that that is not is not that that is not is not that that is...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 8:46 am

    #1022430

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/9/2009)

    Does anyone know why "abbreviated" is such a long word?

    🙂

    For the same reason "long" is such a short word? 🙂

    English is a funny language. For example, if...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 8:35 am

    #1022415

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/9/2009)

    Paul White (7/8/2009)

    Jan Van der Eecken (7/8/2009)

    Donaudampfschifffahrtsgesellschaftskapitaenskajuetenschluesselloch

    The keyhole in the door of the Danube steamship company's captain's cabin. :w00t:

    10 out of 10 for this translation goes...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 9, 2009 at 7:50 am

    #1022371

  • RE: Limit users with Management Studio Accessing a DB

    Thanks everyone for the help, although I didn't initiate this thread. heh heh.

    This has given me food for thought.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 2:03 pm

    #1020635

  • RE: Limit users with Management Studio Accessing a DB

    Richard M (7/6/2009)

    Gaby Abed (7/6/2009)

    Tim, looks like a great idea. I was wondering if this trigger would impact a really busy server where lots of logins occur? For...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 12:54 pm

    #1020586

  • RE: Are the posted questions getting worse?

    GSquared (7/6/2009)

    Gaby Abed (7/6/2009)

    Steve Jones - Editor (7/6/2009)

    We're a long way from needing bigint, but if anything were to get that large, this would be it.

    Is this the longest thread...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 12:34 pm

    #1020567

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/6/2009)

    We're a long way from needing bigint, but if anything were to get that large, this would be it.

    Is this the longest thread you've seen anywhere...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 12:10 pm

    #1020543

  • RE: Limit users with Management Studio Accessing a DB

    2 Tim 3:16 (7/6/2009)

    I often have 3rd party apps that insist the App id have 'sa' or some other high level acccess. if the App connects, fine, but I...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 12:08 pm

    #1020542

Viewing 15 posts - 256 through 270 (of 459 total)