Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 3,556 total)

  • RE: Dynamic SQL or Stored Procedure

    As far as optional arguments/parameters is concerned, if there are a large number of them then I switch to using ORs simply because writing a SQL stored procedure that produces...

  • RE: Dynamic SQL or Stored Procedure

    I would suggest that this is a documentation issue and development practices issue.

    Unfortunately, once an organisation grows beyond a certain point formal documentation and methodologies become a necessity rather than...

  • RE: Junk Mail

    Sorry, the forum interpretted my HTML entities m etc

  • RE: Junk Mail

    Yes you can spider dynamic pages. We use Thunderstone's Webinator as a search engine with a database driven content management system.

    One way of blocking the harvesting of e-mail addresses...

  • RE: Dynamic SQL or Stored Procedure

    You really get a feel for the performance downside of dynamic SQL if you develop web applications.

    In most cases the difference in cost between dynamic and static SQL is very...

  • RE: EXCEPTION_ACCESS_VIOLATION

    As I am running the personnal edition of SQL Server on my laptop I have a sneaking suspicion that the error is caused by a conflict between other software running...

  • RE: Worst Practives - Blank Passwords

    In my environment network administration is a separate function to SQL Server administration so I tend to use NT security and let the network administrator worry about resetting passwords.

    The network...

  • RE: Avoiding Deadlocks

    Chances are there is something that needs to do a exclusive lock on the tables referenced by vw_CallList3 and someone or something has accessed your SQL statement.

    Make a list of...

  • RE: Rendering images from a database

    One of the many CMS's is called OBTREE. There are no physical files at all.

    Absolutely everything is stored within a database and served out to pages via...

  • RE: How Do You Review a Product?

    Does anyone on this site work for a vendor?

    If so, could you chip into this discussion?

  • RE: How Do You Review a Product?

    Someone got caught on Amazon hyping their own book so the skewing issue is real.

    I think that user reviews have to be

    • Members only
    • Prepared to say who they...
  • RE: How Do You Review a Product?

    Steve,

    How about posting a "to be reviewed" notice on a product then those of us who use the product can submit our experiences.

    Keep it as a submissions only i.e. only...

  • RE: How To Copy DB Between Servers

    As an aside, I worked through the MS XML SQL Server programming book and having got through lots of interesting and useful stuff on updategrams etc the book finally said...

  • RE: We Studied, We Passed, Was It Worth It?

    Andy,

    From your experience what are the advantages of dot.net over the previous MS offerings.

    We are having a struggle to get dot.net into our company and at this stage we're at...

  • RE: How to Execute Views from VB

    I tend to use the DataEnvironment object to execute any views, stored procedures and commands within my app.

    Intellisense lets you reference your database objects, and in the case of views...

Viewing 15 posts - 3,421 through 3,435 (of 3,556 total)