Forum Replies Created

Viewing 15 posts - 20,821 through 20,835 (of 49,552 total)

  • RE: Casting and implied data type conversion

    garystephen (1/23/2012)

    1. Why did T-SQL correctly infer that I wanted a decimal value when I did (INTEGER*.02) but not when I did (INTEGER/50)? The statements are mathematically equivalent, and it...

    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 23, 2012 at 9:56 am

    #1437212

  • RE: Restore from Differental Backup - Migrating to new Reporting Server

    You can restore the full backup WITH STANDBY, that makes the DB read only (as opposed to completely inaccessible as with WITH NORECOVERY), you can then query and investigate 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

    January 23, 2012 at 9:34 am

    #1437202

  • RE: TempDB Usage Query

    So you are running read committed snapshot. That means that you'll have the version store in TempDB. Depending on the types of transactions and frequency, that can get very large,...

    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 23, 2012 at 9:18 am

    #1437194

  • RE: .mdf

    chrisians2929 (1/23/2012)

    its mine and your secret,

    its my key and cut above the rest,

    this is many hours of my logic

    and my key to employment or money in my pocket from anywhere...

    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 23, 2012 at 9:14 am

    #1437190

  • RE: Transactions deleted in production and stage table only populating new data

    Help with what?

    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 23, 2012 at 8:54 am

    #1437180

  • RE: Creating Index on DATETIME Column based just DATE

    So with an index on the datetime column the query is still slow? If so, post the query at the very least.

    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 23, 2012 at 8:52 am

    #1437177

  • RE: Users Delete permission issue

    virgo (1/23/2012)

    @GilaMonster - Yes the login is sysadmin and not a database owner on the database I want to deny the delete

    You cannot deny anything to a sysadmin. They have...

    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 23, 2012 at 8:49 am

    #1437174

  • RE: Users Delete permission issue

    Is that login a database owner or sysadmin?

    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 23, 2012 at 4:37 am

    #1437016

  • RE: procedure cache hit ratio too high?

    If the app is fine and the users aren't complaining, then don't waste your time looking for problems that don't exist.

    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 23, 2012 at 4:35 am

    #1437015

  • RE: procedure cache hit ratio too high?

    ananda.murugesan (1/23/2012)

    Percentage of time when SQL Server looks for an execution plan in the procedure cache and finds it for this instance. SQL Server finding precentage value 95%, how 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

    January 23, 2012 at 3:56 am

    #1437004

  • RE: How to Create a New Partition on a Cube using T-SQL in SQL Server 2000?

    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/Topic1239976-17-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

    January 23, 2012 at 2:33 am

    #1436985

  • RE: maximum database size of sql server 2005 express edition

    4GB. That's the maximum size of the data files of the database, not the maximum size of one of the data files of the database, so the total size 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

    January 23, 2012 at 2:32 am

    #1436983

  • RE: Server for SQL Server 2008 R2

    Antivirus on prod server is fine, just set the exclusions properly for the SQL 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 23, 2012 at 2:30 am

    #1436982

  • RE: procedure cache hit ratio too high?

    ananda.murugesan (1/23/2012)

    Hi,

    Procedure cache Hit ratio..actually using 95%, I want to reduce the execution % for the stored procedure.

    The execution %? Exactly what do you mean by that?

    how to set...

    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 23, 2012 at 2:29 am

    #1436980

  • RE: TempDB Log Growth Help

    Fraggle-805517 (1/22/2012)

    I am guess this is probably due to the sever restart

    You didn't mention you'd restarted the server...

    Any evidence of what caused the growth would have been erased by 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

    January 22, 2012 at 12:53 pm

    #1436915

Viewing 15 posts - 20,821 through 20,835 (of 49,552 total)