how you can move data or databases between servers and databases in sql server? : Sql server administration
1026why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
1131you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
1297You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
1047You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
1034
What is snapshot parameter in ssrs?
What is amo? : sql server analysis services, ssas
What are page splits? : SQL Server Architecture
What are the tables in sql?
What are “lost updates”?
How to connect Azure federated root database and apply federation in entity framework?
What is the most common trace flags used with sql server?
What is scalar user-defined function?
How can I check that whether automatic statistic update is enabled or not?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to stop log file growing too big?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is federation member?
What are trace flags and mention a few common trace flags used with sql server?
what is denormalization and when would you go for it? : Sql server database administration