what are three different authentications to connect linked
Answer / vidhya sagar
|Is This Answer Correct ?||5 Yes||0 No|
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
when we use function instead of procedure? plz tell me the situation with ex?
How do you know which index a table is using?
How do we rollback the table data in SQL Server
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Wht is Stuff in sql ser
what is sql injection in sql server?
What are the two virtual tables SQL Server maintains for triggers?
Define candidate key, alternate key, composite key.
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
Why we are using the sql language?. What is the purpose of using this?