Forum Replies Created

Viewing 15 posts - 13,471 through 13,485 (of 49,552 total)

  • RE: so many indexes indexes

    Zeal-DBA (4/15/2013)

    what if i create so many indexes in a database, on each and every table small or large...?

    You slow down data modifications, increase the size of the database,...

    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

    April 15, 2013 at 11:52 pm

    #1606697

  • RE: New features in sql server

    Did you look online for that?

    http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.100%29.aspx (SQL 2008)

    http://msdn.microsoft.com/en-us/library/bb500435.aspx (SQL 2012)

    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

    April 15, 2013 at 11:45 pm

    #1606692

  • RE: How to check performance issue

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    April 15, 2013 at 11:42 pm

    #1606690

  • RE: Small doubt

    New persopn (4/15/2013)

    1) what is the difference between current execution plan and actual execution plan

    Depends what you mean by 'current execution plan', as that's not a common term

    2) on which...

    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

    April 15, 2013 at 11:42 pm

    #1606689

  • RE: No performance gain on queries on different servers with considerable hardware change

    To expand on that, I've seen a database's performance dramatically decrease after an upgrade from a single processor server to an 8-core with lots more memory. The code was riddled...

    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

    April 15, 2013 at 11:41 pm

    #1606688

  • RE: No performance gain on queries on different servers with considerable hardware change

    Could simply be that the hardware wasn't the bottleneck in the query performance.

    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

    April 15, 2013 at 2:28 pm

    #1606617

  • RE: Procedure Execution Plans

    IgorMi (4/15/2013)

    So, what is the difference between a query with missing index on a column in its WHERE clause executed as exec sp_prepexec @sql_stmt or exec sp_executesql @sql_stmt, and 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

    April 15, 2013 at 2:20 pm

    #1606616

  • RE: Procedure Execution Plans

    You would be correct, option 2 is prone to bad plans

    http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

    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

    April 15, 2013 at 1:36 pm

    #1606606

  • RE: "..table "ItemNum" cannot be reorganized because page level locking is disabled"

    Please note: 7 year old thread

    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

    April 15, 2013 at 5:03 am

    #1606420

  • RE: Need Link

    What link for Visual Studio 2005? MS site? Something else?

    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

    April 15, 2013 at 4:38 am

    #1606413

  • RE: DBCC CHECKDB Failing

    The windows logs showing a loss of connectivity to the drives certainly indicates some problem with the storage, specifically that the drives went away temporarily. If SQL's system databases were...

    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

    April 15, 2013 at 4:32 am

    #1606411

  • RE: multiple instances of sqlserver different dns alias

    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/Topic1442104-1550-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

    April 15, 2013 at 3:54 am

    #1606403

  • RE: DBCC CHECKDB Failing

    Right, that's a good hint.

    SQL's system databases are on one of those drives? If so, with connectivity lost to a drive, SQL will fail immediately, no way around that.

    Can...

    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

    April 15, 2013 at 3:53 am

    #1606402

  • RE: DBCC CHECKDB Failing

    Windows event logs?

    Without some log of something it's going to be near-impossible to even tell what happened, let alone 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

    April 15, 2013 at 3:32 am

    #1606393

  • RE: Help using like operator

    pankaj2.kumar (4/15/2013)

    This query can also be answered without using escape

    The query is shown below:

    select * from accounts where accname like '%OLD%'

    Except that would also match entries such as 'Jet...

    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

    April 15, 2013 at 3:22 am

    #1606387

Viewing 15 posts - 13,471 through 13,485 (of 49,552 total)