I'm glad you posted, because I've been researching this very issue and would like more information. Here's what I know, based on lots of research:

1) Yes, you don't have...

SQLBot, you're my new favorite person

🙂

Look for a Maintenance Plan that created a job that removes the .trc files:

Management -> Maintenance Plans

SQL Server Agent -> Jobs

If it is a stored procedure that is doing the...

Tough request, as there's lots of variables here.

Do you know if your SQL Servers are listening on the default port (1433)? Can you get a list of IPs to...

Thanks Jack. Interestingly, the data type for the 'body' field in my 'msdb' database is 'ntext' (based on sp_columns). And, I was able to partially see the data...

As a new SQL Server DBA, make sure to download and install SQL Server Books Online. I opened my version and searched for:

'create job'

'create maintenance plan'

You can use...

Just re-read and saw that it's an Oracle 9 install. Your ORACLE_HOME might be in

c:\orant

Search for the 'sqlplus' binary and tnsnames.ora file there. Obviously, replace the drive...

You can test connectivity by opening a Windows command line and typing 'sqlplus /nolog'. That will start Oracle's version of 'osql', giving you the ability to connect to your...

Thanks for the replies.

G, I'd like to know a little more about both of those sections.

I've seen excerpts of Kalen's book (it does look excellent), but does it relate to...

Clear, but a little open ended, so I'll throw a bunch of info at you. A couple of real basic tools I use are:

Perfmon (installs with Windows)

ProcessExplorer (in the...

Take SQL Server out of the picture and try and run the same query at the command line, using 'sqlplus'. Does it return data? Can you query other...

Thanks for your replies, G. Dunno if this is what you're asking:

avg_frag_in_percent - 53.84615385

fragment_count - 8

avg_frag_size_in_pages - 1.625

page_count - 13

avg_page_space_used_in_percent - 88.87305411

record_count - 1559

I couldn't find a size in...

Back to this...any ideas why the fragmentation remained at +50% when I did a rebuild on the index?

Yeah, I'm a jughead, just realized my FILLFACTOR is 90 and the space used is only 88%.

Yeah, I think so. But it was done with a REBUILD...again, I'm fuzzy on the fragmentation understanding:

Day 1:

-- Processing STANDARD table dbo.FOCUSRequests, STANDARD index [Name], -- partition 1,...