Seattlemsp (1/25/2012)

---

during the passed days, I tried many times. However it still doesn't work for me.

The error message said: ORA-00900: invalid SQL statement

It looks like I may not declare the...

sqlblue (1/23/2012)

---

2) what if I have a big table of 500 mil rows, and have to do daily updates of 200-300 mil records, how can I do this efficiently? Right...

Either spam or really bad worded.

If you want to go this path you may want to consider to move out of AppliancesProperties the "catalog" columns meaning, create a separate table called ApplicancesPropertiesCatalog where you describe...

MikeBrey (1/18/2012)

---

I have a business requirement that I need to determine the difference between historic change of a SCD type 2 dimension attribute. At this time the dimension is tracking...

Elliott Whitlow (1/23/2012)

---

PaulB-TheOneAndOnly (1/23/2012)

---

Dev (12/21/2011)

---

PaulB-TheOneAndOnly (12/21/2011)

---

Elliott Whitlow (12/20/2011)

---

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they...

Here is an interesting discussion on the same matter http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/447354c8-56df-46b2-a198-abbbecb4b1ff

achanta.priyanka (1/18/2012)

---

I'am unable to give 'dbcreator' permission to my account in sql server 2008....

I'am unable to give to 'sa' account or any other account also...

It is giving an error that...

Too many questions in a single...

Dev (12/21/2011)

---

PaulB-TheOneAndOnly (12/21/2011)

---

Elliott Whitlow (12/20/2011)

---

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be materialized...

chrisvolny (1/19/2012)

---

I have a database design where I've split the tables into five different schemas. One of the managers/architects (not a data architect) is fairly insistently suggesting that the schemas...

Either table rpt_tblOracleCustomers doesn't exist or is sitting in a different schema or your account has no privileges on it - SQL Server can't see it.

Try fully qualifying the table,...

Shivrudra (1/19/2012)

---

Hi all...

I know to capture the deadlock we use trace flags like 1204 1222 and also by using profiler with Dead lock chain,graph.

But i didnt get ans of How...

"diLip" (1/19/2012)

---

how does sql engine decide what indexes to use when seeking indexes from table or tables that has clustered and multiple non-clustered indexes. I verified some different scenarios including...

Tom Van Harpen (1/19/2012)

---

Is it possible to do a bulk copy (minimally logged) with ability to specify batch size using a SQL Server TABLE as the source?

If so, can someone...