Forum Replies Created

Viewing 15 posts - 22,186 through 22,200 (of 49,552 total)

  • RE: Query Plans and Filtered Indexes

    coronaride (11/15/2011)

    Damn. In my actual sproc, I am using >= and <=, not between's. I just used between in this test example because I figured it didn't make...

    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

    November 15, 2011 at 10:39 am

    #1408068

  • RE: Query Plans and Filtered Indexes

    Evil Kraig F (11/15/2011)

    If the query isn't sure it's going to land in the filter its a whole lot more likely to be outright ignored. A parameter can't ensure...

    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

    November 15, 2011 at 10:37 am

    #1408067

  • RE: Query Plans and Filtered Indexes

    coronaride (11/15/2011)

    declare @begin bigint

    declare @end bigint

    set @begin = 10000

    set @end = 15000

    select FK_SourceID, RecordType from PartyAddress where FK_PartyMain between @begin and @end

    That cannot possibly use 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

    November 15, 2011 at 10:37 am

    #1408066

  • RE: SPID

    The default trace does not contain last run SQL statements, DML or anything like that. It's a light-weight trace that stores DDL, some security info, DB and server config changes...

    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

    November 15, 2011 at 8:48 am

    #1407965

  • RE: Alternate Witness

    No. One witness.

    The point of a witness is to form quorum - where 2 out of the 3 machines involved agree as to what's happened. If there were 2 witnesses,...

    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

    November 15, 2011 at 7:26 am

    #1407871

  • RE: SPID

    There would have been a way before you killed it, but not now.

    With the connection still open, you could query sys.dm_exec_connections, cross apply sys.dm_exec_sql_text using the most_recent_sql_handle column. But 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

    November 15, 2011 at 7:23 am

    #1407869

  • RE: help me with the stored procedure

    You're going to have to give us a lot more than that...

    What do you have so far? Where specifically are you stuck?

    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

    November 15, 2011 at 7:19 am

    #1407865

  • RE: Table variable in stored proc - query plan reuse

    Tom Brown (11/15/2011)

    As I understand it - correct me if I'm wrong, its a very recent copy of the DB - but its read-only, so you can run queries...

    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

    November 15, 2011 at 7:18 am

    #1407864

  • RE: What is the use of Table Hint in SQL like NOLOCK, READUNCOMMITTED

    ashuthinks (11/15/2011)

    also why it cannot be specified for tables modified by insert, update, or delete operations???

    Because data modifications have to take exclusive locks to protect data integrity. Read uncommitted...

    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

    November 15, 2011 at 7:17 am

    #1407862

  • RE: Are the posted questions getting worse?

    Guys, I know that 'It Depends' and the various forms are lovely answers, but can we please be careful about using it in cases where the answer doesn't depend on...

    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

    November 15, 2011 at 6:03 am

    #1407793

  • RE: Migrating oracledata to sql server

    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/Topic1205779-146-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

    November 15, 2011 at 6:00 am

    #1407788

  • RE: Table variable in stored proc - query plan reuse

    Don't need the code. The recompiles is not an 'it depends' answer. Table Variables do not cause recompiles.

    As for monitoring recompiles:

    http://sqlinthewild.co.za/index.php/2010/11/18/recompiles/

    http://sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/

    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

    November 15, 2011 at 5:55 am

    #1407779

  • RE: Help with SQL execution speed

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    November 15, 2011 at 5:52 am

    #1407778

  • RE: SQL Server 2008 vs R2 - Processors - cpu_count

    Brandie Tarvin (11/15/2011)

    1) How many CPUs is each box licensed for? I'm w.a.g.ging here, but I'm wondering if you're not seeing all CPUs because the license isn't set up correctly.

    Licensing...

    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

    November 15, 2011 at 5:46 am

    #1407775

  • RE: Table variable in stored proc - query plan reuse

    Tom Brown (11/15/2011)

    If I have table variables in a stored procedure, I'm sure I've heard somewhere that the query plan will be recompiled every time the procedure is called....

    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

    November 15, 2011 at 5:43 am

    #1407770

Viewing 15 posts - 22,186 through 22,200 (of 49,552 total)