Forum Replies Created

Viewing 15 posts - 211 through 225 (of 319 total)

  • RE: Few interview questions

    The answer is... whichever one that implies a temporal order for when the inserts occurred. In other words, either an IDENTITY column or some temporal column such as the...

    October 7, 2008 at 10:45 pm

    #882104

  • RE: Few interview questions

    1) Is it possible to have a NULL value in a foreign key field?

    Sure, providing the column is declared nullable.

    does Foreign key allows a column to be nullable.

    2) If I...

    October 7, 2008 at 3:46 am

    #881513

  • RE: Need Script to compile n no of stored proc

    Madhivanan (9/25/2008)

    Ahmad Osama (9/25/2008)

    Hi All,

    I have to compile some 30-40 stored procedures at the client end.

    Currently I am do this by compiling each proc one by one in a...

    September 25, 2008 at 9:59 pm

    #877417

  • RE: Backup - Restore issue - FAT32 and NTFS File System

    Glen (9/25/2008)

    Sure. If DB is over 2 GB combined size - you will get errors, since 2GB is maximum FAT32 allows.

    BTW, MS does not recommend using FAT32 for...

    September 25, 2008 at 8:43 am

    #877062

  • RE: Backup - Restore issue - FAT32 and NTFS File System

    Glen (9/25/2008)

    General answer would be yes, since the backup file format irrelevant from the file system, but then it depends.

    If the backup size is over 2GB (FAT32 limitation) -...

    September 25, 2008 at 7:57 am

    #877018

  • RE: How table reserve space?

    pls elaborate!!!

    September 24, 2008 at 1:11 pm

    #876641

  • RE: TempDb

    Read this... http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

    September 24, 2008 at 1:09 pm

    #876638

  • RE: Index Vs Select criteria sequence

    Jaya Chitra (9/23/2008)

    Dear All,

    Thanks for you replies.

    I have the table which contains some properties of the document in my knowledge repository.

    The user can search by specifying any values to the...

    September 24, 2008 at 4:50 am

    #876218

  • RE: Index Vs Select criteria sequence

    Jaya Chitra (9/23/2008)

    Dear All,

    Thanks for you replies.

    I have the table which contains some properties of the document in my knowledge repository.

    The user can search by specifying any values to the...

    September 24, 2008 at 4:50 am

    #876217

  • RE: Another Backup scenario

    GilaMonster (9/23/2008)

    To recover in this scenario you need a full backup from before the table was dropped and an unbroken log backup chain from that full backup up until just...

    September 23, 2008 at 9:37 pm

    #876100

  • RE: Another Backup scenario

    Steve Jones - Editor (9/23/2008)

    What exactly do you have?

    Full backup on: __/__/2008?

    Log Backup?

    When was the table deleted?

    What has been done since the table was deleted.

    Latest full backup...no...

    September 23, 2008 at 11:20 am

    #875915

  • RE: Another Backup scenario

    Cath Trimble (9/23/2008)

    If a Full backup has never been taken, there is no way to recover the table - any backup taken after the table was deleted would not include...

    September 23, 2008 at 7:37 am

    #875637

  • RE: Caught in Wrong Job ....

    Thanks alot David...my present profile dosn't gives me chance to work SQL rather it is Visua source safe and team foundation server am working on..

    but I will definetely work my...

    September 23, 2008 at 6:31 am

    #875589

  • RE: A database backup scenario

    GilaMonster (9/23/2008)

    Given that, you would need to restore in the following order

    Full backup

    Diff 2

    Tran log 1

    Tran log 2

    The transaction logs form a chain and you need all of the tran...

    September 23, 2008 at 3:36 am

    #875512

  • RE: Caught in Wrong Job ....

    GilaMonster (9/23/2008)

    Ahmad Osama (9/22/2008)

    tho i think that these are the core DBA fields and each one shud hav pratical knowledge of them....

    What about backups (recoverability), database design, performance tuning, general...

    September 23, 2008 at 3:09 am

    #875500

Viewing 15 posts - 211 through 225 (of 319 total)