Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,518 total)

  • RE: SSRS - customize parameter-area

    I assume you want something like this?

    + item1

    + item2

    + item3

    - item4

    item41

    item42

    item43

    item44

    + item5

    + item6

    + item7

    That is, you want to...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 29, 2008 at 8:47 am

    #865062

  • RE: How to build a report in SSRS using stored procedure with parameters

    Sorry, I don't follow. Have you specified your parameter in the Report Parameters menu?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 29, 2008 at 8:34 am

    #865053

  • RE: How to build a report in SSRS using stored procedure with parameters

    neneco56 (8/29/2008)

    BUT

    The report itself on SSRS 2005 it's not taking the parameter now.

    so How I fix that? any idea?

    Can you elaborate? What is the error you get?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 29, 2008 at 8:21 am

    #865043

  • RE: How to build a report in SSRS using stored procedure with parameters

    I haven't tried this before, but have you specified the ItemPath parameter under Report Parameters in the report?

    That would be a good place to start.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 29, 2008 at 6:18 am

    #864957

  • RE: How to build a report in SSRS using stored procedure with parameters

    In the Data Tab enter something like this:

    ="EXEC dbo.rpt_MyProcName @param=" & Parameters!MyParam.Value

    Command type should be text.

    Then in your layout, you can set your parameter, MyParam, in the Action property of...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 28, 2008 at 2:37 pm

    #864705

  • RE: Best column choice for clustered index?

    Thanks both for your input, it's much appreciated.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 2:53 pm

    #863998

  • RE: SQL 2005 Missing Indexes

    GSquared (8/27/2008)

    The problem is probably the common misuse of "ie", with "eg" being what was intended. After all, "FROM" is a predicate, just like "WHERE", which would make the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 2:49 pm

    #863991

  • RE: SQL 2005 Missing Indexes

    GilaMonster (8/27/2008)

    The following test was done on SQL Server 2005 Developer edition, SP2

    ...

    Thanks for doing the test, I got the same results running it on my machine, version 9.0.3054 Dev...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 11:54 am

    #863904

  • RE: Best column choice for clustered index?

    GSquared (8/27/2008)

    I missed the TN column in the Where clause. That would be needed too.

    Because of the B-tree nature of indexes, a non-clustered index should do just fine for...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 11:14 am

    #863890

  • RE: SQL 2005 Missing Indexes

    Marios Philippopoulos (8/27/2008)

    "At present, the missing index information is generated only for queries that meet these conditions:

    - The query must have a predicate (ie. a WHERE clause) referencing a column...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 11:03 am

    #863885

  • RE: SQL 2005 Missing Indexes

    GilaMonster (8/27/2008)

    Marios Philippopoulos (8/27/2008)

    One caveat is that indexes used in places other than in the WHERE clause of queries are not included in the DMVs, so, for example, indexes needed...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 10:58 am

    #863884

  • RE: Best column choice for clustered index?

    GilaMonster (8/27/2008)

    Why does it have to be clustered? If it was me, I'd suggest a nonclustered index for that, (TN, CID) INCLUDE (IDt)

    What's the selectivity of TN? How many...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 10:48 am

    #863877

  • RE: Best column choice for clustered index?

    GSquared (8/27/2008)

    If that query is the only thing being considered, how about both?

    create clustered index CIX_Table on dbo.Table (CID, IDt)

    But, as always, things like inserts, updates, deletes, and...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 10:40 am

    #863870

  • RE: SQL 2005 Missing Indexes

    G Bryant McClellan (8/27/2008)

    That part I was aware of. It also skews the index usage counts when a new index is added because you don't necessarily see the difference. You...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2008 at 10:28 am

    #863855

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    rbarryyoung (8/25/2008)

    Why not explicitly run statistics on the tables before you start your transaction?

    For some reason, the following query also hangs. When I abort it, I get this error 3...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 25, 2008 at 3:10 pm

    #862821

Viewing 15 posts - 961 through 975 (of 1,518 total)