How network traffic be reduced by using the stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What is a unique key constraint?
How can I get data from a database on another server?
how to overcome kernel isssues
What are clustered and non-clustered index?
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
What are the different methods available under sqlcommand class to access the data?
What is clustered vs nonclustered index?
What is a partitioned view?
How can I create a report based on a query? : sql server management studio
What's the purpose of Stored Procedure?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.