Interested to Buy Any Domain ? << Click Here >> for more details...
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
TCS,
3 10068how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?
16 26295what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
2027could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
3 6063
How to view existing indexes on an given table using sys.indexes?
What is logon trigger?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How to create a simple table to test triggers in ms sql server?
What is a trace frag?
How connect excel to sql server?
How does using a separate hard drive for several database objects improves performance right away?
What do you mean by an execution plan?
How to display a past time in days, hours and minutes?
How to write a query with a full outer join in ms sql server?
What is the difference between ddl and dml?
What is the sql profiler?
What is the difference between clustered index and primary key?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
