Forum Replies Created

Viewing 15 posts - 18,691 through 18,705 (of 49,552 total)

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    Huh?

    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

    April 30, 2012 at 2:50 pm

    #1481505

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    If you want the index partitioned on a partition scheme, then the name of the partition scheme, it you want it unpartitioned in a filegroup, then the name 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

    April 30, 2012 at 2:43 pm

    #1481501

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    No Books online available?

    No such syntax as create primary key.

    CREATE UNIQUE CLUSTERED INDEX ... WITH (DROP_EXISTING = ON) ON <whereever it's supposed to go>

    Untested.

    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

    April 30, 2012 at 2:33 pm

    #1481493

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    Rich Yarger (4/30/2012)

    My question is when I recreate the Clustered Index/Primary Key, does my ON clause need to be the name of the Partition Scheme I am using? And...

    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

    April 30, 2012 at 1:40 pm

    #1481459

  • RE: Monitoring slq server deadlocks

    Guras (4/30/2012)

    GilaMonster (4/30/2012)

    Deadlocks don't cause timeouts.

    Timeouts are a client-side setting and happen when the client decides that SQL Server is taking too long to run a query, and the client...

    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

    April 30, 2012 at 12:53 pm

    #1481422

  • RE: Monitoring slq server deadlocks

    Guras (4/30/2012)

    dbcc tracestatus

    TraceFlag Status Global Session

    --------- ------ ------ -------

    1204 1 1 0

    1222 ...

    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

    April 30, 2012 at 12:25 pm

    #1481406

  • RE: Monitoring slq server deadlocks

    Deadlocks don't cause timeouts.

    Timeouts are a client-side setting and happen when the client decides that SQL Server is taking too long to run a query, and the client aborts 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

    April 30, 2012 at 12:23 pm

    #1481404

  • RE: Compare Database Objects from Multiple Instances

    Create a utilities database on each server. Use MSForEachDB on both instances to create insert a list of all objects in all databases into a table in tht utilities 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

    April 30, 2012 at 10:11 am

    #1481339

  • RE: Compare Database Objects from Multiple Instances

    What you suggest will work.

    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

    April 30, 2012 at 9:25 am

    #1481311

  • RE: Compare Database Objects from Multiple Instances

    Are you solely trying to see what objects are on one instance and not the other? No checks for whether objects named the same have the same definition, no checks...

    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

    April 30, 2012 at 9:08 am

    #1481303

  • RE: How to revoke execute permissions to ALL stored procedures to a windows user

    So you want to completely undo what the grant statement you ran did?

    revoke execute to [windowsuser]

    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

    April 30, 2012 at 8:07 am

    #1481258

  • RE: Will Tables affect Performance...?

    Nothing to do with performance.

    Your first design is what's called 'The One Lookup Table' design, and it's usually a complete disaster. With that design it's all too easy for data...

    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

    April 30, 2012 at 7:21 am

    #1481220

  • RE: Finding edition for database engine

    Open up SQL Server config manager. In the properties of each service you'll find the version.

    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

    April 30, 2012 at 7:12 am

    #1481216

  • RE: How to do RCA (Root Cause analysis)

    Simha24 (4/30/2012)

    How can i upgrade other lower version clients to SP3(because i have an issue while creating mantenance plan)

    Run SP3 on those instances and select the client tools to patch.

    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

    April 30, 2012 at 6:57 am

    #1481209

  • RE: Cannot Kill Process stays in KILLED/ROLLBACK status

    Jeff Moden (4/30/2012)

    There's a good chance that when a "rollback" hangs up like this, that it's waiting on something in another spid to complete. It's sometimes difficult to find...

    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

    April 30, 2012 at 6:54 am

    #1481205

Viewing 15 posts - 18,691 through 18,705 (of 49,552 total)