Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Information Poll

    RSS feeds for blogs. I am following nearly 80 different feeds using bloglines. Today there where 28 new blog posts in my SQL section.

  • RE: Creating HUGE TEXT FILE HELP!!!!

    Are you doing this in Query Analyzer? If so, in options under results the max number of characters returned for a single column is 256. Change it to what you...

  • RE: How to encorporate IF

    try this in place of your code.

    SELECT RMSFILENUM,

    sum(rmstranamt) AS rmstranamt10 1 or not

    FROM RFINANL

    WHERE RMSTRANCDE = '10'

    GROUP...

  • RE: Sysindexes table

    yes those values are correct if you perform a bitwise and comparison on the value and a nonzero value is returned. This must be performed for each status value, since...

  • RE: Sysindexes table

    To find out some information, look in the master db for sp_helpindex. Stats are used to indicate the following:

    ignore duplicate keys

    unique

    ignore duplicate rows

    hypothetical

    statistics

    primary key

    unique key

    auto create

    stats no recompute

  • RE: No More Waits

    In general, upgrading injects a lot of chaos in the enterprise and we try to avoid it. When MS added Reporting services to the tool set for SQL Server that...

  • RE: A SAN Primer

    I have to agree that in my experience DAS is a better solution is some cases. I recently worked on a project where the size of the databases ranged up...

  • RE: interesting results with forceplan

    While I won't say this relates to your problem, I have run across similar types of odd behavior. On one occasion the presence of other indexes on the table was...

Viewing 8 posts - 1 through 8 (of 8 total)