Answer Posted / guest
Linked Servers is a concept in SQL Server by which we can
add other SQL Server to a Group and query both the SQL
Server dbs using T-SQL Statements.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How many types of attribute relationships are there? : sql server analysis services, ssas
Define normalisation?
Why are sql functions used?
What is key set driven?
How do I open port 1433?
What is the tcp/ip port on which sql server runs?
Is there any difference between primary key and unique with the not null condition?
What is openrowset sql server?
What is field in algebra?
List few advantages of stored procedure.
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the stuff?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is normalization? Explain different forms of normalization?
What is scd (slowly changing dimension)? : sql server analysis services, ssas