Forum Replies Created

Viewing 15 posts - 76 through 90 (of 264 total)

  • RE: How to recover a SQL Server login password.

    Very useful article, but I can't help but wonder if this was just an excuse to show off that you have a 7970 clocked at 1010MHz!

    I read some time ago...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Best way to get execution plans?

    Thanks 🙂

    I'll be working on this stuff a bit more over the next couple of weeks once I've got my currently development version in live.

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Best way to get execution plans?

    ah cool. Good to know I'm not abusing the udf 🙂

    Although I will admit to using them in 1 or 2 insert into select constructs but with no more than...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Best way to get execution plans?

    Thanks for the reference it'll be useful in the future.

    Although I don't think Scalar vs ITVF is really a big issue for me as I'm not querying the scalar functions...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Load Poll

    Right now at the quietest part of the day with probably half the company having taken the day off our busiest SQL Server database is fluctuating between 250 batch...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Best way to get execution plans?

    Lol thanks. Once I've found an execution plan that works nicely I'll do some research on convincing the sprocs to use the right one and will probably end up asking...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Technical Nuances of Technical Writing

    I often find articles written by people who speak English as a second language are done to a better standard of English that those who speak the language natively.

    I speak...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Technical Nuances of Technical Writing

    Lets make a list.

    Pacifically instead of specifically

    Irregardless instead of regardless/irrespective

    To instead of too

    Your instead of you're

    Lose instead of loose

    Dose instead of does

    Heigth instead of Height (people round here even pronounce...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Technical Nuances of Technical Writing

    Owe eye could tell a tail or too about my spelling.

    excellent article but I very much dislike Grammarly.

    it said I had 8 critical errors in 1 paragraph from a systems...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Do not require registration to just read articles

    I know this is an old one but maybe allowing users to log in with Facebook or LinkedIn would be a happy middle ground - most people have one of...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: Find all actual words from Dictionary Table using jumbled word

    Is it just my browser or is this article missing some code? eg all of it?

    :rolleyes:

    cheers

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Copy Cat Poll

    pjdiller (8/3/2012)


    Main Production DB is around 3 TB, current growth rate is roughly 1 TB / year.

    Wow... An I thought my 20GB reporting database had lots of records in it...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: hyperthreading on enterprise licenses??

    Brilliant thanks guys.

    Turns out our supplier quoted us for 2x hex core cpu per machine because she thought we could do with an upgrade.

    Clearly, we only ever use the best,...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: The Copy Cat Poll

    Lots of copies..This is all for 1 database...

    production application:

    Main server:

    primary copy of the database

    backup image from previous night

    DR/HA server:

    copy of the database

    UAT server:

    2x copy of the database

    reports systems:

    vm report...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

  • RE: MS SQL 2012 Disadvantages.

    disadvantages:

    2012 might be more expensive to implement depending on version/hardware

    not all 3rd party software vendors have confirmed official support for 2012 as a backend database (check into what software they...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

Viewing 15 posts - 76 through 90 (of 264 total)