Sparse columns of sql server 2008
Explain about the sparse columns of sql server 2008.
Expert
A column along with an optimized storage for null values is termed as sparse column. Sparse columns decrease the storage space requirements for null values. Within a scenario of saving 20 percent to 40 percent of storage space, sparse columns can be seemed. They are created by using CREATE or ALTER TABLE statement.
A huge number of user defined properties can be accessed with using sparse columns and filtered indexes allowed applications like Share Point Services of windows are efficiently access and store.
Describe the Hot Add CPU in sql server 2008.
What is BLOB?
Explain about a linked server?
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
Define the term Posting in database.
Illustrates the Indexes in Structure Query Language?
Define the Notification services.
What are the unique keys of database programming?
Explain about the extended events within sql server 2008.
Differentiate between FLOAT and DOUBLE?
18,76,764
1952980 Asked
3,689
Active Tutors
1420069
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!