What area unit the various kinds of info compression introduced in sql server 2008?
Answer / Hanish Kumar Arora
The various types of information compression introduced in SQL Server 2008 are measured in percentages. They include row compression, page compression, and columnstore index compression.
| Is This Answer Correct ? | 0 Yes | 0 No |
Where the sql logs gets stored?
How to resolve the orphan use problem? : sql server security
What is cursor in ms sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Explain what are magic tables in sql server?
Can you explain the role of each service?
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
Explain important index characteristics?
What is apply operator in sql?
What is logshipping and its purpose?
Explain what is meant by replication of database?
What is #temp and @table variable in SQL server?
1 Answers Beahead Private Limited,
Oracle (3253)
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)