Explain insert into select statement?
Can we hide the definition of a stored procedure from a use?
How can I create a table from another table without copying any values from the old table?
What is index fragmentation in ms sql server?
How to drop existing indexes in ms sql server?
Define clusters?
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
explain query execution plan
How to get a list all databases on the sql server?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?
What are “unrepeatable reads”?