bijarcity (1/2/2012)

---

you know i didn't exactly understand?

imagine you want to create a search engine like google.

we have a lot of queries and these queries can't execute in one servers ,so...

OK I'm thinking a *little* straighter on how to do it, but i'm not that close.

i can use a Tally table method to get the comments from the definition of...

there is a variant of SQL 2008 R2 called "parallel Data Warehouse", you can read a bit more about it here:

http://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/pdw.aspx

and it uses Massively Parallel processing, which is in theory...

DBA Rafi (12/31/2011)

---

I knew that when we create a Clustered index on a VIEW. it would be stored in the database as table is.

My Query is:

what happened when changes are...

I see the same thing Gail does...that's looking like an ORACLE trigger;

SQL triggers handle all the rows at the same time,and not for each row via the specially materialized INSERTD...

Compact Edition...

i think this minor modification will do what you are asking; instead of returning a datatime, i changed it to returnt eh varchar(10);

inside it it's using convert twice, once to...

its not R2 that is the problem, its connecting to the instance.

since you can connect via name, we know you already allowed remote connections.

to get to an instance, instead of...

ok, now i am confused; i thought the insert was SELECT 0, 'test'

from Customer....but it's just SELECT 0, 'test'

for that, i'd expect an estimate of one row....

well, first the two queries are not the same; one is a straight insert of static values for every row in the table , or 500K.

the other is a...

you have this line

that is missing the join criteria..

ON sometable.column = DimIteration.column

shouldn't it look something like this?

CREATE FUNCTION udf_ConvertDB2toSQL(@CSC_DATE varchar(7))

RETURNS DateTime

AS

BEGIN

DECLARE @SQLDate Datetime

...

i should add that if the procedure uses dynamic SQL instead of direct DDL commands, then the ownership chaining is not used, and the specific permissions, like SELECT or DELETE...

there is an ownership chaining assumption in SQL Server:

if you create a procedure ie dbo.myProc, and you grant a user EXECUTE rights to that proc, no matter what that...

hmbtx (12/27/2011)

---

Lowell:

Thank you for the detailed instructions. I have three questions if you have the time to answer them but if your time is limited an answer to question #1...