What is the diff between Dynamic queries and static queries1 9332
wht's the differece between sqlserver05 and sqlserver20003 4026
what is meant by deafult in sql server?2 3938
any one can explain Self mapping Delegation Remote Credentials1 4159
What is the difference between views and stored procedures? Can we have input parameters for views?6 16236
Which databases are part of SQL server default installation? Explain the usage of each?2 5633
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?3 9475
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7971
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?1275
Explain candidate key, alternate key, and composite key?
List all the types of user-defined functions?
What xml support does the sql server extend?
What is difference between inner join and full join?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is a join in sql?
How do I start sql server agent automatically?
What is format parameter in ssrs?
How to create a user name in a database?
Write a SQL command to insert and update only a particular field?
What is a database table?
When is update_statistics command used?
What is acid properties?
How you trouble shoot when any job fails
how to create “alternate row colour”?