Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Datepart() and Datename() in SqlServer?
- 0 Answers
- 1205 Views
- Infosys, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is named query? : sql server analysis services, ssas
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.
What method is used by the Command classes to execute SQL statements that return single values?
What is the Control Flow in SSIS
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is Service Broker in sql server 2012?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Explain the ways to controlling cursor behavior?
Is it safe to delete log files?
What are the steps need to be take improve the speed of a SQLDATA Server?
What is indexing in sql server with example?
-
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)
