Forum Replies Created

Viewing 15 posts - 901 through 915 (of 1,518 total)

  • RE: Memory used by a sql process is 2.5 GB on 32-bit box. WHY??

    Fraggle (9/30/2008)

    Is the /3GB swith active? If so, this could explain it.

    If not, then I am clueless.

    Fraggle

    Thank you, that makes sense.

    I'm looking for the boot.ini file but...

    __________________________________________________________________________________
    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]

    September 30, 2008 at 10:26 am

    #878981

  • RE: Using FormatCurrency in SSRS 2005

    abhijeetv (9/29/2008)

    I have copy-pasted the text in your messege and tested with 20000 as well as 615.00 hard-coded values, I do not get error in the out put but I...

    __________________________________________________________________________________
    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]

    September 29, 2008 at 8:43 am

    #878433

  • RE: Moving mail accounts to new Exchange Server - does SQL need to be restarted?

    We tried the move for mail accounts on servers using both OUTLOOK (sql mail) and SMTP (db mail) to send mail.

    For SQL Server 2005 instances using smtp (db mail): All...

    __________________________________________________________________________________
    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]

    September 26, 2008 at 11:59 am

    #877883

  • RE: Moving mail accounts to new Exchange Server - does SQL need to be restarted?

    Steve Jones - Editor (9/26/2008)

    Is there a stop/start in 2005 as there was in 2000? Don't see one, and I think that each time you call the XP, it logs...

    __________________________________________________________________________________
    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]

    September 26, 2008 at 11:21 am

    #877859

  • RE: MY opinion of SQL Server 2005 so far . . . not good

    Will Summers (9/26/2008)

    To be fair though, there are some new nice features as well. Here is one: being able to monitor a job running in the little popup dialog, after...

    __________________________________________________________________________________
    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]

    September 26, 2008 at 11:08 am

    #877849

  • RE: MY opinion of SQL Server 2005 so far . . . not good

    It's true that SSMS 2005 has its problems. My main peeve is the excessive memory resources it requires. I have often had to use Task manager to kill the SSMS...

    __________________________________________________________________________________
    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]

    September 26, 2008 at 10:15 am

    #877825

  • RE: Using FormatCurrency in SSRS 2005

    Sorry guys, but I'm not getting the right results.

    Take this NUMERIC(16,2) value: 615.00

    When I use:

    ="$" & Format(Fields!col1.Value,"##,###,##0.00")

    I get: $615615.00

    When I use:

    =FormatNumber(Fields!col1.Value, 2, , ,TriState.True)

    I get syntax error.

    When I...

    __________________________________________________________________________________
    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]

    September 26, 2008 at 8:18 am

    #877736

  • RE: Using FormatCurrency in SSRS 2005

    Marios Philippopoulos (9/25/2008)

    Glen (9/25/2008)

    = "$" & Format(Fields!Field1.value,"##,###,##0.00")

    thank you! I'll try that.

    Actually, this is not giving me the right results:

    I have this value in the database: 615.00000

    In the report it shows...

    __________________________________________________________________________________
    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]

    September 25, 2008 at 3:27 pm

    #877369

  • RE: Using FormatCurrency in SSRS 2005

    Glen (9/25/2008)

    = "$" & Format(Fields!Field1.value,"##,###,##0.00")

    thank you! I'll try that.

    __________________________________________________________________________________
    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]

    September 25, 2008 at 12:58 pm

    #877281

  • RE: What to backup before installing a Service Pack?

    Registry: back up the Microsoft SQL Server node under HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft.

    Installation: copy the SQL installation folder to a safe location, preferably on another machine or network share....

    __________________________________________________________________________________
    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]

    September 25, 2008 at 9:32 am

    #877102

  • RE: Linked server query suspended on ASYNC_NETWORK_IO

    John Marsh (9/20/2008)

    Hello,

    Does this problem happen every time or is it just a one of?

    If it has just happened once then may be check the account under which you are...

    __________________________________________________________________________________
    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]

    September 20, 2008 at 5:10 am

    #874578

  • RE: Is there any possible reason to have a non-clustered index on a table without a clustered index at all?

    Vivien Xing (9/18/2008)

    Additional info, it is a reporting database. The fragmentation is very bad.

    Clustered indexes are most beneficial in range queries, ie. those including clauses (such as GROUP BY,...

    __________________________________________________________________________________
    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]

    September 18, 2008 at 10:08 am

    #873746

  • RE: How to determine last time log growth happened

    dmc (9/17/2008)

    I want to determine the last time a database (the tempdb) experienced an increase in the data file size. Is there a way to determine the day/time when...

    __________________________________________________________________________________
    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]

    September 17, 2008 at 5:20 pm

    #873311

  • RE: SSRS 2005 - Allowing a page break within a table cell

    I don't think it's possible but I'd be very interested in being proven wrong.

    __________________________________________________________________________________
    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]

    September 17, 2008 at 5:09 pm

    #873309

  • RE: Indexed Columns Duplicated

    Run the following query on a schedule and store in a table for later analysis:

    SELECT

    OBJECT_NAME( s.[object_id] ) AS TableName

    ,i.name AS IndexName

    ,s.user_updates

    FROM

    sys.dm_db_index_usage_stats s

    INNER JOIN

    sys.indexes i

    ON

    s.object_id = i.object_id

    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]

    September 17, 2008 at 2:16 pm

    #873260

Viewing 15 posts - 901 through 915 (of 1,518 total)