Forum Replies Created

Viewing 15 posts - 811 through 825 (of 1,315 total)

  • RE: deadlocks on updates

    From BOL:

    READPAST can be specified for any table referenced in an UPDATE or DELETE statement, and any table referenced in a FROM clause. When specified in an UPDATE statement, READPAST...

  • RE: Linked Server to VFoxPro Data Files

    Are the tables on the SQL Server or a network share?  The account SQL Server is running under must have access to the files, and if your server is running...

  • RE: Case statement is stored procedure

    CASE is not a flow-of-control statement in T-SQL, it is a function.  Therefore it is used within another statement to provide a value, it doesn't begin a block of statements. ...

  • RE: deadlocks on updates

    Have you tried using locking hints?  I would test it with

        UPDATE Example WITH(ROWLOCK, HOLDLOCK, READPAST)

    This should tell each process to lock the five rows it is working with, hold...

  • RE: Standard or Enterprise

    It is obvious that the perfomance of any server will be affected by the number of simultaneous users.  But 150-200 users is not too many for Standard edition.

    Look at the...

  • RE: Monitoring SQL Server

    Try clicking on the Quest Software ad at at the top of this forum page.

  • RE: How to backup database on remote server with a regular user account?

    PS: Permission issues aside, what's so complicated about typing "BACKUP DATABASE <db> TO DISK='\\server\share\xxxx.BAK' "?

  • RE: How to backup database on remote server with a regular user account?

    SQL Server can backup to anywhere on the network that it has permission to write to.  It is true that if you use Enterprise Manager to run the backup the...

  • RE: Partition in SQL Server 2005

    A brief intro to SQL 2005 partitioning: First you create a partition function, which declares a list of boundary values for the partitions.  Then you create a partition scheme which...

  • RE: Users retained in DB when restoring to alternate server

    A better way is to synchronize the SIDs across your servers so backup/restore or detach/attach will work without cleanup.  There are a number of threads on this site that will...

  • RE: Generating a Sequential Pattern

    I'm not sure how the function will work with multiple rows, I get a duplicate key error when I try it.

    Maybe if it was implemented as a CLR function and...

  • RE: Generating a Sequential Pattern

    Noel, you're confusing me.  "A sequence table is the right idea", but "It is not my preferred way"?  So there's another way you prefer that's better than the ones posted,...

  • RE: Generating a Sequential Pattern

    Yes, this is a much easier problem if you just use an integer identity field.  You could create a view using "STUFF(CAST(invoice_id as char(8)),3,0,'-') as invoice_id" for anything that insists...

  • RE: Generating a Sequential Pattern

    I think this code solves the problem of concurrent inserts.  One SELECT is used to generate the new invoice id, but if another user manages to sneak it in first the...

  • RE: "invalid class string error" when building diagrams

    I can't think of a good reason why you wouldn't upgrade the client tools, since you already upgraded the servers.  I don't think a registry hack will solve the problem.

Viewing 15 posts - 811 through 825 (of 1,315 total)