Forum Replies Created

Viewing 15 posts - 24,346 through 24,360 (of 26,490 total)

  • RE: finding duplicates... help needed

    Still confused due to a previous post in this thread. Some one had added additional names that had the same SSN as D Duck, and you indicated that those...

  • RE: Software/Database Development Hiring Practices

    Tangent...

    "Character is what you do when no one's watching." --Russell W. Gough

    Like coming to a complete stop at a 4-way intersect in the middle of no where with no...

  • RE: finding duplicates... help needed

    One, show us the code you have developed and tried.

    Two, create a more represenative set of data that is similiar to what you are working with and what the result...

  • RE: Differential not restoring

    If it works like most other backup chains, yes, it looks like you need to restore the full backup. the file group backup, then the differential backup.

    😎

  • RE: Differential not restoring

    Out of curiosity, what are the values for the first_lsn, last_lsn, checkpoint_lsn, database_backup_lsn, and last_recovery_fork_guid for these three backups from msdb.dbo.backupset?

    😎

  • RE: T-SQL Challenge, One row to Many based on Quantity

    I agree with Matt Miller. This is a good candidate for using a tally table.

    😎

  • RE: Differential not restoring

    From BOL:

    A differential file backup requires a full file backup as a base. For more information about full file backups, see Full File Backups.

    Yes, the file group backup may...

  • RE: Differential not restoring

    Pam Brisjar (8/22/2008)


    Restored most recent full backup with NORECOVERY.

    Attempt to restore differential backup and get "backup cannot be restored because the database has not been restored to the correct earlier...

  • RE: T-SQL Challenge, One row to Many based on Quantity

    I'm a visually oriented type, based on the sample data provided what would the output look like?

    😎

  • RE: Software/Database Development Hiring Practices

    I don't think this is an IT only phenomenon. I am sure that this occurs in many occupations. The use of automated processes to prescan applicants is used...

  • RE: finding duplicates... help needed

    Guessing here, but is this what you are trying to accomplish?

    Current:

    LastName FirstName SSN

    Duck ...

  • RE: Super SQLServer configuration

    SQL Noob (8/22/2008)


    Thayal Muhunthan (8/22/2008)


    Question on CAL licences again ?

    If we have 3 users accessing the SQL server using an third party application, do we calculate 3 or 1 CAL...

  • RE: Transaction Log & Shrinking doesnt work

    usman.tanveer (8/22/2008)


    "I'm not following you here. No transaction log backup will ever do either of the operations you mentioned (remove virtual log files, or shrink the size of the...

  • RE: Super SQLServer configuration

    By the number of users. Even if you use an application server with only 20 connections from the app server to the database server, you have to count the...

  • RE: Sql server 2005 editions

    Just be sure that while using the developer edition that you don't use features that are not available in the standard edition if that is your target production environment.

    😎

Viewing 15 posts - 24,346 through 24,360 (of 26,490 total)