OK, I just tried Case and made it work. Thanks.

So what good is the If statement and where can it practically be used?

Thanks,

Chris

I had one of the DBAs helping research this try it with sp_ExecuteSQL. The time it ran went from 47 seconds, or more, to less than 2. This is similar performance...

I have heard form 2 sources now that this is typical for SQL Server, because it doesn't have the information that exists in the variable and cannot use statistics to...

If you have allocated 2G of RAM for SQL Server to use, and are using dynamic it will use it as soon as it needs it. Most of this is...

There isn't much wiggle room for me to test this out right now. The query that uses this view is running terribly, even after starting this index drop and recreate....

Mike,

I don't think so. I scripted out the index from the table to use it in the job for recreation. I changed nothing. Here it is:

CREATE  UNIQUE  CLUSTERED  INDEX [PS_LA_OPR_DEPT]...

DanaH,

I don't know if that is a function that can be fixed by the site. The only reason I say this is because I get a different behavior myself, in...

Mongo,

I will be waiting to hear on this. I am running a Win 2003 EE, SQL 2000EE box now, with those switches.

/fastdetect /3gb /PAE

We have not had any problems...

suaaddaa

The resolution method of IE is usually the same as the settings FTP and a command prompt would use, unless you have a...

Can you even ping the FTP site's name from the SQL Server? Sound like a name resolution problem, or an IP filtering problem to me. When you did your successfull...

SQLBill,

That's the curious thing, the previous post appears in the new window, above the reply text box. I see your post above as I edit this response. On other message...

I don't know of an PS that will do what you want. You are probably going to have to do it manually.

Something else you might consider though, is just moving...

Sinlam,

As far as the shrink of the data files goes, in my experience it does take a while. I had a 27G data file where only 17G was allocated on...

EdVassie,

Thanks for the response.

Chris

Tom,

I was not actually talking about your requirements. I understand that in some cases business or technical requirements overrule best(?) practices.

I was asking EdVassie about why he would rather have the...