Sometimes the Oracle lient connections can very sensitive to service pack changes.  Have you updated your service pack of SQL Server lately?  And if yes, does it coincide with the...

One thing to keep in mind when you start thinking about partitioning is the type of queries that are consistently hitting the table.  Do most queries stay within a specific time...

select * from clients left join risk on clients.id=risk.id

where risk.id is null

Would your logic work with a "case" statement?

Update table

set "New Col'"=case when "logic" then 'value' else "Old Col" end

from "source tables" where ....

I would look to update the table for...

Try this:

Select * From "Table" Order by NEWID()

Original article:

http://www.sqlservercentral.com/columnists/hji/usingxp_cmdshell.asp

Provided you have permissions to delete:

This script came off this site, not sure who the original author was...

declare @foldername varchar(150)

decalre @DOSCommand varchar(150)

set @foldername='\\SERVERNAME\FTP\Folderpath\'

--check whether the user supplied a '\' in...

I would create a database on the server (w/a different name from the original) and then do a restore from a backup of the source database.

BOL has the script buthere...

At first glance I would check the ODBC connection on the server for that specific data source referenced and make sure the account associated with the sql server service has...

This allows you to set how many of your available processors for parallel query execution.  By default, its use "all".

Query Analyzer.

Choose Query-->Results to file-->Name and save.  The query will run and save it as a file.

..hope that helps

Check this article out previously posted:

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp

...hope that helps

You are correct, it will require Enterprise Edition.  Here is a link that shows features by editions:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8ynn.asp

...hope that helps.

I would cast the value to an int then to varchar for the string concat:

cast(cast([money] as int)as varchar(2))

..probably faster more efficient ways but this should give you the idea.

I looked through some stats I keep and came up with a number (based on 3 fact tables 20 columns/12 million rows and a couple dim tables) =5.75 GB.

Don't forget...