Forum Replies Created

Viewing 15 posts - 13,231 through 13,245 (of 49,552 total)

  • RE: filtere index benefit

    It might be. Can you post the query, the table definition and the index that you tried?

    Why must it be a filtered index?

    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

    May 7, 2013 at 11:32 pm

    #1613196

  • RE: SQL 2008 - File Group change

    balasach82 (5/7/2013)

    3. If the deleting filegroup is set as DEFAULT, then how to delete it and what would be the premove steps

    Delete all the objects in that filegroup. Delete 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

    May 7, 2013 at 8:59 am

    #1613037

  • RE: SQL 2008 - File Group change

    You can't make a different filegroup primary, the primary filegroup is the first one in the database and the one that contains the primary file. You can't delete the primary...

    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

    May 7, 2013 at 8:31 am

    #1613019

  • RE: SQL Startup options - 3609

    See https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-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

    May 7, 2013 at 8:07 am

    #1612999

  • RE: do I need locking or what's the best way to do this ?

    Have you considered using MERGE rather than an insert/update pair?

    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

    May 7, 2013 at 12:24 am

    #1612862

  • RE: Certification Practice Exams

    I'd be a little more concerned about this more than the exam quality http://www.techexams.net/forums/mcdst/11848-passed-70-271-easy.html, plus read through their FAQ, there's mention of 'scouring the web for questions' rather than then...

    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

    May 7, 2013 at 12:16 am

    #1612861

  • RE: Single User Mode

    patrickmcginnis59 10839 (5/6/2013)

    The one exception I seem to notice that if in SSMS I set my DEFAULT database (as speced in SSMS properties for my "login") to the same 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

    May 6, 2013 at 4:05 pm

    #1612804

  • RE: Single User Mode

    Welsh Corgi (5/6/2013)

    If someone has the sole connection I would not be able to kill their session?

    You would be able to.

    If someone has [grabbed the sole connection], identify who,...

    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

    May 6, 2013 at 4:02 pm

    #1612802

  • RE: Concept of Session killing by Sql server.

    suneet.mlvy (5/6/2013)

    Thanks for the response, now I understand the timeout concept, but can u explain me how sql server kill sleeped session is there any setting available to kill them...

    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

    May 6, 2013 at 6:45 am

    #1612610

  • RE: Concept of Session killing by Sql server.

    Timeout is a client concept, not one the server deals with. It's the client that decides that a query has been running too long and the client that tells SQL...

    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

    May 6, 2013 at 4:36 am

    #1612567

  • RE: Use MAX in insert query

    masoudk1990 (5/6/2013)

    GilaMonster (5/6/2013)

    INSERT INTO TableName (ID,Value)

    SELECT coalesce(MAX(ID),0) + 1, 'something' FROM TableName;

    Thank you, hence this statement is not allowed:

    INSERT INTO TableName (Value1,value2)

    values(

    select value1 from table1,

    select value2 from table2

    )

    Instead you must...

    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

    May 6, 2013 at 3:49 am

    #1612561

  • RE: Use MAX in insert query

    INSERT INTO TableName (ID,Value)

    SELECT coalesce(MAX(ID),0) + 1, 'something' FROM TableName;

    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

    May 6, 2013 at 3:22 am

    #1612551

  • RE: Rebuild Indexes

    If you have Enterprise Edition, you can rebuild the indexes online, they'll probably take longer but don't hold long-duration locks.

    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

    May 6, 2013 at 2:08 am

    #1612543

  • RE: Speed issue with SQL Server 2008 compared to SQL 2000

    200 executions of a query taking 6 seconds means that each execution takes 30ms to execute and return results, ignoring the parse and compile time (and SSMS is often slow...

    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

    May 6, 2013 at 1:57 am

    #1612541

  • RE: SSMS Stored procedure help

    Red Gate's SQL Prompt. 30 day, full-featured trial.

    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

    May 5, 2013 at 4:55 pm

    #1612489

Viewing 15 posts - 13,231 through 13,245 (of 49,552 total)