What are the triggers in sql?
what is the difference between delete table and truncate table commands? : Sql server database administration
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 execute stored procedure and set temp table in sql server?
What are the differences between substr and charindex in sql server.
How can you ensure that the database and sql server based application perform well?
Can you explain about buffer cash and log cache in sql server?
What is a natural primary key?
what's the difference between delete table and truncate table commands? : Sql server database administration
How to use user defined functions in expressions?
Do you know what are acid properties?
When would you prefer to have a minimum number of indexes?
Explain the difference between primary keys and foreign keys?