the DESC (DESCRIBE) command is...

did you have a question? you can edit your post to provide the missing info so we can help.

That issue is caused by the Mail server not allowing...

and here's a code example of 7zip and xp_cmdShell:

--http://www.7-zip.org/download.html

--http://downloads.sourceforge.net/sevenzip/7za920.zip

--xp_cmdshell is limited to ONE set of double quotes.

--one of the paths needs to not contain spaces!

--see 2003 MS KB http://support.microsoft.com/kb/266224

DECLARE @results...

don't try to move the entire table in one pass;

change it to do a few rows at a time instead, and confirm it's working that way.

tweak the number of rows...

that's going to require an analysis of the specific queries themselves. If you post the actual execution plan of a query that is slow, we...

Nice Article Gianluca!

I added your CLR to my collection; very much appreciated.

it the other server a different SQL server version? When moving a database to another version, changes int he SQL engine make rebuilding the statistics manditory,as they are used differently,a...

doing a SELECT from a large table's going to take time, so yeah, that's a factor. the size of the data, whether there are varchar(max) or image type columns affects...

quoted and coded to make it more obvious.

so what is the issue? the whitespace is changing from the source? is this a fixed width file, or could you consider it...

Sean's refering to my procedure sp_UglySearch;

mine is a parameterized version as a procedure.

for me, i wanted a proc that returned some drill down queries so i could get/find the...

Also look at this other forum post by genehunter on scripting everything out via powershell:

this was one of my first powershells cripts when i was playing wiht powershell; with some...

In addition to Jared's sharp analysis, you are updating every row, even if the values are the same.

if there was an index on lnhist_acct_nbr,lnhist_appl_code,Other_Flag_50 my sample code below might...

to continue on what Steve is saying, a hashed password is never unencrypted to it's original value.

what happens is a potential password is hashed,and the two hashes can then be...

scripting options is what you skimmed over; there are lots of stuff you can turn on and off: