LOGIN

NEW USER

Reply

New Forum

SqlCmd is bassically a very important for that SQL Server It can be work with two modes :
> BATCH and
> Intractive Mode
It is the Enhaceversion of isql which is depricated Eventuallyand osql which is not include in SQL Server 2005 RTM, It is the Better replacement of OSQL and ISQL. It provides way more functionality that other two options.

Aggregation Function is basically a type of function, which is use for the calculation on the set of values and It is also return the single value , Its also have a HAVING CLAUSE, Which is used along with GROUP BY.for filtering query using aggregate values, Its ignore NULL Values excpt COUNT Function, Its have a many functions which is there :
> AVG
> MIN
> CHECKSUM_AGG
> SUM
> COUNT
> STDEV
> COUNT_BIG
> STDEVP
> GROUPING
> VAR
> MAX
> VARP

A pivot table is bassically use for the sorting the table, and also doing the work in table like a counting and totalling the data which is stored in one table or spread sheet and its also creat the second table for the display the sumrized data,It can be turns the value of a specified column into column names, effectively rotating a table. but in case of Unpivote Its a exactly opposit to the pivote.

Dictionary Compression is bassically use for the searching . Seaching bassically the duolicat This Dictionary mainly work is the differentiate between prefix and dictionary compression is that prefix is only restricted to one column while dictionary is applicable to the complete page. value thoroughout the page,and stores them to CI

EXCEPT clause is a bassically use on the oracle, It is similar to MINUS Operation which is also use in Oracle. Both are queries are returns all rows in the first query that are not returned in the second query. Each SQL statement within the EXCEPT query and MINUS query must have the same number of fields should have the same no and also have a same result sets and same data types.

Row Function is bassically use for the retuning a coulumns which is type of expressions. which is contain the rows no with in the result set.This is only a number used in the context of the result set, if the result changes, the ROW_NUMBER() will change.

A sparse column is bassically a tool of the data base which is use for the decrease physical storage amount which is used in a database.Sparse columns also be use for the redusing work Its reduce the space requirements for null values at the cost of more overhead to retrieve no null values. They are the normal columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve no null values.

The TOP operator is bassically use the new addition of SQL Server 2008 its have a facility provides to accepts the literal values and can be used with INSERT,UPDATE. And DELETES statements.,Its mainly used to be returned by a query from specified no of rows .

Database mirroring and Replication can be work together and they are provide availability for the publication database. Database mirroring bassically work in two copies of a single database that are rarlly use on different computers. If we have to given any time for a only one copy of the database is currently available to clients which is called as the principal database. Updates made by clients to the principal database are applied on the other copy of the database, known as the mirror database. Mirroring involves applying the transaction log from every insertion, update, or deletion made on the principal database onto the mirror database.