Forum Replies Created

Viewing 15 posts - 30,841 through 30,855 (of 49,552 total)

  • RE: memory not releasing

    Max memory just controls the size of the buffer pool. SQL will use some memory beyond that, though it's usually not much.

    Got CLR? Custom extended stored procs? Both use memory...

    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

    September 8, 2010 at 11:16 pm

    #1218364

  • RE: Scratching my head? Simple query takes minutes to run.

    geerobg (9/8/2010)

    I suppose I need to work more on the "learnt" and less of the "burnt".

    Thank you for the help... Parameter Sniffing huh? Ha.

    If you're interested, that param sniffing article...

    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

    September 8, 2010 at 11:12 pm

    #1218363

  • RE: Cluster Index - Huge Table - 0 Fragmentation - Clustered Index Scan???

    Derrick Smith (9/8/2010)

    I'm fairly sure that unless you did an sp_recompile on the table/proc, it would just grab that data right from the cache.

    DBCC FREEPROCCACHE. sp_recompile will force 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

    September 8, 2010 at 11:08 pm

    #1218362

  • RE: Cluster Index - Huge Table - 0 Fragmentation - Clustered Index Scan???

    Stale statistics. I suspected that might be the case. That's why I wanted to see the full exec plan

    Please run UPDATE STATISTICS <Table name> WITH FULLSCAN on the original table,...

    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

    September 8, 2010 at 3:47 pm

    #1218289

  • RE: cross join table based function: weird issue

    If this is an ad-hoc query, here's a trick...

    use master

    go

    select

    e.eecEEID,

    e.NameLast,

    e.NameFirstMiddle,

    jobs.ejhJobCode,

    jobs.ejfJobEffDate

    from <database name>.dbo.v_EmpPersComp e

    cross apply <database name>.dbo.fn_BI_gnsa_EmpHJob(e.eedEEID, 2, 'EN')...

    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

    September 8, 2010 at 3:15 pm

    #1218276

  • RE: cross join table based function: weird issue

    bbaley (9/8/2010)

    Darn it. I am unable to change the compatibility level on this db....

    Why 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

    September 8, 2010 at 2:58 pm

    #1218265

  • RE: Database stuck "in recovery"

    Cool. So go and take one of those backup exec backups and your log backups and see if you can restore to a point in time.

    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

    September 8, 2010 at 2:56 pm

    #1218263

  • RE: Database stuck "in recovery"

    yessen (9/8/2010)

    Well my sysadmin uses backup-exec software to save the mdf and ldf files every day, which is not the full backup of the database. If lets say everything crashes,...

    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

    September 8, 2010 at 2:23 pm

    #1218246

  • RE: Disabling @@ Commands from SQL User

    I don't believe you can.

    Rather concentrate on fixing the SQL Injection vulnerability (hint: parameterised queries). Seeing the version of SQL is one of the more harmeless things the hacker could...

    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

    September 8, 2010 at 2:12 pm

    #1218234

  • RE: SQL Query

    Also, is this MS Access (as the forum name says) or SQL Server (as the thread title and contents imply)?

    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

    September 8, 2010 at 12:00 pm

    #1218145

  • RE: Scratching my head? Simple query takes minutes to run.

    geerobg (9/8/2010)

    Gail, thanks. Attached are the execution plans and table definitions. I have whittled all but the one table out of the query and removed the "so_ref not like '%...

    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

    September 8, 2010 at 11:53 am

    #1218137

  • RE: Are the posted questions getting worse?

    WayneS (9/8/2010)

    How about a table where the PK is on a text datatype? (as are most of the other columns also!)

    After a day full of stupidity, I'm just about out...

    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

    September 8, 2010 at 11:37 am

    #1218129

  • RE: SQL Query

    You know, just a wild guess, but... you didn't even try to run that code you posted, did you? If you can't be bothered to find and fix syntax errors,...

    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

    September 8, 2010 at 11:37 am

    #1218128

  • RE: Restore possible?

    You know, there are things called search engines...

    http://www.google.com/search?q=Vardecimal+site%3Amsdn.microsoft.com

    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

    September 8, 2010 at 11:33 am

    #1218125

  • RE: Restore possible?

    It's possible unless you're using the VARDECIMAL storage option that was added in SP2. Enabling that option bumps the internal database version and if that version is higher than 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

    September 8, 2010 at 9:54 am

    #1218066

Viewing 15 posts - 30,841 through 30,855 (of 49,552 total)