Forum Replies Created

Viewing 15 posts - 14,641 through 14,655 (of 49,552 total)

  • RE: Killed clustered index creation, running out of space

    Little tighter than I like, but should be OK. Just specify sort in temp DB (assuming TempDB's on another drive or has decent free space)

    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 24, 2013 at 10:19 am

    #1580631

  • RE: Partitioning - SQl server 2005

    poratips (1/24/2013)

    We have Database AUENG and tables called AUSM it has two date columns and it's very big table and we would like to make a partition table.

    Why?...

    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 24, 2013 at 10:17 am

    #1580628

  • RE: Undocumented commands, trace flags, etc...

    Undocumented means just that, it's not listed in the official documentation (BoL). Some things are mentioned in kb articles, some in discussions with MS engineers or devs. Some can be...

    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 24, 2013 at 9:24 am

    #1580597

  • RE: PLE (Page life expectancy).

    ben.brugman (1/24/2013)

    At the moment I am missing the link with the Windows Page file. (second and third link). Because I assume (correct me if I am wrong) that the SQL-server...

    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 24, 2013 at 9:18 am

    #1580594

  • RE: tempdb: only one of several data files is growing on Index-Reorg

    Right, so the TempDB usage is not due to the reorg using TempDB, it's the snapshot isolation and the row version store.

    To be honest, I'm not 100% sure how 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 24, 2013 at 7:17 am

    #1580530

  • RE: Tables Involved in Stored procedure

    runal_jagtap (1/24/2013)

    Sunday no one wotks on the Database

    will perfom the below activity..

    1) Full Backup - Using manitenencae plan

    2) Transaction Log Backup - Using manitenencae plan

    3) Truncate Logs (this grows up...

    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 24, 2013 at 6:01 am

    #1580509

  • RE: Failover clustering with Database Mirroring

    SQL* (1/24/2013)

    High availability : Means 99.99% of times data must be available.

    By who's definition? 4 nines is too much for some, not enough for others. Your uptime requirements for HA...

    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 24, 2013 at 5:59 am

    #1580508

  • RE: tempdb: only one of several data files is growing on Index-Reorg

    WolfgangE (1/24/2013)

    Our tempdb-database is configured having 8 data files. As Microsoft recommends we have one data file for each core, all having same file size and grow rate.

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

    When we start...

    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 24, 2013 at 5:53 am

    #1580505

  • RE: Indexing where table is in join and where clause

    james marriot (1/24/2013)

    1. when a table is in the join and where clause, do i create the index with the join col first, or the where col first ?

    e.g create...

    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 24, 2013 at 4:58 am

    #1580481

  • RE: Indexing where table is in join and where clause

    Bhuvnesh (1/24/2013)

    Order table will have index on InvoiceID and InvoiceNumber

    OrderLines will have ix_test on orderLines(InvoiceId, ProductID,status) Include(.....)

    Not the most efficient order for the columns within...

    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 24, 2013 at 4:54 am

    #1580478

  • RE: Procedure is taking 15 seconds after service restart but from second time procedure takes 1 sec

    Very likely has nothing whatsoever to do with the execution plan. 15 seconds is far longer than SQL takes to compile anything other than a ridiculously complex query.

    Restarting cleared 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 24, 2013 at 4:49 am

    #1580477

  • RE: LOCK TABLE PROBLEM

    Wait until whatever is using the rows has finished and the locks are released. If there's an orphaned transaction locking the rows, check with DBCC OpenTran and investigate whether or...

    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 24, 2013 at 4:47 am

    #1580475

  • RE: Cachestore flush

    jitendra.padhiyar (1/24/2013)

    I went to properties and set the Max memory to 14GB(Total RAM 16GB) which was before by default. And

    now its in normal online mode, and can access 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 24, 2013 at 4:45 am

    #1580473

  • RE: AOG INDEXING

    emile.milne (1/23/2013)

    Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.

    If I want to tweak the index for reports they...

    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, 2013 at 11:44 pm

    #1580362

  • RE: view default trace file in SQL profiler

    Much easier to use fn_trace_gettable and then filter within SQL. The profiler GUI's a pain to filter, sort and search in.

    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, 2013 at 11:36 pm

    #1580360

Viewing 15 posts - 14,641 through 14,655 (of 49,552 total)