How is sql used in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How many instances per computer are there in sql server 2000?
Which tcp/ip port does the sql server run on? How can it be changed?
What are sql server procedures?
How to list all user names in a database?
How to write a query with a full outer join in ms sql server?
What is a transaction and why is it important?
What is the most common trace flags used with sql server?
Explain steps of normalization?
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.
How to drop an existing stored procedure in ms sql server?
Mention the 3 ways to get a count of the number of records in a table.
How to update multiple rows with one update statement in ms sql server?