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?
1136After removing a table from database, what other related objects have to be dropped explicitly?
1049
What are secondary xml indexes?
Can we perform backup restore operation on tempdb? : sql server database administration
What is 1nf normalization form?
What is nolock?
Why do we need normalization?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is temporal data type?
What are the differences between ms sql server & oracle?
What is database dimension? : sql server analysis services, ssas
What are the new data types are introduced in sql 2000?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Name 3 ways to get an accurate count of the number of records in a table?
What is PROJECTION Operation?
What are the acid properties?
Explain concepts of analysis services?