Forum Replies Created

Viewing 15 posts - 181 through 195 (of 631 total)

  • RE: Reorg index, rebuild index and reorg table

    ypeng5 (1/7/2016)

    so do I need to do table reorg? when do I need to table reorg?

    Firstly, I would very much agree with the recommendation from Sean on working through the...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    January 7, 2016 at 10:13 am

    #1850263

  • RE: Reorg index, rebuild index and reorg table

    Hi there. Personally, rather than look to set up my own solution here, I would (in fact do) use one of those already written by either Michelle Ufford which...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    January 7, 2016 at 7:31 am

    #1850181

  • RE: Running as SysAdmin

    Indianrock (12/23/2015)

    ...

    I'll have to test if a disabled SA account can actually own and run sql agent jobs. If so I don't see why SA couldn't be disabled. ...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    December 24, 2015 at 4:41 am

    #1847896

  • RE: Running as SysAdmin

    Ivanova (12/21/2015)

    Slightly off-topic; while working for a large financial institution, I was approached by one of the security team. He was a highly-paid and allegedly very security-savvy contractor. His request...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    December 24, 2015 at 4:03 am

    #1847893

  • RE: Running as SysAdmin

    Cody K (12/21/2015)

    andrew gothard (12/21/2015)In fact, using a highly privileged single account for app access is nothing more than deliberate incompetence.

    The last time I heard something like this said the...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    December 22, 2015 at 10:09 am

    #1847506

  • RE: Running as SysAdmin

    Cody K (5/4/2011)

    Horatiu Ripa (5/4/2011)On the other hand, I saw pretty stupid things, from passing connection strings to invisible textboxes in webapps - more or less protected by some cryptography...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    December 21, 2015 at 5:51 am

    #1847079

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/14/2015)

    To explain some of my extreme frustration in the "developers" that I've been interviewing over the last decade, the following blog post is a great example of the...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    November 16, 2015 at 7:59 am

    #1839962

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/12/2015)

    jasona.work (11/12/2015)

    BrainDonor (11/12/2015)

    My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907

    I just glanced...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    November 13, 2015 at 7:32 am

    #1839607

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    robinwilson (9/28/2015)[/b

    Virtualisation

    The server is virtualised on a VMWare host and I do wonder if something is wrong there (and I have exhausted other avenues I think). I did discuss moving...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    October 27, 2015 at 11:47 am

    #1835867

  • RE: Database Drive Expansion

    notr 100% sure what you're asking here - are you talking about moving the database to new storage with a bigger LUN? Are your VM admins not able to...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    October 8, 2015 at 5:38 am

    #1832260

  • RE: Recommended Transaction log backup script?

    The scripts here are very good

    https://ola.hallengren.com/

    however, if you don't mind me saying, you may also find thsi helpful http://www.sqlservercentral.com/stairway/73776/

    EDIT

    Also - there's a very good free eBook on backup and restore...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    October 6, 2015 at 5:13 am

    #1831655

  • RE: Need Backup Script to take all the databases

    THe scripts for backup - and also general maintenance here https://ola.hallengren.com are very well regarded indeed.

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 25, 2015 at 7:47 am

    #1829450

  • RE: Generate Invoice Document from SQL

    andyc209 (9/25/2015)

    thanks for the reply- can SQL reporting services take an existing template like i have or does it generate the whole document on the fly?

    You can't load a word...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 25, 2015 at 3:41 am

    #1829384

  • RE: Generate Invoice Document from SQL

    Reporting Services? That can generate PDF / Word etc

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 25, 2015 at 3:16 am

    #1829381

  • RE: Whatever happened to Database Table Refactoring?

    Yet Another DBA (9/21/2015)

    call.copse (9/21/2015)

    re: MySQL I'm going to say the licence cost issue is a big one these days, and seems to be more onerous than it has been....

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 24, 2015 at 7:16 am

    #1829131

Viewing 15 posts - 181 through 195 (of 631 total)