Forum Replies Created

Viewing 15 posts - 91 through 105 (of 478 total)

  • RE: Reading data from an XML File

    Looked at SQLXML functionality? bulk upload etc.. I may be missing the point here ..

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"

  • RE: Log Shipping - Full Backups?

    Hi there

    Saftey more than anything, I would continue doing it to ensure maximum flexibility if, for whatever reason, you do need the full again. How big is the DB?....

  • RE: Raid performance

    Hi there

    Are you measuring read and write queues seperately? make sure you do for starters. After that, you need to know the total disks in the array as a...

  • RE: Should you buy a SAN?

    Steve

    Did you do the install? any stats re the SAN? I have the same concerns as yourself.

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"

  • RE: move sql server 2000 to SAN

    Hi all

    A couple of things are missing in this posts that I would like comments on...

    a) IBM Shark - Supports only RAID-5 or can it do RAID-10? are people...

  • RE: RegSVC.EXE Cluster Server

    Hi there

    Process File: regsvc or regsvc.exe

    Process Name: Remote Registry Service

    Description: The Remote Registry Service allows Access to the Windows Registry from Remote Computers

    Common Errors: N/A

    System Process: Yes

    This is only...

  • RE: SQL vs XML

    Hi there

    Its is raw speed your after, xml in files and stylesheeting the results is very quick. The DB option, even with xml coming from the db and stylesheeting...

  • RE: IN LOAD state for a backup of a database

    Hi there

    This is a pain in your you know what message.

    Try this: http://support.microsoft.com/default.aspx?scid=kb;en-us;819264

    the restore post re NORECOVERY is a fair comment as well, a pitty it didnt...

  • RE: Partial Restoration (Table)

    Hi there

    Your out of luck, there are no sql server tools or commands to recover a single table from a backup. Even so, there are bound to be 3rd...

  • RE: Concurrency Control

    Hi there

    In general, its very important to keep transactions as short as possible, and as "focused" as possible. When I say focused, I mean as few rows/tables as possible...

  • RE: full text search - embedded dots

    i dont know what your talking about

    hic!

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"

  • RE: One big database or many small ones?

    Hi

    I think the developer has asked the right questions here..

    a) do you require cross db table integrity? how else will you manage it if you do and the tables...

  • RE: full text search - embedded dots

    whoa

    my apoligies Mark!

    The table supports multiple names for an org, i was using the wrong identifier to uniquely locate a "group" of names for an org, I altered the code...

  • RE: full text search - embedded dots

    Hi there

    Im not sure about this.. here is my test:

    Org ID Org Name

    1077818 H.B.F HEALTH FUNDS INC

    SELECT orgname_name

    FROM organisation_name

    where CONTAINS(*,...

  • RE: Upgrading to Windows 2003

    Thanks for the comments 🙂

    Btw, just installed a fresh version of win2003, on installing crystal reports 8.5 i noticed that the admin pages didnt render, only to find the application...

Viewing 15 posts - 91 through 105 (of 478 total)