what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
- 0 Answers
- 730 Views
- I also Faced
- E-Mail Answers
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?
What is onf in normalization form?
How do you manipulate data?
How to get the query of a table in sql server?
What is a covering index?
Why use cursor in sql server?
What is a schema in ms sql server 2005?
what is Archive old data?
What is standby servers? Explain types of standby servers.
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
How many levels of sp nesting is possible?
How you can minimize the deadlock situation?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
