Forum Replies Created

Viewing 15 posts - 14,506 through 14,520 (of 49,552 total)

  • RE: sql 2005 not grabing enough memory

    How are you checking memory usage?

    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

    February 1, 2013 at 1:39 am

    #1583299

  • RE: Lost desktop pc

    Lynn Pettis (1/31/2013)

    And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.

    Question for those...

    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

    February 1, 2013 at 1:39 am

    #1583298

  • RE: Database mirroring question

    No, don't mess with the IP on the mirror.

    Read up on transparent client redirect first. You could also give the app both server's names to try, or do a DNS...

    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

    February 1, 2013 at 1:36 am

    #1583297

  • RE: Why use a Primary Key constraint (or Foreign for that matter)?

    It's not an automatic clustered index. It's by default clustered, that's all. Trivial to have a nonclustered primary key or a clustered unique constraint

    PK disallows nulls.

    This is more 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

    February 1, 2013 at 1:34 am

    #1583294

  • RE: SQL partition

    How do you have a single table in multiple filegroups?

    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

    January 31, 2013 at 2:14 pm

    #1583188

  • RE: SQL partition

    As the previous poster stated:

    DBCC SHRINKFILE (N'FILENAME' , EMPTYFILE)

    That's assuming it's a single filegroup with multiple files

    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

    January 31, 2013 at 2:01 pm

    #1583178

  • RE: Database mirroring question

    Read up on "Transparent Client Redirect". If you're using ADO.net or SNAC to connect, you don't need to do any of what you're suggesting.

    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

    January 31, 2013 at 1:20 pm

    #1583155

  • RE: Why use a Primary Key constraint (or Foreign for that matter)?

    dave-L (1/31/2013)

    Incidentally, I'm wondering about this for Foreign Keys as well. Beyond enforcing referential integrity and documentation, are there any advantages to actually declaring these constraints in the schema?...

    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

    January 31, 2013 at 1:04 pm

    #1583150

  • RE: Fastest way to count total number of rows...

    Dave62 (1/31/2013)

    GilaMonster (1/31/2013)

    The row count in sysindexes is not related to statistics updates.

    This quote from the MSDN page I referenced seems to indicate some relation.

    "Counts the total number of inserted,...

    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

    January 31, 2013 at 9:25 am

    #1583082

  • RE: Fastest way to count total number of rows...

    Dave62 (1/31/2013)

    The sysindexes table may not be as reliable because the accuracy will be determined by when the statistics have been updated.

    The row count in sysindexes is not related...

    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

    January 31, 2013 at 9:15 am

    #1583071

  • RE: Fastest way to count total number of rows...

    Lowell (1/31/2013)

    i thought you had to get the actual counts from sys.indexes; since the index must have a heap/PK index for every table, teh row counts are materialized exactly correct...

    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

    January 31, 2013 at 9:11 am

    #1583061

  • RE: Disable|Enable Index

    No, not at all.

    Just like you wouldn't randomly drop the clustered index (unless you want your table inaccessible for a while and your log to bloat), you wouldn't randomly disable...

    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

    January 31, 2013 at 8:53 am

    #1583047

  • RE: Low Performance - High CPU Problem and others...

    SQL MOD (1/31/2013)

    If SQL is still taking 100% of the CPU, then you haven't tuned all the CPU consuming queries. Keep going, not something you're going to solve in 5...

    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

    January 31, 2013 at 7:20 am

    #1583002

  • RE: logical consistency-based I/O error

    Nope. Corruption is something outside of SQL mangling the database. Check your IO subsystem

    You need to do a full DB repair, there's corruption not associated with an object 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

    January 31, 2013 at 7:15 am

    #1582996

  • RE: Join's and Index's

    You really should have both on a permanent table. Maybe as one and the same thing, maybe different.

    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

    January 31, 2013 at 7:10 am

    #1582992

Viewing 15 posts - 14,506 through 14,520 (of 49,552 total)