Forum Replies Created

Viewing 15 posts - 646 through 660 (of 813 total)

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Honestly, I think the #1 takeaway from this thread is:

    Name functions with accuracy and specificity!

    Microsoft's "IsNumeric" is neither specific, nor accurate (it does _not_ test for strings that must match...

  • RE: Licensing Questions

    Kwisatz78 (11/24/2010)


    Ok I have got myself in a tiz about device CALs now!!

    How does a web front end not qualify for a device CAL when all external users will be...

  • RE: Restart SQL Server to create space on disk

    Keith Langmead (11/30/2010)


    By default the tempdb is set as Simple recovery model, so I doubt the tempdb transaction log file would be the cause.

    Simple recovery simply means the tempdb...

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    wayne-862477 (12/1/2010)


    Jeff,

    ...Realistically the best thing to do would be to create validation by type (IsInt, IsDecimal etc) so you also don't run into overflow problems and things like that.

    +1; most...

  • RE: How to interpret results of SQLIO used to benchmark the disk subsystem.

    A) Yes, get a professional in. You'll learn a lot, and have a better setup.

    B) For a simplified system, build yourself a table with rather less factors: Change the...

  • RE: more cores vs higher CPU speed

    dan.nutley (8/12/2010)


    I don't think it matters very much...the CPU (assuming you've got any Xeon made within the last 5 years) is rarely the bottleneck on such systems.

    I agreed with you.......

  • RE: How to Slice Up LUNs for SQL Server

    Shared disk may be cheaper, and is absolutely simpler on the SAN side.

    Shared disk with non-SQL apps, however, means that you cannot guarantee SLA's on query performance; if some other...

  • RE: Planning for Failure

    When it doubt about a system level change, make a drive image first. I've done this many times, and every once in awhile it's a major lifesaver (we applied...

  • RE: Indexes during nightly dataloads - tips?

    Time it (and use SQL Server Profiler SQL:BatchCompleted statistics on Reads, Writes, CPU, Duration if you can) several ways:

    1) The way it is now

    2) Dropping/recreating indexes (watch out for ones...

  • RE: migrating from sql 2000 to sql 2008

    I regularly restore 100-1000GB SQL Server 2000 database backups to SQL Server 2008 R2 servers without issues; whether the stored procedures all still work, I don't know, however the data...

  • RE: The Design Investment

    I would note that even for developers with a Computer Science degree, while relational theory may be covered (often optionally), actually working with real data is usually not. In...

  • RE: Taking unused space out of DB files (and DB)

    Speeding transfer across network by transferring the compressed version:

    Use any compression tool in its fastest mode that:

    A) writes the initial compressed file directly to the target directory

    and

    ...

  • RE: What Do We Need in SQL Server?

    And a Bulk Export to match Bulk Import from straight SQL, using a format file.

    More flexible format files would be nice, too.

  • RE: What Do We Need in SQL Server?

    Temporal support for periods and for explicit intervals, with sufficient index capability so as to be able to include periods (start date, end date) in a table, put an index...

  • RE: D: drive is full and transaction log is full

    For Gila's and everyone else's bag of tricks:

    To add space to a drive that's out, there are a variety of options.

    Temporary:

    A) ENTIRELY SAFE: Clear out IE's and any other browser...

Viewing 15 posts - 646 through 660 (of 813 total)