Forum Replies Created

Viewing 15 posts - 286 through 300 (of 2,436 total)

  • RE: Take Care of Yourself

    Harry Callahan: A man's got to know his limitations ... 😉

    Take care of yourself and get well Steve !

  • RE: Staying Technical

    Yes you can remain a 'techie' ... I'm 51 and been a DBA for 26+ years and still a 'techie' ...

    Although I did do the manager thing for a...

  • RE: Testing Skills

    Good point Gary, maybe I should have clarified, one or two people could be present to provide 'background noise' (i.e idle chat at times) and also provide the service of...

  • RE: How to migrate the roles form Sql server 2000 to 2005

    Here is a rather quick'n'dirty script that we use.

  • RE: Testing Skills

    It is an interesting premise. However for a first interview in an alien environment it may not be fair - but you will probably find the best candidates that can...

  • RE: Polymorphed Proc

    Skynet begins to learn at a geometric rate. It becomes self-aware at 2:14 a.m. Eastern time, August 29th. In a panic, they try to pull the plug. ...

    Glad it was...

  • RE: Polymorphed Proc

    self healing or mutation ??? hmmm ... sounds like malware or a virus to me ...

  • RE: SQL Server versions in use in the production environment

    We have 250+ instances

    a handful are v7.0

    about half are SQL 2000

    about half are SQL 2005

    we have no plans for SQL 2008 and are waiting until SQL 2010

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    No degree - I was driven by the potential income when entering college in 1981 under General Studies - I took all of the computer courses required for a BA...

  • RE: Creating Striped Backup Set

    Add the WITH REPLACE clause.

  • RE: Creating Striped Backup Set

    For some reason 4 threads is kind of magical, whether there were 2, 4 or 8 CPUs. It did not matter if the CPUs were physical, hyperthreaded or physical (single...

  • RE: Creating Striped Backup Set

    Striping will only help if your I/O subsystem can handle it.

    I have done extensive testing over the years and have found that 4 threads usually gives me the best performance....

  • RE: No progress from DBCC INDEXDEFRAG

    Awe come on now Warren - it is just a 'slightly undocumented' feature is all ...

    Actually I have seen it work most of the time in batch scripts, however when...

  • RE: Swings in Page Life Expectancy

    Could you also post an example of the swings in 'page life expectancy' ?

    lows and highs from a few random samples would be good.

    how is your buffer cache hit ratio...

  • RE: Swings in Page Life Expectancy

    Could you post your boot.ini file ?

    Also, the resutls of the folllowing:

    exec sp_configure 'awe enabled'

    exec sp_configure 'min server memory (MB)'

    ...

Viewing 15 posts - 286 through 300 (of 2,436 total)