Interested to Buy Any Domain ? << Click Here >> for more details...
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
- 0 Answers
- 982 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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.
Where are SQL server users names and passwords are stored in sql server?
Explain what is the function of sql server agent windows service?
What is a trigger? Why we need it?
What are the types of subquery?
How to turn off warning messages during php execution?
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000
Can we add a cpu to sql server?
Can you explain the types of Joins that we can have with Sql Server?
How do we know if any query is retrieving a large amount of data or very little data?
wht's the differece between sqlserver05 and sqlserver2000
Explain the stored procedure?
-
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)
