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
- 5140 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is physical sort data and logical sort data in index?
What is replication with database mirroring? : sql server database administration
How much is a sql server license?
How do you persist objects, permissions in tempdb
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is a Join and explain its types?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
How to skip remaining statements in a loop block using continue statements?
Define constraints and give an example of their use?
How do I find query history in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
