Adding more filegroups to the same physical drive will have an effect, but I'm not sure you can say it will always be a benefit or a penalty.  The I/O...

If you can't solve the problem with indexes, or the two-step process Robert proposed, you might consider using a loop that updates a limited number of rows in each cycle.  Very large updates put...

I'm assuming from the forum you posted the question in that you're using SQL 2005, in spite of your reference to Query Analyzer.

A SQL login cannot be a domain administrator. ...

It might work if you created an alias for the server with the nonstandard port in the Configuration Manager on the client, then used the alias name in the BCP command.

Even if the MSSQLSERVER service is a domain admin, it won't give network access to a SQL login.

A credential can be created that represents a Windows account, then if it...

If you're talking about Windows logins, the login is identified by the SID that it gets from the domain.  Even if the users have logins in both domains, the SIDs...

If the Generate Scripts task is not smart enough to drop tables in the correct order, this script will do it.  You could add an EXEC to fully automate dropping...

TRUNCATE would be fine if there are no foreign keys, and I doubt you'd be contemplating this action on a replicated database.  If you have foreign keys your choices are...

The application role is set for the connection that executes sp_setapprole, so the application must start executing and open a connection before it can activate the role.  Think about it. ...

The rules for the scope of alias definitions in SQL queries are not that complicated, even if you can rearrange the query to produce a variety of error messages.  All names used...

Any conversion you do from numeric to float or real will change your data values.  You could convert to varchar and do string manipulation to strip trailing zeroes, but T-SQL...

Maybe what you need is a derived table subquery in your main FROM clause to define the common expression "'a' + list.a", so you can use the field aa in...

Using DELETE is not a practical option, it logs the deletion of each row one at a time.  Your choices are either TRUNCATE or DROP/CREATE.

It is hard to say with...

You can't add login info to the script for Windows logins, you have to either get security to work (probably with help from the admins) or try another approach.

It sounds like there...

Approach 1: Create a separate database and create tables with the same structure as the views.  (Hint: "SELECT * INTO View FROM OtherDB..View WHERE 1=0" works great, and is easily...