Forum Replies Created

Viewing 15 posts - 19,576 through 19,590 (of 49,552 total)

  • RE: Restore sql server 2005 data in Azure

    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/Topic1272681-2571-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

    March 26, 2012 at 8:38 am

    #1464297

  • RE: Primary Key: GUID vs. INT

    Mark-101232 (3/26/2012)

    GilaMonster (3/26/2012)

    Nothing wrong with a guid primary key. What causes performance problems is a Guid column used as the clustered index key. So if you're going to have Guid...

    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

    March 26, 2012 at 7:55 am

    #1464263

  • RE: how to ensure the data is evenly among multiple data files

    dbdmora (3/26/2012)

    Thanks for the replies.

    We are not currently having an I/O issues. I just want to ensure having the data in the files not equal in size will not...

    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

    March 26, 2012 at 7:54 am

    #1464262

  • RE: clustered key question

    You really need 13 out of 15 columns in a table to define uniqueness? None of those 13 columns depend on any of the other 13 columns?

    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

    March 26, 2012 at 7:34 am

    #1464244

  • RE: Primary Key: GUID vs. INT

    Nothing wrong with a guid primary key. What causes performance problems is a Guid column used as the clustered index key. So if you're going to have Guid primary keys,...

    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

    March 26, 2012 at 7:32 am

    #1464242

  • RE: Resource (H/W + S/W) comparision between active/active and active/passive cluster

    Firstly lose the 'active passive and active/active terms'

    What you have is, a 2-node single instance cluster, a single SQL instance installed on a 2-node cluster

    What you want to create 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

    March 26, 2012 at 7:30 am

    #1464239

  • RE: how to ensure the data is evenly among multiple data files

    Before you start fiddling with files and settings... What is your goal here? What are you trying to achieve?

    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

    March 26, 2012 at 7:25 am

    #1464233

  • RE: clustered key question

    sqlnaive (3/26/2012)

    In my case this table gets populated daily with around 1000 records and also we daily purge around 800 records from this table. Will that be a good idea...

    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

    March 26, 2012 at 7:06 am

    #1464219

  • RE: how to ensure the data is evenly among multiple data files

    If all the files are in the same filegroup, the data will be evenly distributed across them due to the proportional fill algorithm SQL uses.

    Performance from multiple filegroups is a...

    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

    March 26, 2012 at 7:05 am

    #1464217

  • RE: Memory - Total/Target always using same value?

    ananda.murugesan (3/26/2012)

    I m facing problem for Procedure cache Hit ratio = 70 to 75 %

    Then you need to start looking at your code, see what you're running and why it's...

    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

    March 26, 2012 at 6:59 am

    #1464215

  • RE: delete records doesn't make the table size shrink

    To reduce the table size, rebuild the clustered index. The problem is likely that the deletes have resulted in lots of free space on the pages.

    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

    March 26, 2012 at 4:33 am

    #1464147

  • RE: Trage Flag info

    Can you be more detailed? What query notification messages? You have some query notifications enabled?

    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

    March 26, 2012 at 4:19 am

    #1464142

  • RE: not getting rid of physical reads

    eforta.it (3/25/2012)

    I think we're crossing wires here...

    My example was Update has occurred and then select whilst update page still dirty.

    You're taking my example and reversing it round to: Select 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

    March 26, 2012 at 4:09 am

    #1464137

  • RE: not getting rid of physical reads

    eforta.it (3/25/2012)

    If you have a dirty page in memory and another user does a SELECT that would pull the same page - does it take from the disk or 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

    March 25, 2012 at 5:37 pm

    #1464057

  • RE: Detect data changes in a "read-only" database?

    Jeff Moden (3/25/2012)

    I make absolutely no claims to its accuracy or viablility because, like I said, I've not tested it (yet). The methods in that article are used to...

    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

    March 25, 2012 at 4:52 pm

    #1464055

Viewing 15 posts - 19,576 through 19,590 (of 49,552 total)