Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

1st Prize - Nokia Lumia 710

Win 31 copies of

Answers by Anup Warrier

Previous 1 | 2 | 3 Next
  • Score
    Anup Warrier replied on 01-03-2012 21:22

    Identity column generates sequential values for new records using a seed value. SELECT SCOPEIDENTITY(),SELECT @@IDENTITY,SELECT IDENTCURRENT are the different ways to get IDENTITY. We can specify the Identity increment value to make it increasing or decreasing.

    Ex - Identity Seed = 100, Identity Increment value = -1 will give values like 100,99,98 etc.

  • Score
    Anup Warrier replied on 01-07-2012 11:04

    Collation refers to a set of rules that determine how data is sorted and compared.

    Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.

    Case sensitivity - If A and a, B and b, etc. are treated in the same way then it is case-insensitive.

    Accent sensitivity - If a and á, o and ó are treated in the same way, then it is accent-insensitive.

    Width sensitivity - When a single-byte character (half-width) and the same character when represented as a double-byte character (full-width) are treated differently then it is width sensitive.

  • Score
    Anup Warrier replied on 01-08-2012 21:12

    Rank,NTILE,DENSE_RANK and ROW Number are the ranking functions in SQL 2008 R2.

    Couple of new functions in SQL 2012 are-

    Conversion functions

    view sourceprint?1.* PARSE 2.* TRYCONVERT 3.* TRYPARSE Date and time functions


    Logical functions

    1.CHOOSE 2.IIF

    String functions

    1.* CONCAT 2.* FORMAT

  • Score
    Anup Warrier replied on 01-09-2012 17:35

    A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock.

    Deadlock can be tracked using the help of trace flags 1204 and 1222.

    In the event of a deadlock SQL Engine will mark one sessions as deadlock victim and the transaction is terminated and an error is sent back.

    Using a lower isolation level,keeping transactions short and in batch are some of the best ways to reduce deadlocks.

Previous 1 | 2 | 3 Next

Copyright © Rivera Informatic Private Ltd.