Do you know the different ddl commands in sql?
what is the cursor life span?
What is precedence constraint?
What are the dis_advantages of stored procedures, triggers, indexes?
How do I view views in sql server?
What are constraints in microsoft sql server?
What is a deadlock and what is a live lock?
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do we return a record set from a Stored Procedure in SQl server 2000?
What is Files and Filegroups in SQL Server & it's implementation.
Does the unique constraint create an index?
How to create a new schema in a database?