Forum Replies Created

Viewing 15 posts - 32,176 through 32,190 (of 49,552 total)

  • RE: Restore Transaction Log after Database has been Restored

    rew-370421 (6/27/2010)

    I was hoping I could script a job to copy that file to the Report Server and then restore WITH STANDBY to it every 15 minutes, too. 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

    June 27, 2010 at 11:36 pm

    #1185510

  • RE: database settings

    Joie Andrew (6/27/2010)

    - Did you ever mention if you were running 32 or 64-bit Windows? SQL?

    The only 64-bit version of SQL 2000 is the Itanium. There's no x64 version 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

    June 27, 2010 at 11:29 pm

    #1185507

  • RE: Are the posted questions getting worse?

    I'm running out of countries to support in the WC. SA's gone, england's chances look non-existent...

    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

    June 27, 2010 at 9:41 am

    #1185430

  • RE: Securing Tables and Stored Procedures

    One of the downsides of dynamic SQL is that you have to grant direct permissions to the objects used in the dynamic SQL. Ownership chaining doesn't apply. You can use...

    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

    June 27, 2010 at 8:21 am

    #1185427

  • RE: Database Sizing

    Jeff Moden (6/26/2010)

    carolwood (6/26/2010)

    Hello Friends.....

    Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It’s time consuming and more hours go...

    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

    June 27, 2010 at 4:25 am

    #1185420

  • RE: A easy way to see all the threads that a user has commented on?

    Go to their profile

    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

    June 27, 2010 at 4:24 am

    #1185419

  • RE: Concurrency in table without deadlocks

    Cláudio Silva (6/26/2010)

    GilaMonster (6/26/2010)

    Have you monitored for blocking?

    Are you talking about performance counters?

    No. I'm talking about blocked queries. You can't tell if there's blocking by looking at the locks taken,...

    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

    June 26, 2010 at 1:44 pm

    #1185388

  • RE: store password and user name

    Jeff Moden (6/26/2010)

    Since HASHBYTES doesn't use any form of encryption key, ... Don't use HASHBYTES as a form of encryption.

    It's not a form of encryption, it's a one way...

    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

    June 26, 2010 at 1:42 pm

    #1185387

  • RE: Query Performance Issue

    Please don't crosspost. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic943449-338-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

    June 26, 2010 at 1:06 pm

    #1185382

  • RE: Performance issues

    p.s. While Grant's book says 2008, the vast majority of it applies to 2005 as well.

    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

    June 26, 2010 at 1:05 pm

    #1185381

  • RE: Concurrency in table without deadlocks

    Have you monitored for blocking?

    Have you looked for long-running queries?

    Have you checked what the most common waits are on your system?

    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

    June 26, 2010 at 1:02 pm

    #1185380

  • RE: IntelliSense Question

    You haven't missed anything. MS's attempt at T-sQL intellisense is a pile of junk. If you can, turn it off and buy Redgate's SQL prompt

    Disclaimer: I'm a member 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

    June 26, 2010 at 11:07 am

    #1185367

  • RE: Securing Tables and Stored Procedures

    David-155102 (6/26/2010)

    I soon found that the database role not only needed EXECUTE permission to the stored procedures but also needed the INSERT, UPDATE, DELETE and SELECT permissions to the tables...

    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

    June 26, 2010 at 11:02 am

    #1185366

  • RE: Performance issues

    Grant's book is good.

    http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_1?ie=UTF8&s=books&qid=1277563626&sr=8-1

    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

    June 26, 2010 at 8:47 am

    #1185354

  • RE: How to get rid of the deadlocks?

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    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

    June 26, 2010 at 8:46 am

    #1185353

Viewing 15 posts - 32,176 through 32,190 (of 49,552 total)