Forum Replies Created

Viewing 15 posts - 166 through 180 (of 392 total)

  • RE: temp

    Tara,

    Here is a very good KB about shrinking tempdb.

    http://support.microsoft.com/kb/307487

    As you see Methods 1 and 3 require a restart.

    The issue with Method 2 is that if your system is quiet and...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Deadlock

    Here is a good link about deadlocks - http://msdn.microsoft.com/en-us/library/ms178104.aspx

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Alternative to nolock

    Grant

    The load on tempdb absolutely increases. You have to be sure that you have that configured correctly and that you can support more space in tempdb. Other than that, it...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: How to have a 'text' type column included in an index

    Second the nomination for Full Text Indexing. I have seen tremendous improvements when using it.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Index Management

    This is a great article, and well thought out. I have been in the process of writing something that I can use here - but not to this extent.

    I am...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Transactional Replication - Slow Running Query On Subscriber

    Have you checked your indexing on the replicated data as well as statistics and fragmentation?

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Length

    yet another one who thought GREAT, a really simple one! to find that we must read minds to know what the real question is.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Dating for DBAs

    Excellent question. Got it wrong - but learned a lot.:-)

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Transaction log growth

    Good luck

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Transaction log growth

    Carol,

    Have you tried to use Bulk Insert, setting a batch size?

    This will control the growth of the T-Log as well as potentially increase performance of your insert

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Certification...Yes or No?

    I agree totally with Howard, except that if I have a candidate who has proven experience and one with a certification and can't prove their experience I would take the...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Certification...Yes or No?

    Grant

    I am frankly just a but nervous of certifications when I see them on a resume

    Especially if I don't see real experience with it.

    I have had both work for me...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Tuning Locks

    There are numerous circumstances which can cause locking as well as lock escalation.

    I thank all of those who made their comments but have finally found the answer to my question,...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Tuning Locks

    The /3GB switch is not set. The locking is occuring during the weekly load which is performed using an openrowset from various other servers. Once we are through the load,...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • RE: Tuning Locks

    Kevin,

    please define "special purpose box

    This box is being running our datawarehouse currently. in the future it is being transformed into the central distribution for our replication.

    please state why you think...

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Viewing 15 posts - 166 through 180 (of 392 total)