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...

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...

which APex tools do you use and really like?

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...

--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(Case when Q2.run_status = 1 then 'Succeeded'

when...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...