Maybe after a reboot there aren't any users in your system, where without kicking them off they're creating disk i/o contention as well as lock contention during your index creations?

Either...

If you mean a multidimensional SSAS cube as a source then I'd agree - can't see where there would be any benefits vs. there warehouse.

But there are many benefits to...

I'm not sure I'm fully understanding what you're attempting, but are there any datetime columns in your data you can use to extract out three months?

Two options I found on other forums:

1. Finally, I just deleted all the files in C:\Program Files\Common Files\Microsoft Shared\VS7Debug (stop the Machine Debug Service first), copied fresh ones...

Thanks Matt. I like it.

I think I had been more focused on removing A from the row labels/column labels list in a pivot table, which this solution won't do,...

That's correct. Pivot was introduced in SQL 2005.

You can use CASE to pivot in SQL 2000 (or all other versions for that matter). Here's an example:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/951ad7d4-d21e-4a13-9a5b-5d156fe3d90d/aggregated-case-expressions-versus-the-pivot-operator-is-one-better-than-the-other

Strange. Are you connected as sa or a member of the sysadmins group? I believe that's a requirement to view the SQL Logs...

select * from master..sysprocesses where spid > 50 and status = 'runnable'

By Log File Viewer to you mean the "Management - SQL Server Logs" folder in SQL Server Management Studio?

You could query the MSDB to search for jobs with the DatabaseName you're interested in. At least that would give you the list of jobs you then would need...

The only thing that causes a transaction log to grow are transactions within the database. Something was occurring during that time period. I'd check with everyone/everything that has...

SQL will take as much memory as it needs, up to certain limits which can be controlled by boot.ini switches, AWE settings, and Memory settings in SQL Server properties.

In most...

Like the last poster stated, change your connection types to Windows and SQL on the Security tab in Server Properties through Enterprise Manager.

OT: It would be useful for the original...

At my current workplace I run the following proc once a minute through SQL Agent.  Not exact science but works pretty well...

CREATE  procedure RecordDbUtilization as

insert into DBUtilization (db) select distinct...

I like your script grasshopper - you have learned well at the masters feet!

There is a product that uses an enhanced version of...