Forum Replies Created

Viewing 15 posts - 106 through 120 (of 152 total)

  • RE: Blocking lock in ReportServer database

    by the way, for those who really want to understand how "transaction processing" and "isolation level" works, one should read Thomas Kyte's book - only the chapter about transaction processing.

  • RE: Blocking lock in ReportServer database

    PG, Thank you for your clarification of your own statement. >" I enabled the read committed snapshot isolation level for ".

    READ UNCOMMITTED

    Specifies that statements can read rows that have been...

  • RE: Blocking lock in ReportServer database

    "read committed snapshot"

    You can only set one isolation level, that statement is incorrect, where do you do that?

  • RE: Linked Server Troubles

    Pieter, the URL is incorrect.

  • RE: Predict output

    The original choices do not contain correct answers. Please verify the Q/A before it is published.

    Imagine you take a GRE special topic test that involes world wide thousands of thousands...

  • RE: Help Others, Help Yourself

    That is exactly the message we need in the U. S. of A. Not just to technical people, also to the entire company from CEO to clerk, who work with...

  • RE: Find Foreign Key Tables

    That is correct. This simple tutorial script solves the problem I had and is a sample for you to refactor and write whatever you want.

    CirquedeSQLeil is going to write the...

  • RE: Run SSIS packages from remote client with stored procedure

    Nice write up. I agree with nlarge. The application code should be in the application using C#/ASP .Net. It would be easier for future debug, maintenance, integration from architecture point...

  • RE: Automated SQL Job to Backup Database(s)

    Mine actually created jobs in English version. You have to be careful with that hostname and sharefolder. I can it is useful if you start out many db servers you...

  • RE: Dissecting SQL Server Execution Plans

    Excellent book. I actually used it for over a year to solve many performance problems on our prodution databases. I have actually gone beyond the book's level to solve...

  • RE: Synchronize a stored procedure between two servers

    Interesting idea to copy objects. However, according to SOX, those who have full access to production and development are distinct two groups of people. You cannot push DEV object into...

  • RE: A True SQL OS

    Too many times in history, the best technology solution won't sell. It is market economy. (I don't need to list historical examples).

    In this particular case, I don't know if anybody...

  • RE: Defragmenting and rebuilding indexes

    You should add row-count in the whereclause because defrag on small table will not help much.

  • RE: decrypt sql server 2005 sp

    1) Because SQL Server Express is more lightweight than Developer Edition.

    2) Because some products, like Outlook with the business extensions automatically instally SQL Server Express. This includes Visual Studio, though...

  • RE: SQL Server 2005 - Backup, Integrity Check and Index Optimization

    Awesome. Two thumbs up for you, Ola. Finally someone post it. I have been using three scripts on agentjob I wrote to do these three things. Better late than never...

Viewing 15 posts - 106 through 120 (of 152 total)