Forum Replies Created

Viewing 15 posts - 11,191 through 11,205 (of 49,552 total)

  • RE: How to Identify name starting with a specific letter without using like operator?

    sharmili.net (10/25/2013)

    Hi All,

    How to Identify name starting with a specific letter without using like operator?

    Please help me out.

    Why? That's what the LIKE operator is there for, refusing to use 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

    October 25, 2013 at 6:53 am

    #1661610

  • RE: SQL Server takes 95% of my processor

    Tune the queries, optimise the indexes or add more hardware.

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

    https://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

    October 25, 2013 at 3:31 am

    #1661558

  • RE: column values don't get updated

    Trigger on the 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

    October 24, 2013 at 1:32 pm

    #1661445

  • RE: Transaction Activity

    Extended events session or server-side trace.

    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

    October 24, 2013 at 1:31 pm

    #1661444

  • RE: compatibility mode

    The only thing compatibility mode affects is how the parser and query processor handle certain T-SQL constructs. It doesn't change the database in any way

    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

    October 24, 2013 at 1:31 pm

    #1661443

  • RE: PLease suggest index for this table

    Smash, it would be really useful if we could see the execution plan of that query, plus any other queries that run frequently against the table. Since we have little...

    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

    October 24, 2013 at 8:24 am

    #1661311

  • RE: PLease suggest index for this table

    T.Ashish (10/24/2013)

    covering index will be a better idea but I think covering index will be limited to this query only.

    So you recommend an index on two columns but say that...

    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

    October 24, 2013 at 8:21 am

    #1661309

  • RE: Begin Transaction - End Transaction in a select statement

    T.Ashish (10/24/2013)

    I am of the belief that they serve no purpose in a select statement and are totally unnecessary. Agree? Disagree?

    Thanks,

    Agree.

    Incorrect. See my and Keith's posts above.

    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

    October 24, 2013 at 8:19 am

    #1661307

  • RE: SQL Server 2005 - 2012 (TEMPDB Issue)

    Bar a few odd memory leaks I've seen in the past, there's not much that would have me regularly restarting SQL at all.

    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

    October 24, 2013 at 8:15 am

    #1661300

  • RE: Log space issue

    How often were you monitoring?

    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

    October 24, 2013 at 7:33 am

    #1661276

  • RE: PLease suggest index for this table

    T.Ashish (10/24/2013)

    create your index on

    yearno

    periodid

    Sure that's the best index? A non-covering index that only supports the where clause.

    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

    October 24, 2013 at 7:28 am

    #1661274

  • RE: Finding out Editon of the SQL Set up

    Most installation sets contain all editions. The edition that installs depends on the key that you use during set up. Some installations have the key embedded. To see which you...

    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

    October 24, 2013 at 7:23 am

    #1661272

  • RE: How to remove Transaction Log from SQL Server 2008 R2

    Sanjay Thakur-488205 (10/23/2013)

    Kindly advice the same How to remove/ Delete Transaction Log from SQL Server 2008 R2. as previously we are using SQL Server 2000 Detach database and remove log...

    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

    October 24, 2013 at 7:14 am

    #1661265

  • RE: SQL Server 2005 - 2012 (TEMPDB Issue)

    Could you be more specific? Handling what about TempDB?

    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

    October 24, 2013 at 7:13 am

    #1661264

  • RE: SQL Server is NOT taking allocated Max Memory

    It's not memory pressure in SQL Server that you have (well, you know you have that already). Something else, outside of SQL, is apparently taking large amounts of memory, so...

    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

    October 23, 2013 at 2:41 pm

    #1661100

Viewing 15 posts - 11,191 through 11,205 (of 49,552 total)