Forum Replies Created

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

  • RE: Coding More Carefully

    Thanks to code completion, I don't think developers today really spend a significant amount of time correcting syntax errors or invalid object references.

    I think the old timers back in...

    January 12, 2012 at 11:58 am

    #1432824

  • RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

    Querying the INFORMATION_SCHEMA views can return columns with definitions that matche search criteria, and then you can also use a similar query to dynamically build other SQL queries against those...

    January 11, 2012 at 8:10 am

    #1431816

  • RE: How we dealocate the memory of a row

    chaudharydpk0 (1/10/2012)

    How we dealocate the memory of a row in a table in sql 2008 R2. please show the query if exist.

    OK, I'll take a stab at interpreting your request...

    January 11, 2012 at 7:39 am

    #1431786

  • RE: Referencing Remote Data

    The thing about querying remote tables, especially when joining remote tables with local tables, is that the performance impact of the SQL coding tequnique is critical. I'm not sure that...

    January 10, 2012 at 7:41 am

    #1431157

  • 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

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