You mentioned that you added [NameIDRef] [varchar](15) NULL to the table [PSAJCK](your biggest table, right??) and it is unique. Does it contain null values? if not it can be your...

But that shouldn't close this thread. I still need answers to my original question.

I still want to updagrade from trial version of VS2008 on live server and I should be...

I too executed your query several times on a development server. Depending on load, either of them worked faster but the tests never convinced me that one is faster than...

Sorry for confusion.

I got it working. Here is how it worked:

My live server had Both VS2008 and SSIS. VS2008 was trial version and expired also.

My domain ID didn't have...

Thanks for pointnig to Tally tables. That was something new for me to learn.

I'll do it by doing a character by character comparision in a loop. Also keeping in mind the space we have before and after each word.....

Hi

Can you pls guide to some link that shows this difference. Most of the places I know just say that the performance is similar. e.g this one:

http://www.informit.com/articles/article.aspx?p=31283&seqNum=4

SQLKnowItAll (3/27/2012)

---

S_Kumar_S (3/27/2012)

---

Using cast...

Using cast or convert won't make any differencr performance wise.

And unfortunately using any of them in join or where clause will panalize you for performance.

Why don't you change the...

But as Henroci mentioned, kill spid on live server is a bad idea. And putting databse in single user mode will be doing that in background. So what we should...

Hi

BIDS and SSIS are already installed. But when I try to open BIDS, I get the message that trail version of VS2008 is already expired. Thats why I was planning...

To check it with SSIS, I 'll need visual studio on my machine. It is already there but it's a trial version of VS2008 which has already expired 🙁

So I...

Henrico

What should be the approach for critical systems then? I believe Setting user to single_mode with immediate rollback will also kill processes and rollback all open transactions.

Stopping service should ...

So you mean to say if I want to modify the maintenance plan from any client, then SSIS should be installed on all clients or do you mean that it...

Where is the url??

So we should have a way to check that the version of SSMS was installed via Express or Standard/Enterprise. Since it was already installed on this machine, I really...