Forum Replies Created

Viewing 15 posts - 31,966 through 31,980 (of 49,552 total)

  • RE: Problem Understanding the SP

    @@RowCount counts the number of rows affected by the last statemen, and a SET affects no rows.

    As far as I can see, you're never using the @AcceptCoaching variable anywhere. If...

    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

    July 6, 2010 at 5:33 am

    #1189023

  • RE: @@RowCount Value always 0

    Duplicate post. No replies please. Direct replies to http://www.sqlservercentral.com/Forums/Topic947805-1292-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

    July 6, 2010 at 5:27 am

    #1189020

  • RE: SQL 2005 Standard Trace Template

    balasach82 (7/6/2010)

    In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same...

    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

    July 6, 2010 at 5:18 am

    #1189017

  • RE: SQL 2005 Standard Trace Template

    Books Online?

    http://msdn.microsoft.com/en-us/library/ms175481%28SQL.90%29.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

    July 6, 2010 at 3:47 am

    #1188992

  • RE: Need clarification for Exam 70-448 SQL Server 2008,Business Intelligence Development and Maintenance

    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2

    http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448

    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

    July 6, 2010 at 1:48 am

    #1188963

  • RE: delete multiple rows

    Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    July 6, 2010 at 1:46 am

    #1188960

  • RE: Best Way to Accomplish a Purging Task

    Then for the orders at least, consider table partitioning. Partition on order date (or similar), decide on a suitable partition function, maybe one partition per year, then you can delete...

    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

    July 6, 2010 at 1:41 am

    #1188956

  • RE: Database creation

    There's a space in some of your file names.

    C: \Program Files\Microsoft SQL Server\MSSQL10. MSSQLSERVER\MSSQL\DATA

    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

    July 5, 2010 at 11:42 pm

    #1188932

  • RE: Best Way to Accomplish a Purging Task

    What version of SQL, what edition?

    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

    July 5, 2010 at 11:36 pm

    #1188930

  • RE: SSIS - Excel data checking prior to import

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic947698-148-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

    July 5, 2010 at 11:35 pm

    #1188929

  • RE: Identifying long running queries without using a trace

    Not with 100% accuracy. You can get close with the DMVs, but there will always be stuff that you miss. sys.dm_exec_query_stats is a reasonable place to start.

    Worth maybe pointing out...

    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

    July 5, 2010 at 11:34 pm

    #1188928

  • RE: moving data between files

    If it's in a separate filegroup, how did it help with space? Tables have to be explicitly created onto new filegroups, they won't just use that space.

    If you explicitly moved...

    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

    July 5, 2010 at 3:16 pm

    #1188895

  • RE: Conditionally Filtering An Integer Field

    Then I suggest you read it instead of scanning quickly, because the majority of the post is on the performance characteristics of queries using the (@Parameter IS NULL Or Column=@Parameter)...

    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

    July 5, 2010 at 3:10 pm

    #1188893

  • RE: Conditionally Filtering An Integer Field

    I take it you didn't read the link I gave 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

    July 5, 2010 at 2:54 pm

    #1188888

  • RE: Conditionally Filtering An Integer Field

    dec_obrien (7/5/2010)

    Hi,

    I didn't really want to use dynamic SQL because of the risk of SQl Injection (it's for an internet site). I have settled on this:

    (@Category...

    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

    July 5, 2010 at 10:41 am

    #1188838

Viewing 15 posts - 31,966 through 31,980 (of 49,552 total)