| Other SQL Server Interview Questions |
|| Asked @
|Explain Active/Active and Active/Passive cluster
|How do you load large data to the SQL server database?
|Can you explain the types of Joins that we can have with Sql
|How do you persist objects, permissions in tempdb
|About Indexed Views? with example?
|explain query execution plan
|system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
|If i have one transaction say mainTransaction, within this
mainTransaction i have another two transaction say t1 and t2.
Now while execution t1 completes successfully and commit
statement fires, but while executing t2 some error occurs
and rollback statement fires.
What happen to t1, is it rollback or not?
|SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
|check, not null,unique
|How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
|What are the factors you will check for the performane
optimization for a database query?
|For more SQL Server Interview Questions Click Here |