Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps need to be take improve the speed of a SQLDATA Server?
- 2 Answers
- 5322 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajan chauhan
Check the some step
1. Space in HD
2. Use DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFER
3. Cover Index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I run a trace in sql server?
Who is the owner of a schema in ms sql server?
What is a heap?
what is the system function to get the current user's user id? : Sql server database administration
What are the different types of collation sensitivity?
How to verify a user name with sqlcmd tool?
Explain use of expression builder.
What is collation sensitivity?
What number aggregate functions are accessible there in sql?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Write a SQL query in order to merge two different columns into single column?
What happens when transaction log is full?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is open database communication (odbc)?
How dts is used to extract, transform and consolidate data?
