For more information about possible performance problems and McAffee virus scanner, take a look at the Criticism section of this article on Wikipedia: http://en.wikipedia.org/wiki/McAfee_VirusScan or this review:

I believe that McAffee might monitor file changes as they occur. Try disabling it and then see if the problem continues.

Yet another way to do it is to take a backup of the database then do a restore using the "move" datafile option. You could restore the database to...

After looking up the information in the Internet 🙂 seems like the problem is due to some lack of performance in your disk system. One thing that you should...

No, I don't really like the idea of sharing my failover node with anything else but I'd do it without concern if I had to.

Assuming that your Std edition instance has it's own database (which gets data from the clustered instance via replication) (have I got that right?), it should work without any problems....

Don't know for sure if this would work but I think it will:

select into tempdb.dbo.mytable * from table where condition (if there are many rows that will be affected create...

Any reason why you're not using alter table alter column?

as in alter table mytable alter column my column bigint?

Carlos.

If you're going to use INSERT INTO, you'll need to name all the columns. One easy way to get the list of columns (if the table has many) is "select...

Hi Adel,

I don't think it can be done. The sa user will always have access to all databases. I've a similar situation and my solution was to create a...

This is not a complete and direct answer to your question but you could start by making sure that the user who owns the SQL Server service has full access...

Will:

I don't have solutions but I think I might have explanations.

1. Even though a query is using an index instead of doing table scans is not a guarantee that the...

use the ISQL tool.

Here's the format of the call to ISQL.

isql -U<user> -P<password> -S<server> -w<some large number> -x<another large number> -d<database name> -Q"select * from <sometable> where <condition>" -o<name of...

Works for me in SQLEXPRESS and SQL Server 2005.

And this should work in either environment:

select * from sysobjects

If you just want to duplicate the table structure and not the data:

select * into <newtable> from <sourcetable> where 1 = 0