Opus (2/24/2012)

---

That's what I was thinking should work but it didn't. I just come to find out some of the teacher names were entered with spaces. That's why...

SSMA is fantastic to migrate data but is not that good when the time...

well... whoever wrote the query wanted to process rows when query below returns no rows e.g. NOT EXIST (in returned row set)

(

SELECT

'z'

FROM

...

I'm sorry for getting a little late on this one but I wanted to point out that there are Microsoft provided guidelines for TempDB.

A good starting point would be http://msdn.microsoft.com/en-us/library/ms175527.aspx...

Not correct.

DBLinks connect one Oracle instance to another Oracle instance - DBLinks have...

Yes. This is part of a family of PREEMPTIVE_OS_* wait events describing a SQL Server task waiting...

Spam

Did you check Microsoft's document on troubleshooting Intellisense?... http://msdn.microsoft.com/en-us/library/ms173434.aspx

Database shows in suspect state, isn't it?

Check... http://www.sqlservercentral.com/Forums/Topic453275-266-1.aspx

SAS.DHRUV (2/23/2012)

---

My queries runs much faster on MS Access using ODBC connection to Db2 compare to SQL Server OLE DB connection to Db2 . Is there any solution to run...

Does the "report" needs the data coming from the 200 tables at...

Oracle client does not includes the OLE DB driver - driver has to be installed at O/S level.

http://support.microsoft.com/kb/280106

deepak.a (2/23/2012)

---

we have built the date warehouse with snowflake schema and also it is difficult to process the incrematal load . so any suggestions on this could be more use...

Are you planning to use Kerberos authentication?

If not... dismiss.

Well... no but, how do you think optimizer learns about relationship between tables?...