Forum Replies Created

Viewing 15 posts - 31,036 through 31,050 (of 49,552 total)

  • RE: Pagination AND "order by" play

    It does work, I've done it more than once.

    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

    August 26, 2010 at 4:51 am

    #1212205

  • RE: Pagination AND "order by" play

    Row_Number()?

    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

    August 26, 2010 at 4:29 am

    #1212195

  • RE: What is isolation level in SQL Server?

    I personally feel that the lmgtfy is condescending and borderline rude. It's not something I'll use except for serious repeat offenders. I think I've used it once, and I didn't...

    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

    August 26, 2010 at 4:22 am

    #1212194

  • RE: Creating new Database for a large Enterprise

    djdhere (8/25/2010)

    Hello,

    Thanks for the reply.

    This is not an assignment, its a project of my company.

    I used to work for a bank. The kind of project that you're talking about here...

    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

    August 26, 2010 at 3:56 am

    #1212183

  • RE: What is isolation level in SQL Server?

    http://www.google.com/search?q=%22isolation+level%22+%22sql+server%22

    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

    August 26, 2010 at 3:41 am

    #1212171

  • RE: Restore to a Point in Time - Recover from Update Blunder

    Denesh Naidoo (8/26/2010)

    My question is, without knowing the exact time the Update statement was run, how can I restore to a point - the last transaction that occured before 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

    August 26, 2010 at 3:35 am

    #1212164

  • RE: is performance can increase if existing database table moves into different file group

    pankaj.kuchaliya (8/26/2010)

    Is it possible to create the new file group on separate physical disk.

    Of course it is. Assuming that you have such disk space available.

    how can we do that.

    Ur... You...

    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

    August 26, 2010 at 3:31 am

    #1212159

  • RE: bcp and queryout problem

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic975434-391-1.aspx

    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

    August 26, 2010 at 2:40 am

    #1212138

  • RE: Cannot open database "couch_db" requested by the login. The login failed... [error]

    Jon-538504 (8/26/2010)

    I never changed the ASPNET logon; any idea what the default password is? How do I check?

    No idea, but why would you need it?

    I assume you have some...

    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

    August 26, 2010 at 2:37 am

    #1212136

  • RE: Backup

    What's the wait type for the process while that backup is running?

    Edit: Is that extra quote in your statement a typo?

    Should be

    BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename.BAK'

    not

    BACKUP...

    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

    August 26, 2010 at 2:35 am

    #1212135

  • RE: is performance can increase if existing database table moves into different file group

    It depends. If your current bottleneck is IO and the new filegroup is on a separate physical disk (with separate spindles), you may see a performance improvement.

    If your current bottleneck...

    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

    August 26, 2010 at 2:28 am

    #1212131

  • RE: Cannot open database "couch_db" requested by the login. The login failed... [error]

    Does the database couch_db exist on the server you're trying to connect to? Does the login ARMANI\ASPNET have rights to that database?

    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

    August 26, 2010 at 2:20 am

    #1212127

  • RE: Upgraded everything to ssis 2008

    srilu_bannu (8/25/2010)

    How to grab earlier version from source control

    Read through the documentation for whatever source control system you're using. It's going to be different for different source control apps.

    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

    August 26, 2010 at 2:11 am

    #1212122

  • RE: Upgraded everything to ssis 2008

    srilu_bannu (8/25/2010)

    all the packages are stored in a file and then to source control.

    Then grab an earlier version from source control.

    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

    August 25, 2010 at 3:19 pm

    #1211966

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/25/2010)

    It might also be the fact that you're getting tired of companies hiring people who don't know what they're doing. I know that I've had enough of...

    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

    August 25, 2010 at 2:13 pm

    #1211917

Viewing 15 posts - 31,036 through 31,050 (of 49,552 total)