Forum Replies Created

Viewing 15 posts - 43,351 through 43,365 (of 49,552 total)

  • RE: Re: Multiple Stored Procedure Design

    1976 (10/31/2008)

    Hi,

    I plan to use dynamic SQL to create the SQL statement and sp_executesql for execution.

    If your parameters are optional, do not create dynamic sql, but construct WHERE clause this...

    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 4, 2008 at 7:38 am

    #893621

  • RE: Participation

    Shaun McGuile (11/4/2008)

    There are people who post or have forum names which maintain their anonimity, are they acting under 'false' pretenses? 😀

    Depends. If they're pretending to be someone they're not...

    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 4, 2008 at 7:35 am

    #893618

  • RE: GUID datatype in SQL Server 2000

    Nandy (11/4/2008)

    However I just have small doubt, every time I have to use default value or any other way where I can insert the values to GUID field in 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

    November 4, 2008 at 7:33 am

    #893614

  • RE: transaction logs

    Lynn Pettis (11/4/2008)

    Don't simply truncate the transaction log. You will break your log chain, and won't be able to do a restore to a point in time. Also,...

    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 4, 2008 at 7:28 am

    #893611

  • RE: WITH(NOLOCK) vs WITH(READPAST)

    SQL Server mostly uses unordered clustered index scans when NOLOCK is specified,

    this can cause duplicate records to be returned when page splits occur while your query is scanning the index.

    Using...

    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 4, 2008 at 6:54 am

    #893586

  • RE: Why can you use"-+-+-+" in tsql?

    Grant Fritchey (11/3/2008)

    I don't understand the question?

    All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is...

    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 4, 2008 at 6:42 am

    #893578

  • RE: Identity column value should not be increased if there's pbm in insertion of record.

    nairsanthu1977 (11/4/2008)

    Thank you.....

    So there's no way to achieve this..rite.?

    Not unless you want to do your own form of auto-increment column.

    Why are the values of the identity column important?

    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 4, 2008 at 1:14 am

    #893464

  • RE: Transaction Rollback

    clive (11/3/2008)

    1. Lets say the transaction normally runs for 8 hrs, how long will the rollback take.

    Probably at least 8 hours. Depends if those 8 hours were all doing processing...

    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 4, 2008 at 1:05 am

    #893463

  • RE: Page lock, dead lock

    Is the deadlock happening frequently? If so, please enable traceflag 1222 (DBCC TRACEON (1222,-1) ). That will write a very detailed deadlock graph into the error log. Please post 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

    November 4, 2008 at 1:01 am

    #893460

  • RE: Keep index online, stop maintenance

    Tony (11/3/2008)

    So, can I disable ongoing maintenance on the non-clustered/non-unique indexes, keeping those indexes online? Those indexes would continue to be used by the production system to access 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

    November 4, 2008 at 12:58 am

    #893459

  • RE: SQL SERVER 2008 DBA exams

    Have a look at these links. They should give you everything you need to study for and write the exams.

    For SQL 2008:

    http://www.microsoft.com/learning/mcp/mcts/sql/2008/default.mspx

    http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

    For SQL 2005:

    http://www.microsoft.com/learning/mcp/mcts/sql/

    http://www.microsoft.com/learning/mcp/mcitp/dbadmin/

    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 4, 2008 at 12:42 am

    #893447

  • RE: Tune Query

    Mike Levan (11/3/2008)

    we have db's with same schema in the same instance, and this query is ran in all the db's and they run very gud except this db. what...

    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 4, 2008 at 12:38 am

    #893445

  • RE: transaction logs

    terryj30 (11/4/2008)

    try this

    1) dbcc opentran(dbname) - this will show the oldest open transaction

    2) Kill this process

    3) backup log dbname with no_log

    4) use dbname

    5) dbcc...

    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 4, 2008 at 12:36 am

    #893444

  • RE: Valid and Invalid(unparsable) XML

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic595934-338-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 3, 2008 at 1:34 pm

    #893244

  • RE: Exercise to practise SQL

    J (11/3/2008)

    This is getting ridiculous.

    An author proposes one of his books and someone expects to have it for free ?

    And expects it to be sent to him at the author's...

    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 3, 2008 at 1:31 pm

    #893242

Viewing 15 posts - 43,351 through 43,365 (of 49,552 total)