Forum Replies Created

Viewing 15 posts - 5,311 through 5,325 (of 6,022 total)

  • RE: Transaction Log file suspicious high

    islas.tonatiuh (12/22/2011)

    I ran the last query without any results 🙁 still not idea about what is causing the size of transaction log backup.

    You're saying the query against default trace returned...

    December 23, 2011 at 8:36 am

    #1425203

  • RE: Transaction Log file suspicious high

    Check your server's maintenance plans to see what may have been scheduled.

    Also, if there was something like an index rebuild, then a query of the default trace may reveal...

    December 22, 2011 at 11:48 am

    #1424902

  • RE: Transaction Log file suspicious high

    islas.tonatiuh (12/22/2011)

    One more question Sir, what's the interpretation for the operation and context columns retrieved from the query?

    I ran it but how can i use those results, because i saw:

    e.g.

    dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_MIX

    dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_TREE

    dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_GAM

    dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_IAM

    sys.sysallocunits.clustLOP_COUNT_DELTALCX_CLUSTERED

    The...

    December 22, 2011 at 9:44 am

    #1424860

  • RE: Transaction Log file suspicious high

    David Moutray (12/22/2011)

    Very cool query, Mr. Russell. I did not know you could do that. The only problem in applying it to this particular problem is that the...

    December 22, 2011 at 9:29 am

    #1424854

  • RE: Transaction Log file suspicious high

    islas.tonatiuh (12/22/2011)

    I was checking jobs but nothing comes up, any idea how can i know if indexes were rebuild or activity related with high transactional activity.

    Thanks

    This query will summarize what...

    December 22, 2011 at 9:07 am

    #1424842

  • RE: GOTO and T-SQL

    In addition to making the code less structured and less readable, another problem (at least for those who choose to use it) with T-SQL's implementation of GOTO is that it's...

    December 22, 2011 at 7:48 am

    #1424799

  • RE: Pride and Security

    Elliott Whitlow (12/21/2011)

    Jeff Moden (12/20/2011)

    Absolutely wonderful article, Steve.

    Concerning the question in the article...

    If you had more pride in your employer, wouldn't you be a little more careful in caring for...

    December 21, 2011 at 9:34 am

    #1424335

  • RE: Pride and Security

    I believe all organizations should get to know the people who handle their sensitive data and make sure they are happy. If they are not worth paying well or knowing,...

    December 20, 2011 at 7:01 am

    #1423621

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    sqldba_newbie (12/15/2011)

    i tried 'Incorrect syntax near the keyword 'option'.'.Were you able to parse it?

    It seems in my previous example, I misplaced the option (hash group). Below are two versions of...

    December 15, 2011 at 11:15 am

    #1422123

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    sqldba_newbie (12/15/2011)

    Eric M Russell (12/15/2011)

    sqldba_newbie (12/14/2011)

    sqldba_newbie (12/14/2011)

    Eric M Russell (12/14/2011)

    sqldba_newbie (12/12/2011)

    I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on...

    December 15, 2011 at 9:15 am

    #1422036

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    sqldba_newbie (12/14/2011)

    sqldba_newbie (12/14/2011)

    Eric M Russell (12/14/2011)

    sqldba_newbie (12/12/2011)

    I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea...

    December 15, 2011 at 8:17 am

    #1421984

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    sqldba_newbie (12/12/2011)

    I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea what could make it so...

    December 14, 2011 at 1:27 pm

    #1421581

  • RE: Propose this to your boss

    As a datamart developer and data anayst, I often times work directly with end users, who are managers and department heads. Therefore, if I think of a bright idea, I'll...

    December 14, 2011 at 7:38 am

    #1421299

  • RE: Select from stored procedure

    I think more explanation is needed about what your script is demonstrating. Is your specific intent to demonstrate how to select from a "remote" stored procedure?

    When I want to...

    December 14, 2011 at 7:27 am

    #1421286

  • RE: Encryption Works

    FDE isn't needed or required on the server, but definately for laptops belonging to corporate IT people. It's inevitable that sensitive information will end up in local email storage, Excel...

    December 13, 2011 at 10:18 am

    #1420736

Viewing 15 posts - 5,311 through 5,325 (of 6,022 total)