Viewing 15 posts - 1 through 15 (of 66 total)
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:
December 28, 2009 at 3:27 pm
I believe that McAffee might monitor file changes as they occur. Try disabling it and then see if the problem continues.
Carlos
December 28, 2009 at 3:16 pm
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...
Carlos
December 28, 2009 at 1:14 pm
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...
Carlos
December 28, 2009 at 1:07 pm
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.
Carlos
December 21, 2009 at 2:13 pm
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....
Carlos
December 21, 2009 at 1:32 pm
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...
Carlos
December 21, 2009 at 1:17 pm
Any reason why you're not using alter table alter column?
as in alter table mytable alter column my column bigint?
Carlos.
Carlos
December 21, 2009 at 1:09 pm
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...
Carlos
December 21, 2009 at 1:05 pm
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...
Carlos
December 21, 2009 at 10:06 am
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...
Carlos
January 21, 2009 at 6:30 pm
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...
Carlos
August 8, 2007 at 3:18 pm
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...
Carlos
June 18, 2007 at 11:46 am
Works for me in SQLEXPRESS and SQL Server 2005.
And this should work in either environment:
select * from sysobjects
Carlos
June 15, 2007 at 3:16 pm
If you just want to duplicate the table structure and not the data:
select * into <newtable> from <sourcetable> where 1 = 0
Carlos
June 15, 2007 at 3:10 pm
Viewing 15 posts - 1 through 15 (of 66 total)