An upgrade to Win 2K3 alone should boost your performance (more efficient OS and the hyperthreading). However I'd go to SQL 2K as well since things are much more 'stable'...

Not the user table. A few rows in a few system tables (to write the statistics for the optimizer) right at the end. It's really quick ... measure it in...

You don't have to do any diagnostic work on this. Just change to a 'best practice'. That practice is: When running UPDATE STATISTICS on a table the very next thing...

Here's another thread on this site as well:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=210724

You also might want to sesrch the sight ... there are lots of threads concerning this topic ...

Use the 'search' bar and enter 'transaction log' and select the 'search articles'...

I believe that it defaults to the domain group (which has a defauilt database specified) which is first in the collation sequence of domain\group.

Now for the issue of one database...

One point not mentioned in relation to UPDATE STATISTICS. When you execute this command on a table you then need to execute the following code:

exec sp_recompile table_name --> the table_name...

Here's a quick SQL script to execute for checking your permissions for creation, listing and deletion of files:

declare @cmd varchar(128)

select @cmd = 'echo test_string > \\your-server-name\i$\test_file.dat'

exec master..xp_cmdshell @cmd

--

-- output...

Yes ! But in pairs (Update STATISTICS table, sp_recompile table). UPDATE STATISTICS is primarily read only (99%) the update is at the end of the process for each table in...

It has to do with how the row of data is actually constructed and maintained on the data page. In essence, NULL columns are treated as varchar columns. Scan BOL for...

One might also ask the reason for putting a table on a separate filegroup. Performance based reasons may be acceptable for local disk configurations. So if you are using SAN...

first things first though ... until the other activites are completed you would also do well to execute UPDATE STATISTICS on all tables (or at least the heavily deleted from...

The major thing about 'updates' and their performance is whether or not they are performed 'in place', i.e. overlaying the data (just writing it out). If you're not performing an...

Be wary though ... if you dropped all the indexes and primary keys as was suggested. The time you saved up front inserting data may be spent recreating what you...

Aside from a little research (on MS and Google), you bank account and managements priorities you might want to ask(or answer) a few additional questions for yourself.

• Is this your company's first...