Forum Replies Created

Viewing 15 posts - 241 through 255 (of 321 total)

  • RE: Complete Newbee Advice Required

    SQL Server 2000 Client Tools are still somewhat useful even for SQL 2005 data access and management. Some of us find the SQL Server Query Analyzer editor to be a...

  • RE: SQL Server Express DAC

    My subscription was sent at 3:58 A.M. this morning. I'm guessing that is Rocky Mountain Time. It's easy to be forgiving given the implications of that. Besides - I've begun...

  • RE: temp table not dropped

    You should be aware that there are applications that create "permanent" tables in the tempdb (no # or ##). They are "permanent" until the next time the service is restarted....

  • RE: Table Level Access

    Timothy (4/23/2008)


    Tom Garth (4/23/2008)I haven't done any coding using LINQ. I've read through sample code and it looks easy enough, but what about maintainability?

    LINQ can be no more or less...

  • RE: Records Accessing Problem

    If you believe that there are uncommited transactions causing the problem, then you will have to change something.

    Is your application the only application creating the new BoardNos? Are you using...

  • RE: Table Level Access

    A close friend of mine was at a conference in Vegas recently, and described a demonstration put on by Microsoft that proved LINQ coding performed faster than stored procedure access......

  • RE: File Handling A Different Way

    Samuel Clough (4/22/2008)


    I'm surprised by this article. For one thing, as already stated, this stored proc should never be enabled. Secondly, why use a database to do file...

  • RE: SQL Server 2005 Logins

    Tom Garth (4/11/2008)


    K. Brian Kelley (4/11/2008)


    Tom Garth (4/11/2008)


    Great article Brian!

    An application that I wrote has an interface for the app admin to create and manage users, and role memberships. It...

  • RE: total time difference between more than two dates

    rbarryyoung (4/13/2008)


    Jeff: I think that's an article.

    It is an article, and very well written. No editing required. Nice work Jeff.

  • RE: SQL Server 2005 Logins

    K. Brian Kelley (4/11/2008)


    Tom Garth (4/11/2008)


    Great article Brian!

    An application that I wrote has an interface for the app admin to create and manage users, and role memberships. It has been...

  • RE: SQL Server 2005 Logins

    Great article Brian!

    An application that I wrote has an interface for the app admin to create and manage users, and role memberships. It has been running on SQL 2000, but...

  • RE: Storage Size

    If I remove the SELECT CASE, then it works, but is also still incorrect. Further testing reveals that SELECT CASE is not allowed as part of a computed column.

    Why...

  • RE: Shortcut to avoid typing something

    SELECT * FROM

    Lets see. That took less than 2 seconds. CTRL>SHIFT>S ? Maybe a little quicker.

    What I need is something to automatically correct the dyslexic version that I frequently...

  • RE: Storage Size

    Like others, I saw the nvarchar problem but went ahead anyway. The one that threw me was the calculated column not using storage. It's a no-brainer, but mine was on...

  • RE: Query

    Steve,

    So you have anything to add before you're DRAWN AND QUARTERED, HUNG FROM THE YARDARM, TARRED AND FEATHERED, and BURNED AT THE STAKE?:hehe:

Viewing 15 posts - 241 through 255 (of 321 total)