how do you determine the Load performance of any query in
sql server {example how do u determine performance of a
select stmnt which returns Dynamically many no of records
... some times 100,1000,10000 etc., }
How many ways to create table-valued functions?
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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : 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 select some specific columns from a table in a query in ms sql server?
What is an execution plan?
Which is best Subquery (or) joins in sql server? explain why
what is diffrent between store procedure and trigger
Define DML and DCL statements?
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
When multiple after triggers are attached to sql table, how to control the order of execution?
What do you mean by sql server agent?
What is nolock?