Forum Replies Created

Viewing 15 posts - 16 through 30 (of 131 total)

  • RE: deployment documentation

    Yes, we do have a home grown case management system.

    The problem is that it is a text field......and the developers can type anything and always leave out things...

  • RE: Old SPIDS not releasing

    I agree with you....I assumed it was somthing to do with connection pooling at the application level, but that doesnt explain the QA sessions that are showing up from a...

  • RE: New Company, new DBA Tools budget, can you recommend any?

    which APex tools do you use and really like?

  • RE: New Company, new DBA Tools budget, can you recommend any?

    The client is currently using Ideara's backup with compression. I think the redgate SQL Toolbelt comes with their SQL Backup tool.....which works as fast and compresses the backsups...

  • RE: Job info showing in EM, not through query.

    --try this, maybe more than you asked for, but works in my environment

    SELECT

    @@serverName as 'Server Name',

    left(J.Name, 50) AS'Job Name',

    'Last Run Stat'= isnull(Casewhen Q2.run_status = 1 then 'Succeeded'

    when...

  • RE: large number of databases

    Yes

    Ok, the hardware was big with lots of CPUs and a SAN on the back end.

    Note that many ( in groups of 72 ) of the databases were...

  • RE: Career Advice...what is next after SR SQL DBA ?

    Several places that I have worked have a position of

    Database Architect

    The Architect position usually does a bit more data modeling, plans the SAN configurations and consults with the Senior...

  • RE: CPUs on a Machine

    Thanks again all

    I found the procedure, but in SQL 2000 you have to be in the master database or reference the master database for it to work...exec master.dbo.xp_msver 'ProcessorCount'

    Thanks

    Eric Peterson

  • RE: CPUs on a Machine

    exec xp_msver 'ProcessorCount' works great for showing the number of CPU cores. It is what I was looking for.

    Some of my SQL Servers are SQL 2000...

  • RE: Reading a tran log backup

    I actually had redgate Log Repair in house, and that gave me some good information.

    Note it was a table drop.....a non logged bit of code, so it could only...

  • RE: Reading a tran log backup

    I actually had redgate Log Repair in house, and that gave me some good information.

    Note it was a table drop.....a non logged bit of code, so it could only...

  • RE: Reading a tran log backup

    I actually had redgate Log Repair in house, and that gave me some good information.

    Note it was a table drop.....a non logged bit of code, so it could only...

  • RE: How do I interpret sp_who2 results?

    along the same line....try using this script to tell your most expensive users for the past minute. It will review the processes and tell you who is using the...

  • RE: How do I interpret sp_who2 results?

    along the same line....try using this script to tell your most expensive users for the past minute. It will review the processes and tell you who is using the...

  • RE: How do I interpret sp_who2 results?

    along the same line....try using this script to tell your most expensive users for the past minute. It will review the processes and tell you who is using the...

Viewing 15 posts - 16 through 30 (of 131 total)