Forum Replies Created

Viewing 15 posts - 361 through 375 (of 496 total)

  • RE: To delete temp tables or not to?

    quote:

    If you are using SQL2000, you could try the new table datatype. Check out 'Using Special Data' in BOL for an example.

    October 23, 2003 at 8:18 am

    #479304

  • RE: Using (nolock) hint on a system table

    So there is no way to run a query with (nolock) on this table and such queries will always degrade serve performance?

    It is really bad day

    October 14, 2003 at 5:38 am

    #478115

  • RE: To delete temp tables or not to?

    quote:

    Now you seem to be referring to local temporary tables created outside of stored procedures. As Jeremy wrote, you do not...

    October 9, 2003 at 12:25 am

    #477659

  • RE: To delete temp tables or not to?

    quote:

    Each connection will create its own version of the temporary table. Otherwise, if two users were connected at the same time...

    October 8, 2003 at 7:31 am

    #477541

  • RE: To delete temp tables or not to?

    quote:

    Don't know if it is really necessary, but whether your sproc deletes the tables or leave this to SQL Server, the overhead...

    October 8, 2003 at 6:54 am

    #477527

  • RE: MDAC Version

    1. ...\Program Files\Common Files\System\ado

    Just check versions of dll files (i.e. msado15.dll)

    2. Parameters FullInstallVer and Version in registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess

    3. "Component Checker", from Microsoft site:

    HOW TO: Check for MDAC...

    October 7, 2003 at 6:01 am

    #477347

  • RE: waitresource field 4 blocked & blocking processes

    Figured this out!

    The reason was a poor database design. It contained a table that was referenced...

    October 2, 2003 at 11:25 pm

    #476909

  • RE: Unusual update

    This is all, cause I was blind!

    I misplaced the braces: 

    

    IF NOT EXISTS (SELECT * FROM ::fn_get_sql(@who_sql_handle))

    UPDATE  BLOCKS_HISTORY

    SET who_sql = 'NOT...

    October 2, 2003 at 5:13 am

    #476716

  • RE: On delete trigger for a view

    quote:

    ...One does not drop a database by deleting it from sysdatabases or an updatable view on sysdatabases.

    September 30, 2003 at 8:48 am

    #476381

  • RE: DRI permission for a function

    quote:

    Delarative Referential Integrity. Means you have FK reference permissions needed.

    Can you give some examples when...

    September 30, 2003 at 7:58 am

    #476366

  • RE: Column update

    My best wish is to figure out where this came from...

    Perhaps he added a spare step for a job, or created a separate job on another server, etc.

    September 29, 2003 at 8:11 am

    #476217

  • RE: Column update

    You mean placing an 'on update' trigger on the table?

    BTW, I, myself do some update within my job on this table, so this will not work.

    Another reason is that it...

    September 29, 2003 at 8:09 am

    #476216

  • RE: Permissions to run extended procedures sp_OACreate

    quote:

    hey steve! may your site is more valuable than you know, because there's been something called xp_msmq.dll up for a couple of...

    September 26, 2003 at 7:13 am

    #475983

  • RE: How many channels to use.

    quote:

    If you're using hot-plug drives, and I hope you are, then you will need a backplane for each channel. There will...

    September 26, 2003 at 7:10 am

    #475982

  • RE: Trying a new way to use fn_get_sql()

    It is kind of analog to DBCC INPUTBUFFER

    The difference is that this function returns the highest nest level, while DBCC INPUTBUFFER,- the lowest.

    It came with sp3. You can find...

    September 26, 2003 at 3:59 am

    #475948

Viewing 15 posts - 361 through 375 (of 496 total)