Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 6,035 total)

  • RE: "send me some of your code"

    WayneS (9/21/2015)


    pietlinden (9/21/2015)


    Eric,

    I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

    Maybe my problem is...

  • RE: "send me some of your code"

    Honestly, if this recruiter is approaching you from some website like LinkedIn or Indeed, then I wouldn't even bother responding. You especially don't want to give them anything like source...

  • RE: The Counter Offer - Part 2

    Dave62 (9/21/2015)


    Jack Corbett (9/21/2015)


    ... Even though I'm considered a permanent FTE by HR, I consider myself a contractor with benefits. They can get rid of me...

  • RE: Whatever happened to Database Table Refactoring?

    The database tables are what integrates line of business applications, backend processes, and business intelligence. To change the schema of the tables, you have to get everyone on the same...

  • RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/10/2015)


    ...

    If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB file containing 10...

  • RE: The Counter Offer - Part 2

    Regarding feelings of guilt about leaving, it's not necessarily directed toward the company but rather for co-workers who have become friends. As for the company itself, consider that the average...

  • RE: The Counter Offer - Part 2

    .. Staying or going isn’t about loyalty, it’s about what is best for you and you can measure that in any way you want – money, vacation, or anything else....

  • RE: Re-design messaging table SQL Server 2008

    Kristen-173977 (9/17/2015)


    Eric M Russell (9/17/2015)


    I'd also suggest turning on the table option 'large value types out of row'.

    What about if majority of messages are small enough to fit in-row?...

  • RE: Setting up a remote connection to a SQL Server from a local machine

    First, from the client PC with connectivity issue, confirm you can ping server name and IP.

  • RE: Re-design messaging table SQL Server 2008

    First, consider giving surrogate key identifiers a unique names, and a broadly used standard is to use <tablename>ID (ie: MessageID instead of just ID). I'd recommend making this...

  • RE: concatenate COLUMN NAME WITH VALUES

    You can leverage the INFORMATION_SCHEMA.COLUMNS system table, which contains one row for each table and column in the database, to build up a SQL select statement into a variable.

    To execute...

  • RE: Painful datetime conversion

    Sean Lange (9/17/2015)


    Eric M Russell (9/17/2015)


    Someone had mentioned that the date/time conversions can be expensive. Depending on what you're needing to do with the dates and times once they're converted,...

  • RE: Painful datetime conversion

    Someone had mentioned that the date/time conversions can be expensive. Depending on what you're needing to do with the dates and times once they're converted, it might make sense just...

  • RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    Whether a Jet based database will scale up to 1 TB depends on how exactly you are partitioning and the case usage of how the users are querying it. Jet...

  • RE: Can't release space of temdb

    Jeff Moden (9/4/2015)


    Alvin Ramard (9/4/2015)


    Jeff Moden (9/3/2015)


    sriponraj (9/3/2015)


    Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..

    So, if...

Viewing 15 posts - 3,436 through 3,450 (of 6,035 total)