Forum Replies Created

Viewing 15 posts - 166 through 180 (of 411 total)

  • RE: Indexing for count?

    Thanks everyone. I prefer the indexed view option as that returns the best results I've seen yet, but it causes some issues for the developpers.

    The nonclustered index Gail suggested...

  • RE: SQL Server, Creating a View

    washingtonen (12/14/2008)


    wow Barry, thanks a million!!!! your help is highly appreciated. I will try it and get back to you. Now, how do I call a function from a...

  • RE: Indexing for count?

    GilaMonster (12/14/2008)


    timothyawiseman (12/13/2008)


    I also indexed the group by column before initially posting, and it definitely helps, but I was wondering if there was something that could specifically aid with counts,...

  • RE: SQL Server, Creating a View

    washingtonen (12/13/2008)


    This is the original SQL

    SELECT

    case when failed = 'N' then

    (select * from dim_concept)

    else

    (select * from vw_dim_concept)

    end

    FROM

    flagsta

    and those the errors when i execute...

  • RE: SQL Server, Creating a View

    Depending on exactly what you are trying to do you may want to look at one of two approaches:

    You may wish to consider a table valued function instead of a...

  • RE: Need help using SSIS to transform a flat file into SQL table

    Michael Earl (12/11/2008)


    As an alternative, you could import the records into a staging table and use T-SQL to merge together the appropriate rows. Aggregating and concatenating strings like this...

  • RE: Indexing for count?

    Steve Jones - Editor (12/13/2008)


    For a clustered index, the row count should be stored in a system table, so that should be quick.

    For the first, if you had an index...

  • RE: Automating Excel from SQL Server

    Joseph M. Steinbrunner (12/5/2008)


    It is very interesting to note this is possible, however as others have mentioned, it has significant drawbacks. You must have Excel installed on the...

  • RE: Which is better

    Jeff Moden (12/6/2008)


    Actually, I'll take door #3 😛 ... performance is the same as WHERE EXISTS and it's even easier to read especially for newbies that may be on the...

  • RE: Power and Deception of CTEs

    Jeff Moden (12/6/2008)


    timothyawiseman (12/5/2008)


    To slightly modify a quote from Larry Wall, "SQL is designed to give you several ways to do anything, so consider picking the most readable one."

    I'm definitely...

  • RE: Which is better

    Steve Jones - Editor (12/1/2008)


    I'm with Jack. #2 is easier to read, but I'd suspect that #1 works better.

    While I know this is a matter of opinion, I found 1...

  • RE: Power and Deception of CTEs

    G Bryant McClellan (12/1/2008)


    Jeff Moden (12/1/2008)


    Good article... but, because of the title, I was actually expecting to see something about a problem or technique with CTE's that couldn't be done...

  • RE: The Fear of Change

    GilaMonster (12/2/2008)


    The DBA job is broadening, for sure, but going away? I doubt it.

    I completely agree with Gail. My job title is DBA, but I automated most of the...

  • RE: Finding Values With Numerous Columns

    Douglas Osborne (12/3/2008)


    Tim,

    Why use LIKE if you are not adding % - shouldn't you just say = instead then?

    Doug

    For flexibility, I wanted to be able to use a wildcard such...

  • RE: Finding Values With Numerous Columns

    Douglas Osborne (12/3/2008)


    Hey,

    This didn't work for me until I added a % at the end of the first dynamic SQL statement:

    SELECT @sql = CASE

    WHEN...

Viewing 15 posts - 166 through 180 (of 411 total)