Forum Replies Created

Viewing 15 posts - 43,186 through 43,200 (of 49,552 total)

  • RE: ORDER BY in INSERT INTO, how is it done?

    Henk Schreij (11/12/2008)

    The data are now in the correct order in the ID (the clustered PK).

    Thank you 😎

    Excellent.

    Just be aware that doesn't mean that the data will be returned in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 6:35 am

    #897470

  • RE: How To utilize log files

    Anu (11/12/2008)

    there is ... there have to be..

    Yes. Restore a backup.

    If you don't have a backup you don't get your data back. That's the point of a backup. SQL...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 6:32 am

    #897466

  • RE: Securing Data

    krayknot (11/12/2008)

    he wants to hide the table and he can hide the xml.

    Where? In another table? In the file system? Some other place?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 1:27 am

    #897378

  • RE: Restoredatabse problem

    Backup restore isn't a good option here. Two things you can consider.

    Database mirroring with a database snapshot on the mirror. The snapshot is readonly and is an image of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 1:24 am

    #897377

  • RE: Need help to analyse mini dump

    kokila (11/12/2008)

    Is there any other way so that we can only analyze and find out the problem.

    You can download a debugger (http://www.microsoft.com/whdc/devtools/debugging/default.mspx), point it's symbols path at MS's public symbols...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 1:11 am

    #897373

  • RE: How To utilize log files

    Anu (11/12/2008)

    any way sql server have the facility to get back the older state like restore . if any tiger know that plzz enclose the information.

    Yup! Restore a backup that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:50 am

    #897370

  • RE: SQL Server 2005 SP3

    Just be careful with SP3. What's available right now is RC0 - a release candidate. It's still in testing and there may still be bugs. It should not be applied...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:46 am

    #897369

  • RE: Stored Procedure speed versus Select Statement

    rbarryyoung (11/11/2008)

    Right, but counting on that is known as "Security through Obscurity" and it is generally understood to be a security fallacy (as in "Not secure"), because you are relying...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:37 am

    #897368

  • RE: Restoredatabse problem

    That's easy enough. Restore the full with no recovery and each day copy the diff over and restore that with norecovery.

    What do you want to do with the second server?...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:36 am

    #897367

  • RE: Securing Data

    krayknot (11/12/2008)

    yes

    store the pricing in xml and at the tiime of requirement, call the xml data in table variable (if the size is upto medium) and use temp table temprarily.

    How...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:35 am

    #897366

  • RE: MSDB databa sedeleted accidentally

    Chirag (11/11/2008)

    You will have to re-create all your jobs, maintenance plans etc.

    And DTS packages and SSIS packages. You've also lost the backup history.

    Now, go and set up a backup schedule...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:33 am

    #897365

  • RE: Why LSN Missing in Logshipping.

    My guess is that you're truncating the tran log at some point. Look through the jobs and see if you have a BACKUP LOG ... WITH TRUNCATE_ONLY or BACKUP LOG...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:32 am

    #897364

  • RE: Need help to analyse mini dump

    They're produced by a crash of the DB engine or an illegal operation by one of the processes. The best thing to do if you're getting frequent stack dumps is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:30 am

    #897363

  • RE: Securing Data

    sairams (11/11/2008)

    Dear kshitij,

    Thanks 4 your reply...

    Encrypting the confidential values means i need to do a mass work on the application..Is there any other better option

    No better option. Encryption...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:28 am

    #897362

  • RE: Database Mirroring Transport is disabled when setting up Database Mirroring

    Have you created the endpoints? Can you connect from the principal to the mirror (try ping) and vis versa?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2008 at 12:19 am

    #897361

Viewing 15 posts - 43,186 through 43,200 (of 49,552 total)