What is transact-sql ddl trigger?
Do you know what guidelines should be followed to help minimize deadlocks?
what is memory-optimized nonclustered indexes
What is the command to change the recovery model?
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?
What is molap and its advantage? : sql server analysis services, ssas
What are information schema views?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
can any body tell me how to know the password of current user in sql server
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Differentiate between delete and truncate.
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?
what is maximum size of temp db?