December 2006 Entries

Restore database example

posted @ Sunday, December 31, 2006 4:57 PM | Feedback (0)

Configuration commands

posted @ Sunday, December 31, 2006 1:29 PM | Feedback (0)

Rename database name

posted @ Sunday, December 31, 2006 11:57 AM | Feedback (0)

Integrity & Constraint Type

posted @ Sunday, December 24, 2006 3:36 PM | Feedback (0)

Secondary XML Index

posted @ Sunday, December 24, 2006 2:49 PM | Feedback (0)

Create XML Index

posted @ Sunday, December 24, 2006 2:44 PM | Feedback (0)

Defragmentation

posted @ Sunday, December 24, 2006 2:36 PM | Feedback (0)

Options to create indexes on computed columns

posted @ Sunday, December 24, 2006 1:30 PM | Feedback (0)

Nonclustered Index

posted @ Sunday, December 24, 2006 11:43 AM | Feedback (0)

Clustered Index

posted @ Sunday, December 24, 2006 11:30 AM | Feedback (0)

XQUERY

posted @ Sunday, December 24, 2006 10:59 AM | Feedback (0)

OPENXML

posted @ Sunday, December 24, 2006 9:46 AM | Feedback (0)

Partitioned Tables

posted @ Saturday, December 23, 2006 4:29 PM | Feedback (0)

Large data values

posted @ Saturday, December 23, 2006 3:17 PM | Feedback (0)

Filegroup

posted @ Saturday, December 23, 2006 11:34 AM | Feedback (0)

Recovery Process

posted @ Saturday, December 23, 2006 10:20 AM | Feedback (0)

CheckPoint

posted @ Saturday, December 23, 2006 10:13 AM | Feedback (0)

ACID

posted @ Saturday, December 23, 2006 10:06 AM | Feedback (0)

PIVOT

posted @ Saturday, December 16, 2006 4:42 PM | Feedback (0)

WITH ROLLUP ,WITH CUBE ,GROUPING()

posted @ Saturday, December 16, 2006 4:23 PM | Feedback (0)

row_number(), rank(), dense_rank()

posted @ Saturday, December 16, 2006 3:25 PM | Feedback (0)

Query schema in SQL 2005

posted @ Saturday, December 16, 2006 1:09 PM | Feedback (0)