if no size is defined while creating the database, what size will the database have? : Sql server administration
what stored procedure can you use to display the current processes? : Sql server administration
what information is maintained within the msdb database? : Sql server administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
can a table be moved to different filegroup? : Sql server administration
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the difference between a fill factor of 100 and 0?
A trigger can reference objects outside the current database? State true or false.
How can you list all the table constraints in a database?
explain extended properties
What are the results of running this script?
You 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?
How can you stop stored procedures from recompiling?