Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 5,103 total)

  • RE: Deletes take forever

    What is the Ratio RowsStaying/TotalRows ?

     

  • RE: record locking in n-tier applications

    The First questions are:

    Are you expecting High Volume?

    Are you expecting a lot of users concurrently?

    Do you have appropriate hardware/budget?

    etc...

    About the tools

    Some People use ApexSQL, some TierDeveloper, some Codesmith, other simply use...

  • RE: record locking in n-tier applications

    Markus,

    1. By FAR when the transactional tables are large (+10 millions) and the number of users is large the Lockings are reduced DRAMATICALLY and it wont contend with people trying to...

  • RE: General Performance/Design Question

    Beware of Large composite keys, that's why surrogates exists (the speed of joins will be very noticeable as the table grow large). 

    Like I said there is no ABSOLUTE in design it will...

  • RE: record locking in n-tier applications

    The method that Steve just described is the so-called Flag method. It works when the table involved is not large  or the amount of users (concurrent) is not big. When the...

  • RE: Functions and Procedures in Hierarchy Order?

    This is what happens when you try to execute an undocummented sp without reading (digging ) in its code (if at all possible) to...

  • RE: using variables as tablenames?

    Ganesh,

    your output is missing objectName because in SQL permissions are assigned to objects within the database, not to the database itself. At the Database level you allow or deny access...

  • RE: columns unequal? (column might be null)

    Andreas the code that you posted is exactly what is needed for differences on nullable columns you may skip the is null part for non nullable.

    Usually the fastest way to...

  • RE: Trapping Connection Errors

    Greg,

    AFAIR I was in a similar situation and I ended doing it on a job so that is asychronous and independent of your code and you could check for the Success or...

  • RE: distributed query inside of a trigger

    do you really need immediate update of the central system?

    if not, Merge replication, which by the way is supported by MSDE, is the tool of option but if the...

  • RE: Gathering Year-to-Date Info

    Beryl,

    You need to be more specific on what tables are involved?, what the result should look like?, what are the data types involved? and if possible put some DDL also....

  • RE: distributed query inside of a trigger

    To start, let me make clear that I follow mlsmith advice and that, is the RIGHT way to do it but for the fun of it

    I beleive that the...

  • RE: ADO can get a recordset from a Stored Procedure, Can TSQL?

    Are you just trying to implement the third ooyion I just mentioned ?

  • RE: Creating view thru stored proc ;-)

    Yes it is possible.

    For some system sp you will have to feed the query with some tricks like: Select NULL, or SET FMTONLY ON, etc  but if your sp is...

  • RE: using variables as tablenames?

    Ganesh,

    I will be very easy to translate the code to dynamic SQL but the apparent ease of manintenace can also be interpreted as too tightly coupled. yes it is true...

Viewing 15 posts - 4,321 through 4,335 (of 5,103 total)