Forum Replies Created

Viewing 15 posts - 2,416 through 2,430 (of 7,429 total)

  • RE: QOD 17th Nov

    quote:


    Ok, I got it wrong !?!? too. But I will have to join the rest of this posters because "VERSIONING" is something...

  • RE: QOD 17th Nov

    Ok I am a proponent (big word for the day) ok stored procedure grouping. There biggest advantage are to break out code so that individual execution plans can be stored...

  • RE: DTS and Active X

    You will have to hand parse it with ActiveX by opening each line from the file and verifying the conditions that make it a valid record, split it and post...

  • RE: HOWTO create a database or copy of it

    Scripting is one way but you ould alsoo try backing it up and restoring to another location. From there truncate all the data from the restored copy and that one...

  • RE: Guru needed- Real versus BigInt

    quote:


    quote:


    Actually this is still quite a bit off as there is a lot of...

  • RE: Field Type Order in Tables

    quote:


    Yup, found the text in Inside SQL Server. So far for the storage engine.

    And then there is the relational engine and...

  • RE: Copy SP, UDF between DB's

    In the Export option there is after the destionation screen you can choose to copy objects, then on the next screen there are several options you can change to get...

  • RE: Remote Folder in Linked Server

    What account is SQL Server running under? If Local System you cannot see the mapped drive.

  • RE: Field Type Order in Tables

    With fixed length types like char, int, and so on it makes no difference as they are physically stored first in the record on the file. For non-fixed such as...

  • RE: Passing parameters with '@' in the code.

    quote:


    This looks like it should be as simple as a terminology change in the code.

    Why can't you rename @JULY_ID to @MONTH_ID?

    What are...

  • RE: Cannot sort a row of size 10231

    ORDER BY actually performs this in the tempDB database by creating a table and thus you are limited to the 8k with for the data. You might first get rid...

  • RE: Cursors....here we go again

    What does this do

    --FIRST CASE: Call SP iteratively for each value of @ComponentID

    EXEC @rv-2 = SaveState @ComponentID, @newStateID

    What is the code for the SP?

  • RE: Resolution

    quote:


    Hi,

    how can i change datetime resolution?

    Thanks a lot,

    Jelena


    Can you give me an example of...

  • RE: Memory and performance

    1) I don't know.

    2) Yes, can be sluggish to great depending on indexing. Same engine as the other editions just a little stripped down.

    3) CPU is always important it handles...

  • RE: Can't use SQL2000 without MAPI

    That is using CDONTS which are a component of IIS SMTP service (sorry I would not install). As stated natively SQL uses MAPI, third party applications and writing code for...

Viewing 15 posts - 2,416 through 2,430 (of 7,429 total)