Thank you,

Can any one tell the reason behind this...

We have an Edition in sql server 2008 R2 (Parallel Data Warehouse)

for your reference please check below link:

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

And if i want to install this edition how can i...

Hi,

Thanks for more explanation,

Here memory means the RAM size right? If i have more memory then this limitation will be exceeded (more than 5000 locks).

My question was,

Why there is...

Thanks for you quick reply,

Suppose when i execute a query (and actual data was entered in English and it was stored as binary data) it will give the result in...

Thank you,

How sql server converts the stored binary information to actual data? Which component of the sql server do this task?

Thanks,

Thank you so much,

Is there any benefits having the Clustering on VM?

will it degrade the performance (my thought was as we are sharing the hardware between two OS's...

HI,

What is the use of two data sets?

Can't we implement two data set functionality in a stored procedure?

Try to create a stored procedure and use it.

Thank you,

I am aware of the statements what you have posted,

but my doubt is how sql server knows the next identity?

Ex: i have a table with identity, i have inserted...

Thanks,

But my statements are by considering the performance of queries.

Could you please explain the difference by considering the performance?

Thanks,

Hi,

What is VM and Cloud? how these two are different?

Can you give me some graphical representation or any helpful links

Thanks

hi thanks for your reply,

i dont understand how it can be done? please post any links that help me to do this task( any links)

thanks

its good, but i dont want query again,

becasue it(selected values are) was already in the drop down, my concern is using this dropdown and populate the table.

Thanks

thanks geoff a,

now i have a clear picture,

hi i got the solution, there is a problem in the cmd query

i put the try..catch then i find the error.

hi,

i'm having the same problem could u tell me how can i fix this problem?

what i did is:

At first initially it was deployed successfully, and i'm able to execute from...