up

Anyone knows? I just need to import Notes database, I don't care whatever method I have to use, would be better if I can schedule it.

I have no problem importing...

Thank you.

Thank you my friend

Big thanks to everyone, your kind helps make my life lots easier.

I am going to send the result as email attachment in certain period, is it possible to make the...

Thank you George,

select * From sys.dm_exec_connections WHERE Session_id = @@SPID will give me the IP address info, and the following code gives me more detailed info...

Sorry guys, I was hoping to see some case when query and didn't even try it, my apologies for this, it does work.

Thank you lots.

thanks. it won't work.

The records are all associated with a UserID, all non 0 value.

When the input parameter is 0, all records should be pulled out.

When the input parameter is...

Dave Ballantyne (2/27/2010)

---

Have you established weather your stats are up to date or not ? Without good stats , sqlserver will not be able to make good choices.

In terms...

Alex 469216 (2/25/2010)

---

Dave's query also can give you incorrect results because of the LEFT joins: you can get records where w.workphonenumber AS phone, w.emailaddress AS email,w2.workphonenumber AS phone, w2.emailaddress AS...

Does this perform better ?

SELECT TOP 20 a.employeeid AS [ID], a.account, a.displayname AS [Name], w.workphonenumber AS phone, w.emailaddress AS email,w2.workphonenumber AS phone, w2.emailaddress AS email

FROM activedirectory a

left JOIN WhitePage...

Does this perform better ?

SELECT TOP 20 a.employeeid AS [ID], a.account, a.displayname AS [Name], w.workphonenumber AS phone, w.emailaddress AS email,w2.workphonenumber AS phone, w2.emailaddress AS email

FROM activedirectory a

left JOIN WhitePage...

Does this perform better ?

SELECT TOP 20 a.employeeid AS [ID], a.account, a.displayname AS [Name], w.workphonenumber AS phone, w.emailaddress AS email,w2.workphonenumber AS phone, w2.emailaddress AS email

FROM activedirectory a

left JOIN WhitePage...

I don't know, querying either of the two is acceptable but not after inner join them

Are your stats upto...

Thanks.

are you providing the Actual query plan, (rather than Estimated query plan)...